Problem connecting to database after a RESTORE. SQL Server 2005 and Classic ASP -


I have some selenium test scripts I'm using to test a classic ASP web app, but I After this problem is being restored to restore the database (SQL Server 2005) with a backup file before running each trial immediately after successful restoration (running sqlcmd from a Python script ...) when connecting with ASP DB Makes me try The following error is found ...

  [Microsoft] [ODBC SQL Server Driver] [DBNETLIB] Write Connection (Send ()).  

This is being generated by ADODB using this connection string ...

<> "DSN = Mydbdsn; uid = myUser; pwd = mypass, "

But attempts to connect to C ++ Active X objects via OdBC also fail with the same error.

Restarting IIS becomes normal and the same problem is displayed in SQL Server 2008.

Do not anyone know why I can not connect to the database after the restoration?

Thanks,

Copying from server default Duplicate question:

< P> Specifications:

During an offline restore, if the specified database is in use, then users will close after a while.

So make sure you restore the new connection after opening it. The existing connections from the connection pool are all clearly recovered as documentation. Clean your connection pool before each trial.


Comments