By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,760 Members | 969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,760 IT Pros & Developers. It's quick & easy.

connection timeout issue

P: n/a
Hi,
I am using the data access app block and I keep getting the error

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

using the foll code

sqlhelper.ExecuteNonQuery(connstr,commandType.Stor edProcedure,"myProc",
NEW SqlParameter("@par",myparam))

Note: My sp takes a lonf time to run. Usually 18 mins from SQL Analyser.

I then added "Connect Timeout" to my connection string like

connstr = "Server=box;UID=user;UID=pass;DATABASE=vault;Conne ct Timeout = 1000"

But now

the stored procedure executed fine from the app but does not finish. It
stops without throwing an error.

I then tried passing a connection to the SqlHelper instead of the string like

Dim conn as sqlConnection = New SqlConnection

conn.open

sqlhelper.ExecuteNonQuery(connstr,commandType.Stor edProcedure,"myProc",
NEW SqlParameter("@par",myparam))

conn.close

But same thing happen the stored procedure executed fine from the app but
does not finish. It stops without throwing an error.

Any ideas on solving this issue?

Thanks
Jul 21 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.