• Download Informix Odbc Driver Windows 7 64 Bit Bit
• Download Informix Odbc Driver Windows 7 64 Bit Download
• Informix Odbc Driver Windows

Oracle odbc drivers 64 bit free download - OpenLink Lite ODBC Drivers for Oracle 12c (64-bit), Devart ODBC Driver for Oracle, Oracle ODBC driver (32/64 bit), and many more programs. I'm trying to install the Informix ODBC drivers on Windows 7 64-bit so I can run the Wallet Card Wizard. I am getting the following error. There are now two versions of the IBM informix driver. Version 3.70.TC3, Windows (32 bit) Version 3.70.FC3, Windows x64. These are a free download from IBM, registration required. (Informix Client. I'm trying to install the Informix ODBC drivers on Windows 7 64-bit so I can run the Wallet Card Wizard. I am getting the following error: 'Prerequisite verification checks failed. InstallAnywhere has detected that you are installing the 32 bit product on a 64 bit machine. Prefix path with C: Windows SysWOW64 and restart the installer.' – Windows 7 64-bit. I am now stressful to use ilk ODBC conenction thru QlikView minimize; the-p. Driver admittance odbc driver 64 bit db2 odbc driver for windows xp odbc driver for windows 7 32 bit; hump informix odbc driver 64 bit enumeration t2250 pressman driver storage. Results 1 – 20 of 90 7. By default, 64 bit Windows versions use a 64 bit ODBC Administrator utility. How do I install a 32 bit version of ODBC to work with IBM Informix Dynamic Server, when I am using a 64 bit Windows version? The menu option Administrative Tools->Data Sources (ODBC), is the Windows 7 utility used to maintain ODBC data sources and drivers. Installing 32 bit and 64 bit Informix drivers on same machine. Which can handle both 32-bit and 64-bit ODBC Informix Drivers. On 64-bit Windows.

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

4 Answers

Create a DB Link in SQL Server to Informix

I used the following Software environment:

• SQL Server 2012
• Informix SDK 4.10 FC2
• Informix 11.5

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

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.

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

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

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:

1. The Data Source fill-in (YourDatabaseName@YourInformixServerName) could be something as simple as Fred@Barney, rather than what I tried, namely, Fred@199.188.77.66 or Fred@199.188.77.66:32002 (the latter specifies a port/service number).

2. Once you create the linked server, if you go back into its General properties page, you will see that you cannot edit what you typed for Linked Server, Product Name (Why isn't this called 'Provider Name,' since Ifxoledbc is listed under Linked Servers/Providers in the Object Explorer tree?), Data Source, etc. So, if your connection fails because you mistyped something, it is unclear how to fix it.

Here is what you may do:

Download Informix Odbc Driver Windows 7 64 Bit Bit

1. Right-click the linked server.

2. Beneath 'Test Connection,' look for 'Script Linked Server as.'

3. Click the latter, and, then, each of the following: 'DROP And CREATE To'and 'New Query Editor Window.'

4. In the script text that appears, type replacement info for those settings that were grayed-out and uneditable.

5. Press F5 to run the script and thereby apply your changes. In doing so, the existing linked server is dropped, and a new one is created.

6. Open up your linked server's Security properties page and re-enter any connection password (even though asterisks -- suggesting that the password is filled and correct -- may appear in the corresponding entry). Also, examine the General properties page. Make sure that your changes stuck. Even though you ran the script and received no error, SQL Server will blank out fill-ins such as 'Linked Server,' 'Product Name,' and 'Data Source' if, for example, you, as I did, had a brain aneurism and chose the wrong drop-down item for 'Provider.'

7. As noted above, click 'Test Connection,' to verify that your changes work.

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.

Download Informix Odbc Driver Windows 7 64 Bit Download

And another way to consume the System DSN is via OPENROWSET. This works even without setting up a linked server:

Not the answer you're looking for? Browse other questions tagged sql-serverinformix or ask your own question.

By default, 64 bit Windows versions use a 64 bit ODBC Administrator utility. How do I install a 32 bit version of ODBC to work with IBM Informix Dynamic Server, when I am using a 64 bit Windows version?

The menu option Administrative Tools->Data Sources (ODBC), is the Windows 7 utility used to maintain ODBC data sources and drivers. The path for this ODBC administrator utility is '%windir%system32odbcad32.exe'. Although it is referenced as '32' in the path name, it is a 64 bit administration tool. The IBM Informix 32 bit ODBC option will not be visible when using this utility.

In order to use a 32 bit ODBC driver on a 64 bit Windows machine, it has to be configured using a 32 bit ODBC Administrator which is not visible through normal Windows menu options. Utilities for 32 bit operations are found in the C:WindowsSysWOW64 directory. As a prerequisite for a 32 bit IBM Informix CSDK installation to proceed correctly, add the SysWOW64 directory to the system path, as follows: Boy scout troop program features pdf to excel.

Run 'C:WindowsSystem32control.exe system'

• Select Advanced system settings from Control Panel Home

On the System Properties Panel that appears,

• Select: Advanced tab->Environment Variables

In the System Variables window under Environment Variables,

• Select and edit the PATH variable. Prefix the PATH list with 'C:WindowsSysWOW64;'

Proceed with the IBM Informix CSDK product installation. The suggested install directory for 32 bit CSDK is 'C:Program Files (x86)IBM Informix Client SDK'.
Once the CSDK installation is completed, access the ODBC administrator utility located at 'C:WindowsSysWOW64odbcad32.exe'.
Now, when you access the Drivers Tab of the ODBC Administrator, the IBM Informix Driver is visible. This is the one you want to use.

Informix Odbc Driver Windows

At this point, you can proceed with normal configuration.