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
File data source vs. Machine data source
-
- Participant
- Posts: 49
- Joined: Wed Jun 11, 2003 12:49 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,
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,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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):
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
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.