Re: ODBC-Informix

In <35AB42E0.5EE615C9@sco.no.spam.com> Allan Gould <allang@sco.no.spam.com> writes: >mallow2@my-dejanews.com wrote: >> >> i'm trying to access informix database from Crystal Reports through odbc, but >> i get a message of "CR Informix 7 ODBC driver could not be loaded due to sys. >> error 1157" when i click 'ok' for this message, "Could not laod the setup >> translator library" appears, i checked that the file crinf709.dll (which i >> think, is the translator file) is in the directory windows/system, so i'm not >> sure what the problem is, any ideas? do i need to get hold of the informix >> client (INFORMIX-NET) to acces the informix database? please email me at >> Tan.Carolyn@jmco-asia.com if you have any ideas. thanks. >Don't know whose ODBC driver you're using or what your configuration >is. However, the error you are seeing is typically associated with the >PATH environment variable not being set or being set incorrectly, so >that the ODBC driver can't find files it needs. For example, take a >look at: http://www.sco.com/cgi-bin/ssl_reference?109324 which is the >form of the error when we saw it with our ODBC driver. >HTH Hello, If you are using the INTERSOLV ODBC drivers, you will need to add C:INFORMIX\\BIN to your PATH statement in the AUTOEXEC.BAT for non-NT OS's file or in the administrator's system enviroment in NT. Be sure when you installed the client software and the ODBC drivers you were admin on the local machine if you're on NT. You will need to get the client software to use ODBC - the ODBC talks to the database via the setnet32 program. Installing on NT is a bit of a pain - not much better on 95 - be sure to set up the sqlhosts file properly and also the services file - not having these two files properly configured will make your life miserable ;) If you have any questions, feel free to email me. Joe