Home > IT Answers > Development > What more do I need to do to get instant client working with IIS?
OracleATE
190 pts.
 What more do I need to do to get instant client working with IIS?
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.)

Software/Hardware used:
ASKED: April 10, 2008  2:37 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _