x

.Net application invkoing a stored procedure accessing a linked server(Oracle)

Hello

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 ?

more ▼

asked Mar 24, 2010 at 01:19 PM in Default

Shiloy Reinhart gravatar image

Shiloy Reinhart
2 2 2 2

How is security set up for the linked server?
Mar 24, 2010 at 02:16 PM Jack Corbett
I agree with Jack. It sounds like your procedure doesn't have access to the linked server. Makes the most sense.
Mar 24, 2010 at 03:25 PM Grant Fritchey ♦♦

Remote login and password supplied by the Oracle Administrators. I can run the stored procedure manually but not through the .net application. I am thinking it has to be someting stupid I am missing or doing wrong. I get SQLException was unhandled by user code.

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

thanks
Mar 24, 2010 at 04:48 PM Shiloy Reinhart
I just spoke with the network administrator and our firewall is only on outgoing not on internal servers so that is not the problem which I did not think was but had to ask anyway.
Mar 25, 2010 at 12:12 PM Shiloy Reinhart
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x379
x111

asked: Mar 24, 2010 at 01:19 PM

Seen: 1664 times

Last Updated: Mar 24, 2010 at 03:44 PM