RE: [PHP-INST] PHP + OPENLINK (DON'T WORK)
| From: | Andrew Hill | Date: | Wed, 13 Dec 2000 18:48:37 +0000 |
| Subject: | RE: [PHP-INST] PHP + OPENLINK (DON'T WORK) | ||
| References: | 1 | Groups: | php.dev php.general php.install |
| Request: | Send a blank email to php-dev+get-41205@lists.php.net to get a copy of this message | ||
Hi Georges,
The Openlink consultant working on your case is exploring a fix today.
Please direct any followup there.
As soon as we've identified a fix I'll notify the PHP groups.
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 6:33 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, $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
>
> --
> 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
>
>
>