-
Multilpe Databases
I am trying to avoid access, so i want to connect to 2 databases.. one being an as400 and the other oracle. Any way to use the dsn connections for these 2 databases to pull fields from as400 table and the oracle table where they have the same txid?
I have found examples of doing this in access but I really want to keep access out of it.
Thanks in advance.
-
don't you need 2 DSN?
one for Oracle and one for AS400, and then
I think you should be able to get data from
both dbs separately.
Just a thought
-
Yes I have 2...but i want to combine the 2 in one select
statement :)