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.)
April 10, 2008 2:37 PM