ADODB::Command
-
Hi I have came across a strange situation . I have an application in VB which I have used ADODB:Command to call Stored procedures in SQL Server . at the beginnig of application I create Commands and set them in Connection . Set c = New ADODB.Command c.Name = "DeleteProjIX" Set c.ActiveConnection = cn c.CommandText = mPrefix & "DeleteProjIX" c.CommandType = adCmdStoredProc c.Parameters.Append c.CreateParameter("@ID", adInteger, adParamInput) ( cn is a valid open ADODB::Connection and mPrefix is a valid String ) This application used to work well until we upgraded to SQLServer 2000 . using this server and a machine which we have installed client tools of SQLServer 2k , the application seems to 'loose' these stored procedures after a while , so after a completely random cycles ( less than an hour ) we get a message notifying of unrecognised command . stepping through code reveals that there is no command in the connection . this problem does not produce in any specific sequence of actions or specific time . with higher load of server it happens more often . running the application on a SQLServer7 and a client loaded with SQLServer7 client tools , all the problems disappear . What is the cause of this change ? I would really appreciate your help Thanks in advance