Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language:
Expertise: Beginner
Apr 20, 2000

Connecting Informix Databases

Question:
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.

Answer:
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.

 

 

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