Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    31

    Question Unanswered: Problems with Provider = OraOLEDB.Oracle

    Hi,

    I'm not sure if this is the appropriate forum to post this question to...

    I'm trying to write a script using JScript that accesses an Oracle DB that is on my local computer. When I execute the script, I get this error:

    ORA-12560: TNS: protocol adapter error
    Code: 80004005
    Source: OraOLEDB

    When I look at the sqlnet file that is produced, I get a fatal error connecting to a database "mydb1" that I have deleted before. This wasn't the database I specified to connect to in the script.

    Code:
    Fatal NI connect error 12560, connecting to:
     (DESCRIPTION=(ADDRESS= (PROTOCOL=BEQ) (PROGRAM=oracle)(ARGV0=oraclemydb1) 
    (ARGS='(DESCRIPTION= (LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')) (CONNECT_DATA=(SID=mydb1) 
    (CID=(PROGRAM=C:\WINNT\System32\WScript.exe) (HOST=NEW_INSTALL)(USER=admin))))
    
    VERSION INFORMATION:
    TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
    Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production
      Time: 23-JAN-2004 10:59:44
      Tracing not turned on.
      Tns error struct:
        nr err code: 0
        ns main err code: 12560
        TNS-12560: TNS:protocol adapter error
        ns secondary err code: 0
        nt main err code: 530
        TNS-00530: Protocol adapter error
        nt secondary err code: 2
        nt OS err code: 0
    The code I'm connecting to the db called "db2" is:

    Code:
    var conn1, rs1 = "";
    var cnstr="Provider=OraOLEDB.Oracle; " +
                   "DataSource=db2_localhost; " +
                   "UserID=system;Password=manager;";
    
    conn1 = new ActiveXObject("ADODB.Connection");
    conn1.Open(cnstr);
    conn1.close();
    Does anyone know why this is connecting to the wrong db? I wonder if my Oracle datasources are configured incorrectly?

    Thanks

  2. #2
    Join Date
    Aug 2003
    Posts
    5
    Check $ORACLE_HOME/network/admin, if its all local the tnsnames.ora (maybe sqlnet.ora too) need some cleanups- host=NEW_INSTALL might be a leftover from dbca?

  3. #3
    Join Date
    Jan 2004
    Location
    Toronto, Canada
    Posts
    31
    the tnsnames.ora connects some remote connections. I found and deleted an old entry of the old, deleted database, but the database access still doesn't work.

    I'm not sure what you mean that the host might be leftover from dbca? do you mean that the deleted database wasn't deleted properly?

    Does anyone know how the ADODB object finds the datasource and accesses the Oracle database? The datasource is the same as the host string used to access the db using SQL Plus right?

    Thanks for your help!

    Originally posted by clcart
    Check $ORACLE_HOME/network/admin, if its all local the tnsnames.ora (maybe sqlnet.ora too) need some cleanups- host=NEW_INSTALL might be a leftover from dbca?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •