bethKoala
asked on
web service cannot connect to Oracle tables
I am trying to launch a web application on a Windows 2000 server. The web app has been working at another location on a similar server without these issues. My problem is that when I try to use a web method that accesses the data tables, I get this error:
Oracle.DataAccess.Client.O
It happens every time. I've double-checked all that I know to look at: the web config file has a data connection string that matches up with the tnsnames.ora file, and both look almost identical to the ones that work at the other location. The virtual directories are set up the same way.
I know my tables are OK because I can access them with asp pages (for reports, which bypass the web services).
The server is setup for Oracle 9i, ODAC 10, and .NET 2.0. Any suggestions greatly appreciated, thank you.
Oracle.DataAccess.Client.O
It happens every time. I've double-checked all that I know to look at: the web config file has a data connection string that matches up with the tnsnames.ora file, and both look almost identical to the ones that work at the other location. The virtual directories are set up the same way.
I know my tables are OK because I can access them with asp pages (for reports, which bypass the web services).
The server is setup for Oracle 9i, ODAC 10, and .NET 2.0. Any suggestions greatly appreciated, thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi and thanks for your responses. We finally have it working. After checking everything, such as permissions, data connection strings, sqlnet.ora, web.Config, and updating the versions of ODP and .NET, the only thing that worked was to upgrade to ODAC 11.1, even though the database is Oracle 9i.
Finally, the data connection works, which means both my web service and my web pages are operational.
Thanks again for responding.
Finally, the data connection works, which means both my web service and my web pages are operational.
Thanks again for responding.
ASKER