Browse DevX
Sign up for e-mail newsletters from DevX

Tip of the Day
Expertise: Beginner
Apr 20, 2000



Building the Right Environment to Support AI, Machine Learning and Deep Learning

Connecting Informix Databases

How can I use SQL to access an Informix database that's on a remote site and connected via a VPN while connected to an Informix database locally?

Both are HP9000 systems running HP10.20 and Informix OWS 7.

You need to be able to ping one machine from the other. If you can, use the Informix Connect software to connect them. On UNIX, you need to modify the sqlhosts file of each machine to have the other machine's connection information. You may already have this set up. When your run dbaccess and do a query, does it show the databases on both machines? If so, you're already connected.

Otherwise, read up on the format for the sqlhosts files. Compare the two machines' files, and make sure that they have each other's connection info. You may also try the "connect" menu item on dbaccess to see if you can connect them.

DevX Pro
Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date