从64位SQL Server到Informix数据源的ODBC连接 [英] ODBC connection from 64-bit SQL Server to Informix data source

问题描述

我试图在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.

这篇关于从64位SQL Server到Informix数据源的ODBC连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！