OLE DB Close DB Connection w/MSSQL 6.5
To create a disconnected recordset in VB the syntax is:
Set adors.ActiveConnection = Nothing
This stops the recordset's communication with the database server.
Quote:
>Hi,
>I have an OLEDB, MFC VC++ application which makes a connection to MS SQL
>Server. I close the session and db connection with:
>session.Close();
>db.Close();
>but the database connection still appears under SQL Server's Current
>Activity list. Once I quit out of the application, the connection
>disappears. I would like to accomplish this programatically so that I can
>create another connection.
>Can someone suggest how I might be able to do this?
>Thanks,
>Emery Mersich
