I have a strange problem that I'm hoping someone else has run into and
can help me resolve.
Client application: ASP.NET application deployed to IIS. Windows 2000
Professional SP2. Oracle Client installed - connectivity to target
server verified via connection by SQL*Net.
Client network: Firewalled/Proxied through MS Proxy v. 2.0
Target server: Oracle 8 on Linux
Symptoms: Using the Visual Studio.NET tools or through a Windows Forms
application, I can successfully connect and get data from the Oracle
server. When I run the Web application, I get an ORA-12203 error. When
I put the workstation outside of the Proxy Server, connection works.
I've read several messages that comment on how to set up an NT server
with SQL*Net Proxy or setting USE_SHARED_SOCKET - but my situation
seems to be client based. Can I specify a given port to be always be
used by the connection after the initial handshake on 1521 so I can
dig a hole through the firewall? And why is it that the problem only
shows up when I'm using a Web/IIS ASP.NET application? Any tools that
might help me to debug what is happening at the Oracle client level?
Thanks!
Regards,