How to Connect to Oracle Database from Web Services Posted in IIS
The situation is as follows:
1. Oracle 10g database on one server. Configured to accept connections.
2. Web service on different servers (IIS) connecting to the database. This does not work. 3. The same web services running on the VS 2005 web server work without issue and can connect to the database.
Problem: Not sure what is the problem with web services published in IIS to connect to Oracle 10g when the same services running on VS 2005 web server are running without issue.
Error returned: Oracleclient connection response time.
source to share
So the database is on machine A, and the web server that cannot connect is on machine B.
Where does the web server connect? If this is not on machine B, then what are the differences in network location / configuration between the two machines?
On machine B, can you connect to the Oracle server through the Oracle listener port?
source to share