ODBC drivers.

Lots of questions about ODBC. Has anyone got ODBC for Informix 9.1.4 working on a application? For example, Excel running on a NT box to Informix 9.1.4 running on Solaris 2.6? Has anyone got ODBC running with user defined data types? We have been trying to get ODBC running on many different applications using User defined data types, and cannot get anything to work. Any comments? Does anybody know of any other way to access User defined types in Informix 9.1.4 of a network, without using ODBC. Perhaps setnet32? I have tried this and it explodes. Thanks for all your help. David Tamburin david.tamburin@protegrity.com

David, See my comments below: David Tamburin wrote in message <79pvo0$o3g$1@news.xmission.com>... > >Lots of questions about ODBC. > >Has anyone got ODBC for Informix 9.1.4 working on a application? >For example, Excel running on a NT box to Informix 9.1.4 running on Solaris >2.6? We have it working just fine in that same environment with all of the following: Informix 2.8 Intersolv 3.01 Intersolv 3.10 > >Has anyone got ODBC running with user defined data types? >We have been trying to get ODBC running on many different applications >using User defined data types, and cannot get anything to work. >Any comments? Only the Informix 2.8 ODBC driver handles user defined types correctly. > >Does anybody know of any other way to access User defined types in Informix >9.1.4 >of a network, without using ODBC. Perhaps setnet32? I have tried this and >it explodes. You can use the iconnect libs or client side datablade api. Setnet32 configures your sqlhosts registry for you. You should be able to test the functionality with SqlEditor 2.0 and up, it handles row types nicely. Frank Oelschlager ECOlogic Corporation > >Thanks for all your help. > >David Tamburin >david.tamburin@protegrity.com >