Hi all,
I am using the Apache webserver bundled with Oracle PE and I am getting
the following error:
[Sat Jan 15 10:34:41 2005] [error] [client 151.110.117.153] DBI
connect('ILOG','system',...) failed: [Microsoft][ODBC driver for
Oracle][Oracle]ORA-12514: TNS:listener could not resolve SERVICE_NAME
given in connect descriptor (SQL-NA000)
[Sat Jan 15 10:34:41 2005] [error] [client 151.110.117.153]
[Microsoft][ODBC Driver Manager] The driver doesn't support the version
of ODBC behavior that the application requested (see SQLSetEnvAttr).
(SQL-01000)(DBD: db_login/SQLConnect err=-1) at
c:\oracle\ora92\apache\apache\ittweb\cgi-bin\ilog.pl line 23
I am able to connect to the database using the same SERVICE_NAME using
TOAD. The tnsnames.ora looks right also:
ILOG.NAPA.AD.ETN.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SLPMXWMORENOJAV)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ILOG)
)
)
Could someone please help?
Regards,
Javier Moreno
