PHP 4.0 Bug #3448 Updated: odbc_connect problem with PHP4 and oracle

ID: 3448 User Update by: drax@usa.net Status: Open Bug Type: ODBC related Description: odbc_connect problem with PHP4 and oracle A few more details: PHP3 (ODBC Driver) finds the TNS information in c:/orant/net80/admin/tnsnames.ora PHP4 (no idea what it has to do with tnsnames) doesn't even find tnsnames.ora (found that out when I renamed the file tnsnames.ora) Someone stated that PHP4 provides a different environment for locating the tnsnames.ora file. Any ideas on that? Logfile: php 159:71 ENTER SQLAllocEnv HENV * 0x00322820 php 159:71 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS) HENV * 0x00322820 ( 0x00ca1440) php 159:71 ENTER SQLAllocConnect HENV 0x00ca1440 HDBC * 0x00322824 php 159:71 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS) HENV 0x00ca1440 HDBC * 0x00322824 ( 0x00ca14e8) php 159:71 ENTER SQLSetConnectOption HDBC 0x00ca14e8 UWORD 110 <SQL_ODBC_CURSORS> UDWORD 1 php 159:71 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS) HDBC 0x00ca14e8 UWORD 110 <SQL_ODBC_CURSORS> UDWORD 1 php 159:71 ENTER SQLConnectW HDBC 0x00ca14e8 WCHAR * 0x00ca15f0 [ -3] "aur001\ 0" SWORD -3 WCHAR * 0x1f4be068 [ -3] "******\ 0" SWORD -3 WCHAR * 0x1f4be068 [ -3] "******\ 0" SWORD -3 php 159:71 EXIT SQLConnectW with return code -1 (SQL_ERROR) HDBC 0x00ca14e8 WCHAR * 0x00ca15f0 [ -3] "aur001\ 0" SWORD -3 WCHAR * 0x1f4be068 [ -3] "******\ 0" SWORD -3 WCHAR * 0x1f4be068 [ -3] "******\ 0" SWORD -3 DIAG [08001] [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:Der Servicename konnte nicht aufgelöst werden. (12154) php 159:71 ENTER SQLErrorW HENV 0x00ca1440 HDBC 0x00ca14e8 HSTMT 0x00000000 WCHAR * 0x0012fb64 (NYI) SDWORD * 0x0012fbb0 WCHAR * 0x0012f764 SWORD 254 SWORD * 0x0012fbae php 159:71 EXIT SQLErrorW with return code 0 (SQL_SUCCESS) HENV 0x00ca1440 HDBC 0x00ca14e8 HSTMT 0x00000000 WCHAR * 0x0012fb64 (NYI) SDWORD * 0x0012fbb0 (12154) WCHAR * 0x0012f764 [ 105] "[Microsoft][ODBC driver for Oracle][Oracle]ORA-12154" SWORD 254 SWORD * 0x0012fbae (105) php 159:71 ENTER SQLErrorW HENV 0x00ca1440 HDBC 0x00ca14e8 HSTMT 0x00000000 WCHAR * 0x0012fb64 (NYI) SDWORD * 0x0012fbb0 WCHAR * 0x0012f764 SWORD 254 SWORD * 0x0012fbae php 159:71 EXIT SQLErrorW with return code 100 (SQL_NO_DATA_FOUND) HENV 0x00ca1440 HDBC 0x00ca14e8 HSTMT 0x00000000 WCHAR * 0x0012fb64 (NYI) SDWORD * 0x0012fbb0 WCHAR * 0x0012f764 SWORD 254 SWORD * 0x0012fbae php 159:71 ENTER SQLFreeConnect HDBC 0x00ca14e8 php 159:71 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS) HDBC 0x00ca14e8 Full Bug description available at: http://bugs.php.net/version4/?id=3448