[PHP-DEV] RE: [PHP-INST] PHP + OPENLINK (DON'T WORK) From: Andrew Hill (ahill <email protected>)
Date: 12/13/00

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 <email protected>]
> Sent: Wednesday, December 13, 2000 5:46 AM
> To: php-general <email protected>; php-install <email protected>;
> php-dev <email protected>
> 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 <email protected>
> For additional commands, e-mail: php-install-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
>
>
> 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>