RE: [PHP] php4.0.1pl2, unixODBC-1.8.10 and odbc_prepare, odbc_execute

Luc, Try using the iODBC driver manager instead of the stock one with UnixODBC. It's available at www.iodbc.org. You should be able to use the UnixODBC drivers with the other Driver Manager. Best regards, Andrew ---------------------------------------------------- Andrew Hill Professional Services Consultant OpenLink Software http://www.openlinksw.com Universal Database Connectivity Technology Providers > -----Original Message----- > From: Luc Bouchard [mailto:lbouchard@gameloft.com] > Sent: Wednesday, August 16, 2000 4:12 PM > To: php-general@lists.php.net > Subject: [PHP] php4.0.1pl2, unixODBC-1.8.10 and odbc_prepare, > odbc_execute > > > Hello, > > When trying to use odbc_prepare/odbc_execute with parameters, I get the > following error message coming from the unixODBC driver manager: > > Warning: SQL error: [unixODBC][Driver Manager]Driver does not support this > function, SQL state IM001 in SQLExecute in > /home/lbouchard/public_html/php4/test.php on line 14 > > Here is my code: > > <?PHP > > $hdbc = odbc_connect(CM_Luc,"sa",""); > $query_string = "insert into users (name) values (?)"; > $param = "testname"; > $parameters = array($param); > $hstmt = odbc_prepare($hdbc, $query_string); > odbc_execute($hstmt,&$parameters); > > ?> > > Does anybody know what's wrong ? > > ________________________ > Luc Bouchard, Ing. > GameLoft.com > mailto:lbouchard@gameloft.com > http://www.gameloft.com > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >