?
Solved

DB-LIBRARY errors  - 10024, 10007

Posted on 2009-04-17
3
Medium Priority
?
1,025 Views
Last Modified: 2012-05-06
We are running into these errors frequently (DB-LIB 10024 & 10007) on our production SQL Server. We are at Microsoft SQL Server version 8.00.760(SP3) running on Windows 2000. Server has got 3G Memory. We don't see any errors in the database error log. The bad thing is that this error kicks the user back to the main screen and they need to start over. Each time a user experienced this error it ranged from 1.5minutes to 4.5 minutes. The database has been defragged recently.

Any help is greatly appreciated in resolving this.

Thank You
0
Comment
Question by:praveen_katta
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
bcsql earned 2000 total points
ID: 24170960
10024 is a connection timeout error. aka the user never connects to the DB

http://msdn.microsoft.com/en-us/library/aa937496(SQL.80).aspx

Can you get the full error from the code?
0
 

Author Comment

by:praveen_katta
ID: 24243508
Not sure, this will fix, We are moving this application to a new server with Windows Advanced that can accommodate more memory. We are expecting that should solve the problem. I will keep you posted. For now, I will go ahead and close this issue.

Thanks for your response bcsql.

-Praveen
0
 

Author Closing Comment

by:praveen_katta
ID: 31571582
Thanks a lot for your help on this.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question