IBM® Informix® ODBC Driver is the Informix implementation of the Microsoft Open Database Connectivity (ODBC) standard. It supports SQL statements with a library of C functions that an application calls to access IBM Informix databases. For more information, see the IBM Informix ODBC Driver Programmer's Manual.
Active2 years, 6 months ago
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.
I was just wondering that if there is an Informix Client SDK that would show in the 64-ODBC DSN, not the 32-bit?
Also is there a way of linking a 64-bit SQL Server to Informix please?Thanks.
TallTed
7,27822 gold badges1515 silver badges2929 bronze badges
user3787561user3787561
4 Answers
Create a DB Link in SQL Server to Informix
I used the following Software environment:
First Set some Properties for Ifxoledbc Driver:
Then Create Linked Server:
General Settings - Datasource is your DB and your Server Name
Security Settings - Add valid Informix Database Credentials
32-bit Ram
Server Options - Set RPC and RPC Out to True
I use the db link for calling a stored Procedure in Informix and writing the data to SQL Server.
SGeisSGeis
Did you use the 64 bit version of ODBCAD32.EXE to create the DSN?
There are two versions of the ODBC administrator.
This one is the 32 bit version:
It can only see 32 bit drivers, and only 32 bit processes can see it's DSN's Document translation software.
This one is the 64 bit version:
It can only see 64 bit drivers, and only 64 bit processes (i.e. SQL Server 64 bit) can see it's DSN's
Even better you could define a DNS-less connection which doesn't use a DSN, it uses the driver directly. Then you can avoid this confusing step altogether.
Nick.McDermaidNick.McDermaid
12.6k33 gold badges2929 silver badges5858 bronze badges
I would have used the Comment feature, but I do not have enough 'Reputation Points' to do so.
The answer of SGeis, above, is on the money. It was hard for me to find such a clear, straightforward answer. Snapshots of the dialog boxes help immensely.
Let me add to his answer the following:
Here is what you may do:
The folder ibmtools is also gone. Several of them have two optical drives, neither of them working properly. I have several XP or Win7 IntelliStations, and ALL of them seem to have PC Doctor deleted. What is pc doctor 5 for windows. I THINK my solution is to get PC Doctor working again, so I can check out these drives. But I have looked in a great many places, and can find nothing that would help me get a replacement copy of PC Doctor.
JOINtheFunJOINtheFun
I was able to set up a linked server without Ifxoledbc. Once my System DSN for the 64-bit ODBC driver was set up (and tested OK), I set up a linked server using the Microsoft OLE DB Provider for ODBC Drivers.
Linked Server: UCCX
Provider: Microsoft OLE DB Provider for ODBC Drivers Product name: IBM Informix ODBC Driver (probably could be anything but I named it the same as the ODBC Driver and it worked). Data Source: UCCX (the name of your System DSN).
On the security tab I mapped a local login to the same remote user/password as the one set up in the System DSN itself.
And another way to consume the System DSN is via OPENROWSET. This works even without setting up a linked server:
FloookFloook
Not the answer you're looking for? Browse other questions tagged sql-serverinformix or ask your own question.Related searches
ibm informix 64 bit odbc driver downloadat UpdateStar
ibm informix 64 bit odbc driver downloadsearch results
Descriptions containing
ibm informix 64 bit odbc driver download
Additional titles containing
ibm informix 64 bit odbc driver download
Most recent searches
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |