Re: ODBC to Informix 5.1

hi Juan, > 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 Looks like you had some sort of update statement which failed. The log file may pinpoint which SQL statement it was. If not, you can also get a Windows-based ODBC trace. That'll give some additional info. Here's are the steps to generate one: A. Open your ODBC Data Sources utility. B. Enable tracing on the tracing tab. C. Recreate the error condition. D. Disable tracing on the tracing tab. E. Locate the file indicated in the log file path on the tracing tab. Regards, James Chin OpenLink Software Universal Data Access Middleware Providers http://www.openlinksw.com