Javier, This is not a Perl/ODBC issue. This is a problem with Oracle. From the oerr utility:
12514, 00000, "TNS:listener could not resolve SERVICE_NAME given in connect descriptor" // *Cause: The SERVICE_NAME in the CONNECT_DATA was not found in // the listener's tables. // *Action: Check to make sure that the SERVICE_NAME specified is correct. // *Comment: This error will be returned if the (database) service has not been // registered with the listener; a database instance that is part of this // service may need to be started or configured properly. Most likely your database is missing the 'local_listener' parameter. -- Ron Reidy Lead DBA Array BioPharma, Inc. -----Original Message----- From: Moreno, Javier [mailto:[EMAIL PROTECTED] Sent: Sat 1/15/2005 9:44 AM To: [email protected] Cc: Subject: Issue with ODBC and Oracle 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 This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.
