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
Are you importing the correct namespaces in your webservice You may also have to install an oracle client driver I've had issues with this in the past. Look where you want to go not where you don't want to crash. Bikers Bible
-
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
Try to determine what account the webservice runs under. If it is the default one called ASPNET it likely does not have the needed permissions for accessing the system DSN. That's what I'd look at first. Chris Meech I am Canadian. [heard in a local bar] When no one was looking, every single American woman between the ages of 18 and 32 went out and got a tatoo just above their rumpus. [link[^]]
-
Are you importing the correct namespaces in your webservice You may also have to install an oracle client driver I've had issues with this in the past. Look where you want to go not where you don't want to crash. Bikers Bible
-
Try to determine what account the webservice runs under. If it is the default one called ASPNET it likely does not have the needed permissions for accessing the system DSN. That's what I'd look at first. Chris Meech I am Canadian. [heard in a local bar] When no one was looking, every single American woman between the ages of 18 and 32 went out and got a tatoo just above their rumpus. [link[^]]
Hi Chris, Thx.... That was the issue :-D I gave the ASPNET user access to my oracle home folder and its subfolders and now the code works.... I had issues when I tried using the Oracle .NET provider... But this solution corrected everything.... Thx everybody....:) Mahesh
-
Hi Chris, Thx.... That was the issue :-D I gave the ASPNET user access to my oracle home folder and its subfolders and now the code works.... I had issues when I tried using the Oracle .NET provider... But this solution corrected everything.... Thx everybody....:) Mahesh
Glad that worked. I should have pointed you to my only article, cause I ran into the permissions thing with it as well. And it took a bit of time to figure out how to deal with the permissions. Chris Meech I am Canadian. [heard in a local bar] When no one was looking, every single American woman between the ages of 18 and 32 went out and got a tatoo just above their rumpus. [link[^]]
