ODBC connecting two databases

ramram49 · #1 (**permalink**) 04-16-03, 23:37

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

Roelwe · #2 (**permalink**) 04-24-03, 07:23

If these are two informix database servers, they can connect natively.

ramram49 · #3 (**permalink**) 04-24-03, 22:02

Quote:

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?

Roelwe · #4 (**permalink**) 04-26-03, 07:09

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.

ramram49 · #5 (**permalink**) 04-28-03, 00:24

Quote:

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.

Internet Services

Web Development

Digital Marketing

Consumer Tech