RE: [PHP-DB] PHP4-ODBC-MSSQL7

Micheal, If things work in Query but not PHP you can easily get an under-the-covers comparison of the ODBC calls by turning on Tracing in the ODBC Administrator (Driver Manager). Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -----Original Message----- > From: Michael Yevdokimov [mailto:michaely@globalocity.com] > Sent: Tuesday, July 10, 2001 7:09 AM > To: php-db@lists.php.net > Subject: [PHP-DB] PHP4-ODBC-MSSQL7 > > > Hello Everyone!! > > We are making on the project with PHP4 and MSSQL7. Everything is based on > NT4 platform. > Certainly, in this case we are operating by SQL stored procedures. > > The question is.. > > I found some problems while extracting data from database over ODBC > which we need to use to make a bridge between PHP and MSSQL. > > For example, we created a table with columns: > > col_subj_id int > col_subj_owner_id int > col_subj_last_update timestamp(8) > col_subj_title varchar(512) > col_subj_content text(16) > col_subj_keywords varchar(256) > col_subj_secur int > col_subj_reg_page varchar(128) > > > Then I try to execute a stored procedure usp_get_subj: > > Create Procedure usp_get_subj > ( > @subj_id int > ) > As > SELECT * > FROM tbl_subject > WHERE col_subj_id = @subj_id > > RETURN > > Well, everything is working in Query Analyzer and in ASP but not in > PHP... > > If obviously to define the column names like: > > SELECT > col_subj_id, > col_subj_owner_id, > col_subj_last_update, > col_subj_title, > col_subj_content, > col_subj_keywords, > col_subj_secur, > col_subj_reg_page > FROM tbl_subject > WHERE col_subj_id = @subj_id > > it will not be working either... > > But! If to order the columns in the query of the stored procedure by > data types like: > > SELECT col_subj_id, -- int > col_subj_owner_id, -- int > col_subj_secur, -- int > col_subj_last_update, -- timestamp(8) > col_subj_title, -- varchar(512) > col_subj_reg_page, -- varchar(128) > col_subj_keywords, -- varchar(2560 > col_subj_content -- text(16) > FROM tbl_subject > WHERE col_subj_id = @subj_id > > > everything will be working pretty good.. > > > WHY????????????? > > Do you have any ideas on this subject? ;-) > > Hope to obtain help from your side.. > > Thank you in advance. > > Mike > > P.S. > > The friend of mine who is ASP programmer just told me that there > was such a > problem with the old versions of ODBC. I am not sure but I am afraid that > the PHP's ODBC support is aimed on that old ODBC driver. Could anyone > advice me anything on this subject please? > > <?php > include ('config.inc'); > > // script itself: > > $rs_gp = call_stored_procedure("usp_get_subj $QUERY_subj"); > while (fetch_row($rs_gp)) { > $DB_home_text = get_field($rs_gp, "col_subj_content"); > } > $rs_gp = ""; > ?> > > > <?php > // config.inc > > // database settings > $DB_dsn = "dsn_sundown"; > $DB_user = "sundown"; > $DB_pass = ""; > include ('database.php'); > ?> > > <?php > // database.inc > > // call the stored procedure > function call_stored_procedure($query) > { > $conn = get_connection($GLOBALS["DB_dsn"], $GLOBALS["DB_user"], > $GLOBALS["DB_pass"]); > $result = odbc_exec($conn, $query); > return $result; > odbc_close($conn); > }; > > // get the connection handle > function get_connection($dsn, $user, $pass) > { > $GLOBALS["conn"] = odbc_connect($dsn, $user, $pass); > return $GLOBALS["conn"]; > }; > > // retrieve the row of data > function fetch_row($rs) > { > return odbc_fetch_row($rs); > }; > > // retrieve the field of data > function get_field($rs, $field) > { > > if (!$rs) > { > $res = "No data was returned.."; > } > > if ($rs) > { > > $res = odbc_result($rs, $field); > /* > $no_r = odbc_num_rows($rs); > $no_f = odbc_num_fields($rs); > > for ($i=1; $i<=$no_f; $i++) > { > $fn = odbc_field_name ($rs, $i); > if ($fn == $field) > { > $res = odbc_result($rs, $field); > break; > } > } > */ > } > return $res; > }; > ?> > > > Michael Yevdokimov > Web developer > e-mail: michaely@globalocity.com > > -------------------------------- > Globalocity B.V. > Tel.: +31 (0)70 312 2814 > Fax.: +31 (0)70 312 2808 > http://www.globalocity.com > e-mail: info@globalocity.com > -------------------------------- > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >