RE: Issue with ODBC and Oracle
From: Ron Reidy (Ron.Reidy_at_arraybiopharma.com)
Date: 01/16/05
- Next message: Sam Vilain: "Patch for DBD::SQLite - spurious undef warning"
- Previous message: Javier Moreno: "Issue with ODBC and Oracle"
- Maybe in reply to: Javier Moreno: "Issue with ODBC and Oracle"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Sun, 16 Jan 2005 07:10:13 -0700 To: "Moreno, Javier" <JavierMoreno@eaton.com>, <dbi-users@perl.org>
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:JavierMoreno@eaton.com]
Sent: Sat 1/15/2005 9:44 AM
To: dbi-users@perl.org
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.
- Next message: Sam Vilain: "Patch for DBD::SQLite - spurious undef warning"
- Previous message: Javier Moreno: "Issue with ODBC and Oracle"
- Maybe in reply to: Javier Moreno: "Issue with ODBC and Oracle"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
