Link to home
Start Free TrialLog in
Avatar of sivaramy
sivaramy

asked on

ADO - Getting data from two databases

Using ADO I have established connection with NorthWinds database in MS-SQL Server. Without connecting again is there any way to access a table in pubs database using the SQL SELECT Statement.
ASKER CERTIFIED SOLUTION
Avatar of gwamb
gwamb

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of vbyuval
vbyuval

   
Hmm.. I am not sure if that will work...
I believe you connect A Database.  Ie 1 at a time.
Avatar of sivaramy

ASKER

gwamb comment is working.

tommy_boy
If you are not sure never lock a question.

Please have a look at the previous ee news letter.
Thank you very much gwamb.

If you can please let me know one more thing.

Will the same technique work with Oracle databases as well?
I don't know, but this is ANSI SQL, so I hope it will work with Oracle.