I have installed instant client on my XP computer and am able to connect to a remote Oracle 10g server with SQL plus using this string:
I have also been able to make a DSN file that connects, and have been able to connect with Visual Basic.
I HAVE NOT been able to connect via ADO using my IIS configuration (I get a 'protocol adapter error.) I've tried a number of connection strings, such as:
"Driver=Oracle in instantclient11_1; Server=myserver:port/svc; Uid=myid;Pwd=mypassword;"
I have set my PATH env var to the instant client folder, as well as TNS_ADMIN (though I have no .ora files whatever installed with instant client.)
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!