Greetings . . .<BR><BR>I'm trying to open a database using a predefined System DSN. Trouble is, the DSN is defined to access a default (SQL Server) database, and I want my ASP code to access another database (on the same server).<BR><BR>I don't want to change the default database definition in the DSN (since I'm afraid it might affect other apps -- and there are many -- that are using the same DSN).<BR><BR>I'm thinking that it's a waste to have to define a new DSN just for this instance, especially when it's accessing a database on the same SQL Server.<BR><BR>I have rs set to my recordset. How do I set it using rs.source (or, for that matter, can I)? I've tried different permutations of [servername].dbo.[DBname] to no avail. What is the proper syntax?<BR><BR>Thanks for your assistance . . .