Connecting to Oracle DB through webservice
-
Hi, I'm beginner to .NET... I'm trying to access an Oracle Database using a ASP.Net webservice with C#.... I'm using VS.NET 2005 and Oracele 10g... Created an System DSN using the Oracle ODBC driver I tried using an OdbcConnection String constr = String.Format("DSN={0};UID={1};PWD={2};", "TEST", "user", "passwd"); con = new OdbcConnection(constr); con.open(); This code works fine with a C# client program, but when I tried it with the webservice I get the following error... Error[IM003] Specified driver could not be loaded due to sytem error 5(Oracle in OraClient10g_home1) ny ideas? Am I missing something...?? Plz help if possible... Mahesh
-
Hi, I'm beginner to .NET... I'm trying to access an Oracle Database using a ASP.Net webservice with C#.... I'm using VS.NET 2005 and Oracele 10g... Created an System DSN using the Oracle ODBC driver I tried using an OdbcConnection String constr = String.Format("DSN={0};UID={1};PWD={2};", "TEST", "user", "passwd"); con = new OdbcConnection(constr); con.open(); This code works fine with a C# client program, but when I tried it with the webservice I get the following error... Error[IM003] Specified driver could not be loaded due to sytem error 5(Oracle in OraClient10g_home1) ny ideas? Am I missing something...?? Plz help if possible... Mahesh