Re: Which port is Informix listening?

Nuno Paquete wrote: > Hi, > > "You would have to request the Informix admin to activate a > DBSERVERALIAS > using TCP/IP. After that you can connect with ODBC, OLEDB, JDBC and > .NET..." > > I've got root access to the system. How can I do that? > Do I have to append any line to sqlhosts file? > Can you tell me how can I activate DBSERVERALIAS? You would have to change your sqlhosts and your onconfig, and then stop and start the instance... but read ahead... > Will this changes affect previous settings? I mean, we've got an > application that was developed by another company, that app was > develped using C language and is installed on client machines > (Windows). That application accesses an Informix database. I don't want > to affect negatively the app, because it is very important to my > company. If you have clients accessing the database remotely than you must have a listener on a TCP port. And your sqlhosts file must have more then you've show. Are you sure you're looking at the correct sqlhosts file? Don't you have the INFORMIXSQLHOSTS variable pointing to another file? > Now I want to develop another application (using .NET) that will use > the tables of the Informix database. > Any help would be very appreciated. All this changes are easier to make, but if you're not used to do it, you can make a mistake that could harm your environment. And I don't feel confortable "teaching" you, because I may overlook something and this together with your lack of knowledge in the Informix environment can cause troubles... You should get help from someone with access to the environment. Besides this, everything I've written assumes you're using Informix Dynamic Server 7, 9 or 10. If you're using other IBM informix database the scenario can change. Regards.