Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Connecting to Multiple Informix DB's

Connecting to Multiple Informix DB's

Connecting to Multiple Informix DB's

I have 11 different databases to query from, each with a different IP address, name, etc.  I have installed SDK, the driver version is 3.80.  My problem is this:

I have created 11 data sources, 11 entries in the hosts file also, but each data source points to the same host.  If I change the host on one data source, ALL data sources change.  So I can't query from 2 databases at the same time, or automate the queries, because I have to manually change the host each time.  I'm able to query from all db's successfully, there are no connection problems.

I think there's some basic idea I don't understand.  Can anyone give me any ideas?


Paul B

RE: Connecting to Multiple Informix DB's

I should also add, my goal is to use SQL Server 2005 to automate several queries, so that's the ideal place for a solution.  However, I can't make it work using other query tools as well.



RE: Connecting to Multiple Informix DB's

maybe a solution would be to create synonyms in ONE single database pointing to the other databases.



in database 1:

create synonym exttable1 for database2:username.sometable;
create synonym exttable2 for database3:username.sometable;
create synonym exttable3 for database4:username.sometable;

then you could do a connect to database1 and select from exttable1, exttable2, etc. which results in queries to the different other databases.

to achieve this, the server on which database1 is located must be allowed to talk to server2, etc.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close