PHP + OPENLINK (DON'T WORK)
| From: | Georges da Mata Claessen | 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