从64位SQL Server到Informix数据源的ODBC连接
我试图在64位SQL Server中创建到Informix的链接表，并且SQL Server在DSN列表中未列出Informix ODBC.我已经下载了64位的Informix Client SDK，尽管它声明了64位的Informix Client SDK，但它仅出现在32位ODBC DSN中.我试图在32位SQL Server中创建一个链接表，然后便可以看到Informix ODBC DDN.
I am trying to create a linked table in a 64-bit SQL Server to Informix, and the SQL server does not list Informix ODBC in the DSN list. I have downloaded the 64-bit Informix Client SDK, however, despite the fact that it states 64-bit Informix Client SDK, it only appears in the 32-bit ODBC DSN. I tried to create a linked table in a 32-bit SQL Server and I was then able to see Informix ODBC DDN.
我只是想知道是否有一个Informix Client SDK可以在64-ODBC DSN中显示，而不是在32位中显示?
I was just wondering that if there is an Informix Client SDK that would show in the 64-ODBC DSN, not the 32-bit?
还有一种方法可以将64位SQL Server链接到Informix吗? 谢谢.
Also is there a way of linking a 64-bit SQL Server to Informix please? Thanks.
在SQL Server中创建到Informix的数据库链接
我使用了以下软件环境:
I used the following Software environment:
- SQL Server 2012
- Informix SDK 4.10 FC2
- Informix 11.5
首先为Ifxoledbc驱动程序设置一些属性:
First Set some Properties for Ifxoledbc Driver:
然后创建链接服务器:
常规设置-数据源是您的数据库和服务器名称
General Settings - Datasource is your DB and your Server Name
安全设置-添加有效的Informix数据库凭证
Security Settings - Add valid Informix Database Credentials
服务器选项-将RPC和RPC Out设置为True
Server Options - Set RPC and RPC Out to True
我使用db链接在Informix中调用存储过程并将数据写入SQL Server.
I use the db link for calling a stored Procedure in Informix and writing the data to SQL Server.