Link to home
Start Free TrialLog in
Avatar of daddycaddy
daddycaddy

asked on

ODBC timeout

my computer specs are dual xeon 3.0 with 3 gb ram
i use windows 2003 server standard edition
i use sql 2000 for my application which its an online game
i have serveral dataservers(applications),connectserver,joinserver,event server
i didnt have this problem till now but recently i install sp4 for sql 2000, till now i was using only sp3
so since then sometime randomly i get error: ODBC Timeout and in that moment dataservers lose connection with SQL server which is localy
its random, sometimes happend many times, sometimes happend just one time

ASKER CERTIFIED SOLUTION
Avatar of Racim BOUDJAKDJI
Racim BOUDJAKDJI
Flag of Algeria image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of daddycaddy
daddycaddy

ASKER

how increase timeout?
Client Timeout: increase in ASP /ASP DOT NET conf parameter/
Serve Timeout:Enterprise Manager --> INSTANCENAME --> Properties (Connection)  --> modify it from 600 to above value...

Hope this helps...