Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

[ODBC] HTY00 TimeoutExpired!

Posted on 2004-03-29
5
Medium Priority
?
1,250 Views
Last Modified: 2007-12-19
Hi.

Sometimes, My Client(MFC,ODBC,MDAC 2.7) occured the error(Connection Failed.  SQLState: HYT00  SQLServer Error:0  TimeoutExpired)

so, This Error continued for 30 minutes..then return to normal..

I don't understand..please..help me..


status;
Client(ODBC(By TCP/IP),MDAC 2.7)
SQL Server (win2000,SQL 2000(SP3))
0
Comment
Question by:sangrime
  • 2
5 Comments
 
LVL 13

Expert Comment

by:danblake
ID: 10702288
What is the performance of the SQL Server like when this error occurs ?

(Is is usual for connections to fail, if the server is too busy to service client requests).
0
 

Author Comment

by:sangrime
ID: 10709571
NO, Some Clinet occured the Error(Database user= aa_user)

other Client(Database user=sa) operate very well..

The Server not busy...(no cpu use, no memory use).
0
 
LVL 13

Accepted Solution

by:
danblake earned 1000 total points
ID: 10711702
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

916 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