Re: native connection to 2nd network card

CKGeier@nwc.edu wrote: > We currently have our sqlhosts file setup to allow connection for one port > on ip address aaa.aa.aa.aaaa through odbc or native connection. I want to > add another network card on the same server to the sqlhosts file so that > we can connect to that ip address of bbb.bb.bb.bbbb as well, with the same > port for the odbc and native connection. (I want a certain program to > connect through the second ip address.) What do I need to change or > modify? Is this possible? So far I have tried adding a line to the db > servers's sqlhosts with the appropriate data, but it doesn't seem to be > working. We also changed the client servers sqlhosts, and then restarted > Apache after the change. Yes, it is possible. You need to: 1. Define a new dbserver name by using DBSERVERALIASES in your onconfig file. 2. Add a new dbserver entry with the same name to your sqlhosts file, using the new IP address. 3. Change your INFORMIXSERVER environment variable to the new dbserver name. 4. You will need to bounce your database server. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+