Hi John !

Yes, I always explicitly name the database in all my SQL statements.
For Example : "SELECT * FROM database_1..My_Table".


>Hi Stephane ---
>
>I don't think you can use one DSN for two SQL Server databases but I could be wrong. Are you explicitly naming the database in all SQL statements, ie, "SELECT * FROM database table" ?