DBSETPROP() can be used to change connection.database property on fly, so it's possible to reach different databases using the same DSN. Also, it's possible (i guess) to call back-end stored procedure which will access diferent databases.

>Actually, it's "SELECT * FROM database..table". Note the double periods.
>
>>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" ?