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.
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)
TNS for 32-bit Windows: Version 184.108.40.206.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 220.127.116.11.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:
var conn1, rs1 = "";
var cnstr="Provider=OraOLEDB.Oracle; " +
"DataSource=db2_localhost; " +
conn1 = new ActiveXObject("ADODB.Connection");
Does anyone know why this is connecting to the wrong db? I wonder if my Oracle datasources are configured incorrectly?