php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #3448 odbc_connect problem with PHP4 and oracle
Submitted: 2000-02-10 12:29 UTC Modified: 2000-06-20 12:08 UTC
From: drax at usa dot net Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0 Beta 3 OS: NT 4
Private report: No CVE-ID: None
View Add Comment Developer Edit
 [2000-02-10 12:29 UTC] drax at usa dot net 
After migrating from PHP3 to PHP4 Beta3 I encounter a problem with odbc_connect.
The error result from the ODBC driver (oracle) reads:
"SQL error: [Microsoft][ODBC driver for Oracle][Oracle]ORA-12154: TNS:Unable to resolve Servicename., SQL state 08001 in SQLConnect in ... - Can't connect to database"
I started a trace and couldn't see any differences except that the connect failed.
The same script / DSN configuration works fine with PHP3 3.0.14

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-02-29 06:25 UTC] drax at usa dot net 
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
 [2000-02-29 09:24 UTC] kara at cvs dot php dot net 
The Oracle ODBC driver is only a kind of "wrapper" around the
oracle OCI libraries. So it seems as if the environment that
php runs in is different for your php3 and php4 installation.
BTW: ODBC Support in Beta4 is broken, working again in CVS
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sat May 04 01:01:49 2024 UTC