DSXchange

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

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,

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):