PHP + OPENLINK (DON'T WORK)

It didn´t work too, I tried it and it didn't work. This solution was given by another guy from Openlink SW, but it is not working... This is becoming complicated. We asked the OPENLINK SW helpdesk but we got this answer too... I think there is an unknown bug there and many users are experiencing the same problem.... If this situation doesn´t change we unfortunately will have to change our ODBC driver... Andrew Hill wrote: > 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 > > > > > > > > -- > 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 -- PHP Development Mailing List <http://www.php.net/> To unsubscribe, e-mail: php-dev-unsubscribe@lists.php.net For additional commands, e-mail: php-dev-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net