Unable to load dll (oci.dll)
433709Nov 29 2004 — edited Nov 30 2004I am trying to connect to Oracle 10g database using Visual Studio.Net 2003, System.Data.OracleClient namespace. VS's Data Link Property utility is allowing me to connect to the database both using Microsoft OLE DB Provider for Oracle and Oracle Provider for OLE DB. I have created a Web service running on my workstation's local web server, that uses a connection to an Oracle database (my connctionString="Data Source=orcl;User Id=myid;Password=pswd" ). While the program's trying to execute myConnection.Open() - the exception is thrown "Unable to load dll (oci.dll)". I have installed the Oracle client on a development (WinXPPro) workstation, so the client BIN directory is on the system path, production server is running Oracle 10g on Windows 2003.
Is it some kind of connection string issue or user permissions problem? How do I setup the right ones?
Thanks for the help in advance!!