How can I run 32-bit ODBC on 64-bit?

To work around this problem, use the appropriate version of the ODBC Administrator tool. If you build and then run an application as a 32-bit application on a 64-bit operating system, you must create the ODBC data source by using the ODBC Administrator tool in %windir%\SysWOW64\odbcad32 .exe.

How do I install 32-bit ODBC?

Step-by-step ODBC Data Source Setup in Windows 10

  1. Press Windows + R to open the Run dialog.
  2. Type in odbcad32 and click OK.
  3. In the ODBC Data Source Administrator dialog box, select the System DSN or User DSN tab.
  4. Click Add.
  5. Locate the necessary driver in the list and click Finish.

How do I run ODBC 32-bit on Windows 7 64-bit?

Answer:

  1. Click, Start, Run.
  2. Type, in the run command, the following depending on your system: For 32-bit operating systems: ODBCAD32. For 64-bit operating systems: C:\WINDOWS\SysWOW64\odbcad32.exe.
  3. Click OK.

How can I tell if my ODBC driver is 32 or 64-bit?

Answer. On Windows 32-bit systems, the ODBC driver is 32-bit if the nsqlodbc. dll file is located in the C:\WINDOWS\system32 directory. Both 32-bit and 64-bit programs can run on 64-bit Windows OS.

How do I install ODBC drivers on Windows 7 64-bit?

Installing ODBC Drivers on Windows 64-bit

  1. Create the directory %OMNIHOME%\platform\win32\DataDirect.
  2. Copy the ODBC32v53 directory to %OMNIHOME%\platform\win32\DataDirect\ODBC32v53.
  3. Run the nco_install_drivers.exe utility to register the drivers in HKLM\SOFTWARE\Wow6432Node\ODBC\ODBCINST.INI\

Do I need a 32-bit or 64-bit ODBC driver?

Though not recommended for various reasons, if you choose to use ODBC drivers to access SQL Server, your ODBC driver needs to be 32-bit to match Campaign Enterprise. If you are on a 32-bit Operating System, the ODBC Connections tool in your control panel can be used to administer the ODBC definition.

How do I update ODBC Drivers?

To update the ODBC driver Windows users can simply download and run the installer for the most current version. The installer will replace the existing ODBC driver installation on the system with the most current version. However, it isn’t always practical to replace an entire installation.

How do I run ODBC on 64-bit?

Create an ODBC data source on 64-bit computers

  1. In Windows Explorer, navigate to C:\Windows\sysWOW64\ .
  2. Double-click odbcad32.exe .
  3. Click the System DSN tab.
  4. Click Add.
  5. Scroll down through the list and select SQL Server, and then click Finish.

Where is the 64-bit ODBC Administrator?

C:\Windows\System32\odbcad32.
The default ODBC Administration tool on 64-bit Windows versions is 64-bit and is located at C:\Windows\System32\odbcad32.exe.

How do I install ODBC Drivers on Windows 7 64-bit?