Re: INFORMIX 5 : is there a SQLHOSTS file ?

Peries, Chaminda wrote: } } Hi ! } } I have been using Informix 7.2 / CLI 2.5 / ODBC. Now, I have an } application I need to test against an Informix - Online 5 Database. } } The database was installed, I have created tables etc.. The problem is } connecting to this database via CLI or ODBC. } } I was not able to configure them the way I did with INFORMIX -7. } } In the $INFORMIXDIR/etc directory there is no SQLHOSTS file. Instead } there is a TBCONFIG file. } } Where do I get The SERVICE NAME for the database from ? I found the } database server name in the TBCONFIG file. } } When I called up Informix tech support they said to create a file called } SQLHOSTS with similar info as in Informix 7 in this directory. but this } didn't work . } } Hope someone can help me out. } } Thanks } } Chaminda Peries } } Dynasty Technologies Inc. } } Chaminda, for Online 5 you need an extra product Informix Star Ver. 5.xx in order to communicate with ODBC drivers that doesn't provide server side software for the communication such those from Openlink,SCO,Esker etc. With Informix Star installed you define in a sqlhosts file the following dbservername nettype hostname servicename where dbservername is your informix server name and isdefined in TBCONFIG, nettype will be something like oltlitcp or olsoctcp, hostname must be defined in /etc/hosts and servicename is the service name for the Informix Star daemon (sqlexecd) and is defined in /etc/services Hope I got it right and it helps Tolis -- +---------------------------------------------------------------------+ | V+K Relational Solutions email: tvarnas@compulink.gr | | Deligiorgi 26 tvarnas@orbit.de | | 546 42 Thessaloniki Voice: (30) 31 820270 | | Greece Fax: (30) 31 865463 | +---------------------------------------------------------------------+