Trouble Connecting to Informix DB with UnixODBC/Informix-Client-SDK-2.8UC2
Posted in 2003
Topics: Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL, Security, Permissions & Auditing, Networking & sqlhosts Configuration, Internationalization & Character Sets
Hello Informix Users! If anyone can help with this I will very much appreciate it!!! Setting up UnixODBC/informix is proving to be somewhat difficult. I followed the "Using the informix driver" instructions in the manual section of the unixodbc website, but haven't had much luck. Basically, I'd like to remotely connect to an informix database. We're running unixODBC-2.2.5-1, Informix-Client-SDK-2.80.UC2, and RedHat 8.0 on the client system, and trying to connect to a remote informix 7.3 server. Thanks in advance! Mike isql -v MES myusername mypassword [ISQL]ERROR: Could not SQLConnect ---------------------------------- odbc.ini ---------------------------------- [Informix] Description = Informix driver for unixODBC Driver = /opt/informix/lib/cli/libifcli.so APILevel = 1 ConnectFunctions = YYY DriverODBCVer = 03.00 FileUsage = 0 SQLLevel = 1 smProcessPerConnect = Y ---------------------------------- odbcinst.ini ---------------------------------- [MES] Description = My MES Connection Driver = Informix Server = myserver.myserver.net Database = mesprd1@whitneyprd CLIENT_LOCALE = en_us.8859-1 DB_LOCALE = en_us.8859-1 TRANSLATIONDLL = /opt/informix/lib/esql/igo4a304.so ------------------------------------ /etc/services (excerpt) ------------------------------------ online 60181/tcp # For Informix ODBC Driver ------------------------------------- /opt/informix/etc/sqlhosts ------------------------------------- mesprd1@whitneyprd seipcpip myserver.myserver.net online sqlexec ------------------------------------- /etc/ld.so.conf (excerpt) ------------------------------------- /opt/informix/lib /opt/informix/lib/cli /opt/informix/lib/esql