环境：

本地：Windows 2003+VS2008,IBM CSDK 3.50

远程：Red Hat Enterprise Linux AS release 4 (Nahant Update 5)+Informix Dynamic Server 2000 Version 9.21.UC2

现象：

创建ODBC数据源时，提示

“---------------------------IBM Informix ODBC Error Message:---------------------------Test connection was NOT successful.[Informix][Informix ODBC Driver][Informix]Client host or user (informix@zzy-flyinweb) is not trusted by the server.-----------------------” 

解决办法：

在远程服务器上创建/etc/hosts.equiv 文件，内容如下：

[root@datacenter ~]# cat /etc/hosts.equiv
zzy-flyinweb
59.57.251.62

现象：

报错：System.Data.Odbc.OdbcException: ERROR [42000] [Informix][Informix ODBC Driver][Informix]A syntax error has occurred.

解决办法：

请检查SQL语句是还正确

特别注意：VS2008在自动生成的SQL代码中，会将字段名及表名加[]号括起，而这可能会引起语法错误（不知是不是Informix的原因，去掉相关的中括号即可）

另外，OLEDB方式一直没有通过，原因未知

06 Oct 2005

Delve into the details of using ADO.Net and Informix® Dynamic Server beyond the basic connection string. This article covers stored procedures and parameterized SQL. Then it presents a model (with code) for generating your own strongly typed DataSets.

Introduction

With its massive .NET framework, Microsoft® introduced a new data access technology called ADO.NET. In this article, we will examine how to use the ADO.NET driver for Informix that is included with the IBM Client SDK version 2.90. The sample code included is written in C#.