mpdillon
asked on
Can a single ODBC source connect to more than one database?
Is it possible to define a SYSTEM ODBC DSN that will point to two databases at one time?
I don't think it is possible but there is no harm in asking.
pat
I don't think it is possible but there is no harm in asking.
pat
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can try to create view or table functions for tables you need from 2-nd db. Of wrap your multi- database queries into table functions. Most likely those will be visible to you in your product as regular tables.
ASKER
Thanks. Yeah, I do that all the time but today I am working with a product that uses only DSN and their query builder does not support the DatabaseName.dbo.TableName
Thanks,
pat