Access Informix from .net
A developer asked whether .NET OleDB could be used against Informix, hoping to share one set of parameterized SQL between SQL Server and Informix clients. Replies pointed to the native IBM Informix .NET provider shipped with Client SDK 2.81.TC3 and later, noting it isn't installed by default — you must do a custom install and explicitly select the .NET driver. A developerWorks article on the .NET provider and a download link for CSDK were supplied; one poster added that CSDK is free but support for it is chargeable.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
We have both SQL server client and Informix client. The ideal solution will be maintain single set of sql statement for both. Do you know if .net OleDB library can access InforMix? Or there is a better solution. Our current code use dynamic sql with ? as parameter and ODBC connection. for example "select * from user where userid = ?". there is no type checking when pass in the parameter. Thanks -fj
fj, The Informix Client SDK 2.81TC3 or higher will have .net driver for Informix. You will have to do a custom install and specifically select the .net driver to be installed or the installation will skip it. Good luck, DL Redden ----- Original Message ---- From: fj <frank.z.jiang@gmail.com> To: informix-list@iiug.org Sent: Monday, April 3, 2006 12:47:46 PM Subject: Access Informix from .net We have both SQL server client and Informix client. The ideal solution will be maintain single set of sql statement for both. Do you know if .net OleDB library can access InforMix? Or there is a better solution. Our current code use dynamic sql with ? as parameter and ODBC connection. for example "select * from user where userid = ?". there is no type checking when pass in the parameter. Thanks -fj _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list
fj wrote: > We have both SQL server client and Informix client. The ideal solution > will be maintain single set of sql statement for both. > > Do you know if .net OleDB library can access InforMix? Or there is a > better solution. > > Our current code use dynamic sql with ? as parameter and ODBC > connection. for example "select * from user where userid = ?". there is > no type checking when pass in the parameter. > > Thanks > > -fj > Take a look on this article http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0510durity/index.html
Where do I download a copy of CSDK 2.90? I did a little search on IBM website and find only documentations.
http://www14.software.ibm.com/webapp/download/preconfig.jsp?id=2005-08-15+14%3A41%3A25.229714R&S_TACT=104CBW71&S_CMP=&s= ----- Original Message ---- From: fj <frank.z.jiang@gmail.com> To: informix-list@iiug.org Sent: Monday, April 3, 2006 5:26:11 PM Subject: Re: Access Informix from .net Where do I download a copy of CSDK 2.90? I did a little search on IBM website and find only documentations. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list
If you download Client SDK you do not get support included. While Client SDK is free, support for Client SDK is chargable. Informix continues to improve its .NET driver with every release of Client SDK.