sql server connect: Hi

I have a VB6 program that talks to SQL Server 2000 database. The Connection
String is as below:

Provider=SQLOLEDB.1;Persist Security Info=False;User ID=" & M_USER_NAME &
";Password=" & M_PASSWORD & ";Initial Catalog=" & Database & ";Data Source="
& M_SERVER

When the program is idle for a while, the connection terminates.

Also, when I try to connect using ODBC I get the following error

Connection failed;.
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen(Connect())
Connection failed;
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or
access denied.

Any ideas or suggestions. Dont know where to start looking.

The SQL Server is running. I have double-checked that.

Please HELP

Thanks

Hi, Raju

See:
http://support.microsoft.com/kb/328306
http://support.microsoft.com/kb/827422

Razvan

I also have this same error. Did you find the solution?
I searched the entire net but couldnt find a solution.

If you try disabling and enabling the network connection, it will work again. Very strange.

Please do post if you got solution.

Thanks in advance to anybody who can help in this matter

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/