Issue with ODBC and Oracle

From: Javier Moreno (JavierMoreno_at_eaton.com)
Date: 01/15/05

  • Next message: Ron Reidy: "RE: Issue with ODBC and Oracle" 
    Date: Sat, 15 Jan 2005 10:44:09 -0600
To: <dbi-users@perl.org>

    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

  • Next message: Ron Reidy: "RE: Issue with ODBC and Oracle"

    Relevant Pages

    • RE: ORACLE DRIVER
      ... DBI - is the perl module to handle all the request of the database, connecting, disconnecting, routing the database request to proper driver. ... DBD::Oracle - is the Oracle driver that DBI can use to handle oracle request. ...
      (perl.dbi.users)
    • RE: ORACLE DRIVER
      ... Subject: ORACLE DRIVER ... DBI - is the perl module to handle all the request of the database, ... So is there any free Oracle ODBC driver for Linux? ...
      (perl.dbi.users)
    • Re: Microfocus Netexpress question : COBSQL vs openESQL
      ... >couldnt connect with the oracle database specified in the program. ... It may be missing an ODBC driver and/or data source. ... You also need an entry for the data source in tnsnames.ora. ... precompiler directives to the precompiler and compiler directives to ...
      (comp.lang.cobol)
    • Re: DTS for Oracle through ODBC: Error Calling GetNextRows in Prev
      ... I found out the Oracle driver they had installed on my system was for Oracle ... installer app in order to install their ODBC's.. ... I decided to use the Oracle ODBC provided in their client install. ...
      (microsoft.public.sqlserver.dts)
    • Re: Import from Oracle - ODBC basics
      ... My instinct would have been to install the driver on the ... equivalent create a Local Net Service Name Configuration to the Oracle ... A FULL installation of Oracle was required on the computer in order for ... the "Oracle ODBC Driver" to be available. ...
      (comp.databases.filemaker)