ODBC to Informix 5.1

Posted in 2003

Topics: Connectivity: ODBC / JDBC / .NET, Server Administration

Juan Ramon Martinez — 22 May 2003 11:40:41 -0700 — source: Usenet: comp.databases.informix

Hello Im writing a Windows-Based application that needs to connect to an Informix 5.1 Database. We have been using the ODBC driver from SCO (I wonder if anyone is still using them). I've been running into a number of problems with it, so I'd like to replace it. I downloaded the Odbc driver from IBM (version 3.82) but haven't been able to use it, My Odbc management window just freezes whenever I trhy to use them (Im running Windows XP). Any Ideas? Anyway,if I do get stuck with the SCO driver would anyone give me a hand interpreting the log files. Errors look something like this: 11:09:50 SQLError( henv=0000:0000, hdbc=0000:0000, hstmt=04C4:B460, szSqlState=0012:F144, pfNativeError=0012:F590, szErrorMsg=0491:2C10, cbErrorMsgMax=512, pcbErrorMsg=0012:F5A8 ) 11:09:50 SQLError : [SCO Vision][ODBC Driver][Informix]Could not update a row in the table. I've no idea what pfNativeError or szSqlState mean, the numbers reported there make no sense to me or our dba... Thanks in advance Juan Ramon