Results 1 to 3 of 3

Thread: Multilpe Databases

  1. Oct 31st, 2001, 04:36 PM #1
    jbrown99
    jbrown99 is offline

    Thread Starter
    Lively Member
    Join Date
    Sep 2000
    Posts
    69

    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.
    Reply With Quote Reply With Quote
  2. Oct 31st, 2001, 05:36 PM #2
    jxiong
    jxiong is offline
    Hyperactive Member
    Join Date
    Oct 2000
    Posts
    303

    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
    Reply With Quote Reply With Quote
  3. Oct 31st, 2001, 06:17 PM #3
    jbrown99
    jbrown99 is offline

    Thread Starter
    Lively Member
    Join Date
    Sep 2000
    Posts
    69
    Yes I have 2...but i want to combine the 2 in one select
    statement
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width