Multiple databases

Hi all,

Is it possible to access multiple databases through a single data source?
If it is possible how can we do the same?

Find more posts tagged with

Comments

ai762

you could write your own oda driver which allows you to access more than one Database.

dzish

Hi,

I don't know if you think databases are on different servers.

If databases are in one sql server it's simple. Use database name before table name.
Example: SELECT * FROM dbname.table

Jan