I'm using a connection in my main application .In this application I use(instantiate) another ActiveX EXE to verify/Update some data in my main application. This Exe connects to the same server as my main application but to a different database. After I get the result from the Exe my connection has an error "Connection failure" in the errors collection of my connection object and I can no longer use this connection to do other things in my main application.
I'm using SQL Server 7.0 database.
Any help on this is appreciated.