I run my stored procedure that accesses the Oracle linked server from Management Studio and it works fine. When I invoke the stored procedure from my .NET application it times out. I have been googling and googling. I have set the commandtimeout command to many different times. I have also changed the connection timeout on the connection string. It seems as if it totally ignores them. I also tried " mycommand.CommandTimeout = 0". The application running live is working. I am making changes to the application. When I debug in Visual Studio I time out. WHen I deploy to a test folder on the web server I also time out. This application invokes many stored procedures and all of them work even ones accessing different servers(the difference is they are SQL not Oracle) and those are linked servers also. The only one that times out in my .NET application is the one that accesses the Oracle linked server. I have a call into the help desk for the application on that server which is administered offsite. I also have a call into a guy who is a SQL expert.
FYI: Recently our network administrator deployed a new firewall (WatchGuard).
Any Ideas ?