We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

ODBC SQL Server Drive Problem

pure032398
pure032398 asked
on
Medium Priority
206 Views
Last Modified: 2010-03-19
Hi.
   i keep getting this problem that crops up here and there
in my asp programs.



Microsoft OLE DB Provider for ODBC Drivers error '80040e31'

[Microsoft][ODBC SQL Server Driver]Timeout expired

Why is this and how can this be solved?
I have tried having this line of code at the top of the asp
file

      Server.ScriptTimeout = 9000000

or any big number from 900 and onwards.

also, i'm using NT Option Pack so iis4 is installed...
thanks :)

Jussy
Comment
Watch Question

Commented:
Have you tried to set the Timeout of the connection-object:

Conn.ConnectionTimeout = 5

(it counts in minutes)

Author

Commented:
Kewl!
i think this solved it!
If not .. oh well .. but i'm sure it has .. so answer it and have me points, laddy!
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.