What more do I need to do to get instant client working with IIS?

190 pts.
Tags:
ADO
IIS
Oracle 10g
SQL
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:
sqlplus myid/mypassword@//server:port/svc
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.)
ASKED: April 10, 2008  2:37 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following