Hi all !

I have a number of VB Executables heavily using winsocks and other Socket servers. These VB Executables uses MSDE1.0 as Back end Database. Each executable opens connection to MSDE 1.0 in every 15 Minutes and selects and insert some rows and closes the connection. The programs run properly for 5 days continuously i.e. 24X5 hours. But after 5 days MSDE 1.0 denies to open connections. it gives error like
"-2147467259 Unspecified error ".

I thought something and restarted each application with MSDE each day at mid night. But Despite restarting MSDE1.0 and VB application. MSDE refuses to get connected after 5th day. The Applications work properly if i restart the machine.But after 5th day again the same problem.

Please Help .

The Connection String i have used is

.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=ABTDATA;Data Source=SCE"
.ConnectionTimeout = 30
.CursorLocation = adUseClient

Thanks in Advance