Home > IT Answers > Oracle > What more do I need to do to get instant clie...
Help

Question

  Asked: Apr 10 2008   2:37 PM GMT
  Asked by: OracleATE

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


Oracle 10g, IIS, SQL, ADO

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.)

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

CREATE ANSWER
View History
Start this Answer and Earn your Knowledge Points!

By clicking "Create Answer", you can write the answer to this question that can be improved upon by your peers using the Answer Wiki.

Browse more Questions and Answers on Oracle, Microsoft Windows and Development.

Looking for relevant Oracle Whitepapers? Visit the SearchOracle.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register