Re: problem with ODBC ACCESS--> INFORMIX

It is best to post Informix related questions to comp.datbases.informix where there are many more Informix denizens, and I have taken the liberty of cross-posting this reply, but here is what I have for you. I assume this is Informix Standard Engine from the existence of the DBPATH environment variable. Do you have the listener, sqlexecd, running on the server? This has to be run as root as: sqlexecd servicename -l logfile The servicename is optional, IMS, if there is only one connection defined for the server in the sqlhosts file there. Next, I do not see user and passwd entries in your odbc.ini file. Did you use a username and password in the ODBC connect statement? If not the client has to be a trusted host and the either way the user needs to have a valid account on the server. If you are using the username/password model instead of the trusted client model the user's account must be login-able with the specified password, otherwise not. Art S. Kagel michael_klimt@my-deja.com wrote: > > i have installed suse 6.0 kernel 2.0.36 on my linux machine. > further informix 7.2 ud7 > this informix run without problems > > now i tried to install an ODBC on WINDOWS NT 4.0 (Service pack 5) > with informix sdk-client ODBC > > and this will not be work > > these are the parameters that i set on the linus machine > > /etc/rc.config: INFORMIXSERVER=infse1 > > etc/services: infse1 1536/tcp # Informix SE > > /opt/informix/etc/sqlhosts :infse1 sesoctcp pc2117 infse1 > > this are the parameters on the client > > informixserver infse1 > hostname pc2117 > protocolname sesoctcp > servicename infse1 > dbpath=/home2/informix_daten > informixdir=c:\\informix > informixserver=infse1 > informixsqlhosts=pc2117 > > if i start an odbc-query from acces the following error-code i can see > [informix][odbc informix driver][informix]syntax disallowed in this > databaseserver. [#-554] > > i dont know what is my mistake. is it the protocolname? > > please help me and excuse my bad english > > thanks a lot > > michael > > Sent via Deja.com http://www.deja.com/ > Before you buy.