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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hmm.. I am not sure if that will work...
I believe you connect A Database. Ie 1 at a time.
I believe you connect A Database. Ie 1 at a time.
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.
tommy_boy
If you are not sure never lock a question.
Please have a look at the previous ee news letter.
ASKER
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?
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.