Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2002
    Posts
    16

    Red face Unanswered: ODBC connecting two databases

    Is it possible to connect to two different databases on a server via a single ODBC connection?

    I am using a very old version of Informix and ODBC version 3.81

    Thanks


  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    If these are two informix database servers, they can connect natively.
    rws

  3. #3
    Join Date
    Aug 2002
    Posts
    16
    Originally posted by Roelwe
    If these are two informix database servers, they can connect natively.
    The databases are in the same informix server. How can I connect them by one ODBC and use it via ADO?

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Connect to the server.

    then do a select from database:table.

    f.ex.
    select * from sysmaster:systables

    you can do this in any other database.
    rws

  5. #5
    Join Date
    Aug 2002
    Posts
    16
    Originally posted by Roelwe
    Connect to the server.

    then do a select from database:table.

    f.ex.
    select * from sysmaster:systables

    you can do this in any other database.
    It works...many many thanks.

Posting Permissions

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