PHP 4.0 Bug #5814 Updated: ODBC connection to Oracle fails
| From: | Bug Database | Date: | Thu, 27 Jul 2000 18:08:27 +0000 |
| Subject: | PHP 4.0 Bug #5814 Updated: ODBC connection to Oracle fails | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-26532@lists.php.net to get a copy of this message | ||
ID: 5814
User Update by: fsegtrop@estiem.org
Status: Open
Bug Type: ODBC related
Description: ODBC connection to Oracle fails
With PHP3, the following log file is created:
php 134:11c ENTER SQLAllocEnv
HENV * 0x00486a40
php 134:11c EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x00486a40 ( 0x00aa1440)
php 134:11c ENTER SQLAllocConnect
HENV 0x00aa1440
HDBC * 0x00bc0490
php 134:11c EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 0x00aa1440
HDBC * 0x00bc0490 ( 0x00aa14e8)
php 134:11c ENTER SQLSetConnectOption
HDBC 0x00aa14e8
UWORD 110 <SQL_ODBC_CURSORS>
UDWORD 0
php 134:11c EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 0x00aa14e8
UWORD 110 <SQL_ODBC_CURSORS>
UDWORD 0
php 134:11c ENTER SQLConnectW
HDBC 0x00aa14e8
WCHAR * 0x00aa15f0 [ -3] "WEP2000\ 0"
SWORD -3
WCHAR * 0x1f4be068 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1f4be068 [ -3] "******\ 0"
SWORD -3
php 134:11c EXIT SQLConnectW with return code 0 (SQL_SUCCESS)
HDBC 0x00aa14e8
WCHAR * 0x00aa15f0 [ -3] "WEP2000\ 0"
SWORD -3
WCHAR * 0x1f4be068 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1f4be068 [ -3] "******\ 0"
SWORD -3
With PHP4, the log file is:
php f1:121 ENTER SQLAllocEnv
HENV * 0x00567f80
php f1:121 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS)
HENV * 0x00567f80 ( 0x00a61440)
php f1:121 ENTER SQLAllocConnect
HENV 0x00a61440
HDBC * 0x00567f84
php f1:121 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS)
HENV 0x00a61440
HDBC * 0x00567f84 ( 0x00a614e8)
php f1:121 ENTER SQLSetConnectOption
HDBC 0x00a614e8
UWORD 110 <SQL_ODBC_CURSORS>
UDWORD 0
php f1:121 EXIT SQLSetConnectOption with return code 0 (SQL_SUCCESS)
HDBC 0x00a614e8
UWORD 110 <SQL_ODBC_CURSORS>
UDWORD 0
php f1:121 ENTER SQLConnectW
HDBC 0x00a614e8
WCHAR * 0x00a615f0 [ -3] "WEP2000\ 0"
SWORD -3
WCHAR * 0x1f4be068 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1f4be068 [ -3] "******\ 0"
SWORD -3
php f1:121 EXIT SQLConnectW with return code -1 (SQL_ERROR)
HDBC 0x00a614e8
WCHAR * 0x00a615f0 [ -3] "WEP2000\ 0"
SWORD -3
WCHAR * 0x1f4be068 [ -3] "******\ 0"
SWORD -3
WCHAR * 0x1f4be068 [ -3] "******\ 0"
SWORD -3
DIAG [S1000] [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-12154: TNS:Der Servicename konnte nicht
aufgelöst werden.. (12154)
Again, both on the same machine, with exaclty the same ORACLE-installation.
Full Bug description available at: http://bugs.php.net/?id=5814