Re: How to update table on a remote server from NEWERA
Posted in 1996
Topics: Stored Procedures & SPL, Connectivity: ODBC / JDBC / .NET, Triggers, Constraints & Referential Integrity, Networking & sqlhosts Configuration, Platform-Specific Issues
In <4nqpkb$lt4@cssun.mathcs.emory.edu>, cherylk@prod1.jcdc.doleta.gov (Cheryl Kendricks) writes: >Got this working via triggers and stored procedures (both DB must be in >the same log mode). Our problem now is with using the connect function >within a NewEra Application. This is what I understand about the "connect >function" of NewEra, could someone PLEASE let me know if this information >is correct and if you have done this: > If you use INET you must make changes via your NewEra Program to specifiy > the host, db and service to the "informix.ini" file. If you use an ODBC > driver that has all servers defined then you do not have to > "update/modifiy" the "informix.ini" in your NewEra Application. > >What's the purpose of the Informix/sqlhosts file on the PC side? Can I >include REMOTE servers in there and then the Informix NewEra Programs do >not have to modify the "informix.ini" file? > > Yup!! I am having trouble with multiple connection with straight informix. I would hate to use ODBC and manage my explicit connections to get to INFORMIX database from my local (Windows SE) to AIX (Informix online 7.0). I hope someone has a better suggestion ??? ravi :-(