Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

ODBC SQL Server Drive Problem

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
0
pure032398
Asked:
pure032398
  • 2
1 Solution
 
sybeCommented:
Have you tried to set the Timeout of the connection-object:

Conn.ConnectionTimeout = 5

(it counts in minutes)
0
 
pure032398Author 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!
0
 
sybeCommented:
Ok, here it is
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now