RE: PHP + OPENLINK (DON'T WORK)

Hi George, Please relay your case # to me, so I can follow up 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 Claessen [mailto:georges@embrapa.br] > Sent: Wednesday, December 13, 2000 9:53 AM > To: ahill@openlinksw.com > Cc: php-general@lists.php.net; php-install@lists.php.net; > php-dev@lists.php.net > Subject: 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 a unknown but 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 > > >