Re: odbc errors

P.S. One of the users there mentions that she had to open the odbc_free_result INTO a variable in order for it to work: $free_result = odbc_free_result($sql_result); for example Angie >>> "Jello" <jerry23@madasafish.com> 05/15/01 10:27AM >>> i've just upgraded my computer... running win ME ( i know), PWS and PHP 4.0.5 and access 2000 (odbc) ... the same set up as my last one... i keep getting error msg from scripts that worked only last week on the old setup... the DB is ok as it will connect prepare and execute with no error... but then i get the following msg's Warning: Supplied argument is not a valid ODBC result resource in \include\db1.txt on line 18 which is odbc_result_all($sql_result,"border=1"); nothing to fancy there and the same message Warning: Supplied argument is not a valid ODBC result resource in \include\db1.txt on line 21 which is odbc_free_result ($sql_result); again just a basic action... nothing fancy it's strange as all the other bits of the scripts work with no problems so i think its the ODBC set up. but that is where i step out of the light in to a very dark room and it's driving me nuts...any help or pointers would be cool... MTIA Jello a copy of the whole script is below.... <?php // connect to system dsn odbc name login and password or die $connect = odbc_connect("db1","login","pword") or die (" not connected"); // create SQL statement $sql = "SELECT id,code,matchcode FROM products "; // prepare SQL statement $sql_prepare = odbc_prepare($connect,$sql) or die("Couldn't prepare query."); // execute SQL statement and get results $sql_result = odbc_execute($sql_prepare) or die("Couldn't execute statement."); // echo the result in a nice table odbc_result_all($sql_result,"border=1"); // free up resources odbc_free_result ($sql_result); // close connection odbc_close($connect); ?> -- 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