Easysoft ODBC-ODBC Bridge
Can I can connect a 32-bit application to a 64-bit ODBC driver?
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.
- 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.
- 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.
- In the Windows Services dialog box:
- Stop the 32-bit ODBC-ODBC Bridge Server service (Easysoft ODBC-ODBC Bridge Server).
- Start the 64-bit ODBC-ODBC Bridge Server service (Easysoft ODBC-ODBC Bridge Server x64).
- 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:
Note The 32-bit ODBC Data Source Administrator is not accessible from Windows Control Panel.
- In a Visual Studio 2010 project, on the Data menu, click Add New Data Source.
The Data Source Configuration Wizard starts.
- Select Database on the Choose a Data Source Type page.
- Select Dataset on the Choose a Data Model page.
- Select New Connection on the Choose Your Data Connection page.
- In the Choose a Data Source dialog box, select Microsoft ODBC data source.
- 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.
- Complete the remainder of the Data Source Configuration Wizard.
- Easysoft ODBC-ODBC Bridge
Knowledge Base Feedback