Informix Error with ODBC
Posted in 1998
Help ! Informix gives wrong data with ODBC - Drivers. ---------------------------------------------------------------------- I'm using Informix 7.23 (Windows NT) and Informix 7.3 (SUN - Solaris) at the server side and following ODBC-Drivers at the clients: - INFORMIX-CLI 2.5 - INTERSOLV 3.01 32-Bit Informix I'm using NLS for all (non-system) databases and a TCP - Connection (PROTOCOL : olsoctcp at the clients and the NT-Server / oltlitcp at the solaris. If i select any tables, such as "syscrtadt" in the sysmaster database, any CHAR-Fields are filled with wrong data (encrypted ASCII). If you take the table "sysdatabases" all is correct. If you take a native connect to the database-server all is correct, but i'm not able to use the native link, because this have another bug. On the NT-Machine, wich is a slow Server, this error comes always. On the solaris i can remove this error by changing the TCP-Port (but only for ca. 1 day). ------------------------------------------------------------------------ Have I maked any mistake to configure the clients or the servers ? How is the right configuration of both side ? I know this error is mysterious, but is there anybody, who can help me !!!!!!! Sven