PHP + OPENLINK (DON'T WORK)

From: Date: Wed, 13 Dec 2000 11:33:18 +0000
Subject: PHP + OPENLINK (DON'T WORK)
Groups: php.dev php.general php.install 
Request: Send a blank email to php-dev+get-41158@lists.php.net to get a copy of this message
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, $querySelect); //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

« previous php.dev (#41158) next »