Download ODBC Drivers for Oracle®, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase & DB2.

Easysoft ODBC-ODBC Bridge

Can I can connect a 32-bit application to a 64-bit ODBC driver?

Article:
01027
Last Reviewed:
21st October 2011
Revision:
1

Yes, you can connect a 32-bit application to a 64-bit ODBC driver by using the ODBC-ODBC Bridge.

Without the ODBC-ODBC Bridge, a 32-bit application cannot connect to a 64-bit ODBC driver. 32-bit applications must be linked against 32-bit libraries. For this reason, 32-bit applications can only link against a 32-bit ODBC Driver Manager library. 32-bit ODBC Driver Managers can only load 32-ODBC drivers.

The ODBC-ODBC Bridge is a client/server product. The ODBC-ODBC Bridge Client is not linked against the ODBC-ODBC Bridge Server. The ODBC-ODBC Bridge Client communicates with the ODBC-ODBC Bridge Server by using the Remote Procedure Call (RPC) mechanism. A 32-bit ODBC-ODBC Bridge Client can be used with a 64-bit ODBC-ODBC Bridge Server and vice versa.

To connect a 32-bit application with a 64-bit ODBC driver, you use a 32-bit ODBC-ODBC Bridge Client and a 64-bit ODBC-ODBC Bridge Server.

ODBC calls made by your 32-bit application are passed from the 32-bit ODBC driver (the ODBC-ODBC Bridge Client) to the target 64-bit ODBC driver via the 64-bit ODBC-ODBC Bridge Server.

Example: How to Connect a 32-bit Application to a 64-bit ODBC Driver

The following steps show how to access a 64-bit ODBC driver from a 32-bit application on a 64-bit Windows machine. The ODBC driver used is the Microsoft SQL Native Client driver. The application used is Visual Studio 2010.

  1. In the 64-bit ODBC Data Source Administrator (accessible from Administrative tools in Control Panel), configure a System data source for the SQL Native Client driver.
  2. Install the 64-bit Windows ODBC-ODBC Bridge distribution.

    Accept the Default option during Setup, which will install both the ODBC-ODBC Bridge Client and Server components.

  3. In the Windows Services dialog box:
    1. Stop the 32-bit ODBC-ODBC Bridge Server service (Easysoft ODBC-ODBC Bridge Server).
    2. Start the 64-bit ODBC-ODBC Bridge Server service (Easysoft ODBC-ODBC Bridge Server x64).
  4. In the 32-bit ODBC Data Source Administrator, configure an ODBC-ODBC Bridge Client data source that points to the SQL Native Client driver data source.

    To access the 32-bit ODBC Data Source Administrator, run the following command in the Windows Run dialog box:

    %windir%\syswow64\odbcad32.exe

    Note The 32-bit ODBC Data Source Administrator is not accessible from Windows Control Panel.

  5. In a Visual Studio 2010 project, on the Data menu, click Add New Data Source.

    The Data Source Configuration Wizard starts.

  6. Select Database on the Choose a Data Source Type page.
  7. Select Dataset on the Choose a Data Model page.
  8. Select New Connection on the Choose Your Data Connection page.
  9. In the Choose a Data Source dialog box, select Microsoft ODBC data source.
  10. In the Add Connection dialog box, choose your your ODBC-ODBC Bridge Client data source from the Use user or system data source name list.
  11. Complete the remainder of the Data Source Configuration Wizard.
See Also
Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)


Oracle is a registered trademark of Oracle Corporation and/or its affiliates.