Web Development

Ask something
Discussion Locked

SQL Run-time error

0 helpful
3 replies

by sprocket 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have just started to get the following message on a couple of our VB scripts that try to access SQL.
"Run-time error 2147217871 (80040e31)"

Now i know what this is and means, but how do i fix it. I didnt write the scripts and cannot uncomplile them, but how else can i find and fix this problem?
I have basic knowledge of VB and SQL.

3 replies

by rich.lund

If I am right in thinking this is a timeout error coming from the database driver (you haven't included the error message), that the database server is there and that you are actually talking about VB _executables_ not scripts (which would be plaintext, not compiled) then:

- If you cannot access the code, you need to look at network bandwidth to the database server if applicable, then at the performance of the table during queries (has this just started to happen as you get more data?) - you should examine the indices on the table(s) involved and use SQL Server Profiler.

- If you can access the code, perhaps your query is not optimal.

From the info you've given, I guess the solution is down one of these paths.

R

by sprocket

this dint help, but i figured it out in the end from a bit of research from the web.

This discussion is closed to new replies.