DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Windows 7, Oracle DB, Instant Client and VBScript

allenflameJul 10 2013 — edited Jul 16 2013

I'm trying to to connect to a Oracle database via vbs on a Windows 7 machine using the instant client. I get an error [Oracle][ODBC][Ora]Ora-12560: TNS:protocol adapter error Code 80004005. Script still works fine in XP using the Microsoft ODBC for oracle. I've setup the system dsn, and added tns_admin option to the system environmental path. Here's the connection line

psconn.Open "DRIVER={Oracle in instantclient_11_2};SERVERNAME=192.168.50.1:1521/PSPRODDB;User Id=user;Password=pass;"

I've tried 32 bit instant client and the 64 bit and get the same messages with both. Any suggestions?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 13 2013

Added on Jul 10 2013

#odbc, #windows-and-net

1 comment

3,092 views