#38749 [NEW]: odbc_connect failing on Unix platform

From: david dot rothwell at wolseley dot co dot uk Operating system: SunOS 5.9 PHP version: 5.1.6 PHP Bug Type: ODBC related Bug description: odbc_connect failing on Unix platform 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 -- Edit bug report at http://bugs.php.net/?id=38749&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=38749&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=38749&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=38749&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=38749&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=38749&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=38749&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=38749&r=needscript Try newer version: http://bugs.php.net/fix.php?id=38749&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=38749&r=support Expected behavior: http://bugs.php.net/fix.php?id=38749&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=38749&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=38749&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=38749&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=38749&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=38749&r=dst IIS Stability: http://bugs.php.net/fix.php?id=38749&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=38749&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=38749&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=38749&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=38749&r=mysqlcfg