File data source vs. Machine data source

zhaicaibing · Post by **zhaicaibing** » Tue Jul 22, 2003 6:00 am

If machine data source is used, we will get this error message.

ERROR :-25556:S1000:[Informix] [Informix ODBC Driver] [Informix] Invalid sqlhosts file format.

However, if file data source were used there is no problem.

Please tell me how to solve this problem and what is the diff. betw. File data source and Machine data source

roy · Post by **roy** » Mon Jan 31, 2005 6:17 am

Hi,
as you can gather from the informix odbc driver that you don't have the environment set up correctly (it's trying to connect to the DB)
any way as I recall working with fixed files is the easy way (not to mention they are less open to changes you can't control)

IHTH,

ray.wurlod · Post by **ray.wurlod** » Mon Jan 31, 2005 3:48 pm

Do you have INFORMIXDIR and INFORMIXSERVER environment variables set correctly in the dsenv file?

Is there an entry for the database in $INFORMIXDIR/etc/sqlhosts and does it specify onsoctcp as the protocol and the correct port number? Is that line in sqlhosts correctly laid out? (The error message suggests that is not.)

database protocol server port

For example (tab delimited):

Code: Select all

MyInfxDB      onsoctcp     devserver     1621