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), connectser ver,joinse rver,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
i use windows 2003 server standard edition
i use sql 2000 for my application which its an online game
i have serveral dataservers(applications),
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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...
Serve Timeout:Enterprise Manager --> INSTANCENAME --> Properties (Connection) --> modify it from 600 to above value...
Hope this helps...
ASKER