RE: [PHP-INST] PHP + OPENLINK (DON'T WORK)

Hi Georges, I believe you are experiencing a known issue with SQLDirectExec call (odbc_exec and odbc_do use this). You can try to replace odbc_exec with odbc_prepare, followed by odbc_execute. Also, please open a support case at http://www.openlinksw.com/support/suppindx.htm so that we may help you resolve this directly. Best regards, Andrew ---------------------------------------------------- Andrew Hill Director Technology Evangelism OpenLink Software http://www.openlinksw.com XML & E-Business Infrastructure Technology Provider > -----Original Message----- > From: Georges da Mata Claessen [mailto:georges@embrapa.br] > Sent: Wednesday, December 13, 2000 5:46 AM > To: php-general@lists.php.net; php-install@lists.php.net; > php-dev@lists.php.net > Subject: [PHP-INST] PHP + OPENLINK (DON'T WORK) > > > I'm using OPENLINK to access INGRES but the ODBC_EXEC function insists > on giving me this error message: > > Warning: SQL error: [OpenLink][ODBC][Driver]Syntax error or access, SQL > state 37000 in SQLExecDirect in > /software/apache/htdocs/estagio/teste/testedesenv.htm on line 7 > > Everything was running fine until we installed PHP 4. I can connect to > the database but ODBC_EXEC is not working properly. For sure it has a > bug but I couldn't recognize where. All the applications were running > fine on PHP 3, but PHP 4 don't work with OPENLINK. IT SIMPLY DON'T > WORK!!! I'm under SUN SOLARIS 2.7. Please if anyone from PHP.NET could > help I would be very gratefull, specially because this error was noticed > by many people... Did the ODBC_EXEC or ODBC_CONNECT syntax changed? > Please take a look at my code: > > $connectionID = odbc_connect("DSN=Desenv;UID=notes","",""); > $echo $connectionID; //OUTPUT: Resource id #1 > $querySelect = "select * from RTVTB000"; > $queryResult = odbc_exec($connectionID, $queryResult); //ERROR REPORTED > > Warning: SQL error: [OpenLink][ODBC][Driver]Syntax error or access, SQL > state 37000 in SQLExecDirect in > /software/apache/htdocs/estagio/teste/testedesenv.htm on line 7 > > -- > PHP Install Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-install-unsubscribe@lists.php.net > For additional commands, e-mail: php-install-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >