|
|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2007-07-09 12:07 UTC] jani@php.net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Tue May 13 01:01:28 2025 UTC |
Description: ------------ Using odbc_connect is resulting in SQL state 08001 when using third party odbc driver. ODBC client program isql connects ok using the same driver. What are the primary differences between the two methods. Tracing of the third party application suggests the connection request is being made. The configure line is: './configure' '--with-apxs2=/usr/local/apache-2.0.54/bin/apxs' '--prefix=/usr/local/apache-2.0.54/php' '--enable-threads=posix' '--enable-cgi-redirect' '--with-mysql=/usr/local/mysql' '--with-oci8=shared,instantclient,/var/opt/oracle/instantclient' '--enable-sigchild' '--enable-inline-optimization' '--with-zlib' '--with-gd' '--with-freetype-dir=/usr/local/freetype-2.2.1' '--with-pdflib=/usr/src/packages/PDFlib-6.0.3p1-SunOS-sparc/bind/c' '--with-jpeg-dir=/usr/local/lib' '--with-png' '--with-ttf' '--with-xpm-dir=/usr/local' '--enable-gd-native-ttf' '--with-unixODBC=/usr/local' Reproduce code: --------------- <html> <head></head> <body> <?php $dsn="dave-1"; $db_user=""; $db_pwd=""; echo "Opening connection to Reality host moon-1 using dsn ".$dsn.". Please wait...<br />"; $rfp = odbc_connect($dsn, $db_user, $db_pwd); if($rfp){ echo "Connected to ".$dsn; } else { echo "Connection failed!"; } echo "<hr>"; phpinfo(); ?> </body> </html> Expected result: ---------------- A connection to remote system allowing queries to be executed