asp classic - Duplicate SQL Server database on same server cannot be accessed -

I am using SQL Server Workgroup Edition on Windows Server 2003 R2

My classic ASP page Accessing my production database using a database DSN are all working here.

code like this ...

For development and testing, I have copied ProdDB in Enterprise Manager

• Backing up the ProdDB
• with ProdDB Restoring Backup Set on a New Database named TestDB

I understand that the restored database will contain accurate copies of data as well as users, roles etc. Backing up this assumption in comparison to both databases in enterprise manager.

So ... I think I can use test credentials using the same credentials and only change the name of the DBN, like ...

  Set% ld; user.d = "PublicUser" pwd = "PublicUserPW" objConn = Server.createObject ("ADODB.Connection") objConn.connectionString = "DSN = MySystemDSN" objConn.open dbName, userID, pwd % & Gt;  

However, now my page

[Microsoft] [ODBC driver manager] has not got the name of the data source and no default driver is specified < / P>

I have also tried to create a new system DSN, with a default database pointing in TestDB. There is still no happiness.

I am sure that I am doing something simple and silly

this document It has been announced for:

  connection. Open connection string, user id, password, option  

It seems that you are passing as a connection string in TestDB I usually call without specifying any argument. Hold a connection string from, and:

  objConn.ConnectionString = "data source = localhost; initial catalog = testdb;" & Amp; _ "User id = myUsername; password = myPassword;" ObjConn.Open