Cannot connect to SQL database via application

[programmher]

My client has an application that connects to an SQL 7 database.&nbsp;&nbsp;For some inexplicable reason, users are unable to connect to the database once they log out.&nbsp;&nbsp;&nbsp;This issue JUST occurred.&nbsp;&nbsp;Both the application and connectivity to the SQL Server were smoothly operating until a few days ago. If the users remain connected and logged in, they can conduct record updates.&nbsp;&nbsp;Once they log out, they are unable to re-connect.&nbsp;&nbsp;The error message states the data has changed.&nbsp;&nbsp;The vendor is convinced the error lies on the SQL Server side.&nbsp;&nbsp;I am convinced the error lies within their software.&nbsp;&nbsp;I have run traces (ODBC and SQL), sent copies of the database to them (they can successfully connect) and performed every other diagnostic known to man.&nbsp;&nbsp;I can query tables within the database(via query analyzer) AND connect to the database and the server via Cold Fusion.&nbsp;&nbsp;I also have several other databases on this server.&nbsp;&nbsp;The other databases are properly functioning.&nbsp;&nbsp;There have been no changes, upgrades, or installations.&nbsp;&nbsp;The SQL logs have not reflected any errors.<br><br>Can anyone think of anything I might have missed?&nbsp;&nbsp;Has anyone had this same (or a similar) issue?&nbsp;&nbsp;Any assistance would be GREATLY appreciated!

 

[Asif]

From your explaination of the problem you are facing, is might be somthing logical problem in your application. In my point of view something is changing in your connected database before disconnecting and not comitting whatever is changed by your application. When you try to connect database again without shutting of PC is not connecting again because your database connection handle is still active and report error. This is my guess please debug your application and check logical bug.

 

[programmher]

Asif,<br><br>Thank you for your comments.&nbsp;&nbsp;You have confirmed my thoughts (as well as the thoughts of the others involved in attempting to troubleshoot this issue).&nbsp;&nbsp;I appreciate your taking the time to respond!<br><br>Programmher