Should I use 32 or 64-bit ODBC?

Should I use 32 or 64-bit ODBC?

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 create a 64-bit ODBC connection?

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.

How do I create a 32-bit ODBC on a 64-bit server?

Procedure

  1. Install the ODBC drivers. For Microsoft SQL Server database servers, install the 64-bit database ODBC drivers on your Microsoft Windows system.
  2. Run the 32-bit ODBC Administrator application, located at [WindowsDir] \SysWOW64\odbcad32.exe.
  3. Use the application to create your DSN.

Can 64-bit Excel use 32-bit ODBC?

You cannot use the 32-bit ODBC driver with a 64-bit version of Excel. You also cannot have a 32-bit and 64-bit version of the same version of Excel on the same system.

Where what folders are the ODBC 32-bit and ODBC 64-bit configuration applications found in Windows 10?

The 32-bit version of odbcad32.exe is located in the C: \Windows\SysWoW64 folder. The 64-bit version of odbcad32.exe is located in the C: \Windows\System32 folder.

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

Open the 32-bit ODBC Data Source Administrator from a Command Prompt

  1. From the Start menu, select Run… The Run dialog prompt opens:
  2. In the Open: field enter “C:\Windows\SysWow64\Odbcad32.exe”:
  3. Click OK.
  4. The rest of this setup follows the same steps as Step 4 of Setting up an ODBC System Data Source Name (DSN).

What version of ODBC driver do I have Windows?

To check the ODBC SQL Server driver version (32-bit ODBC) In the ODBC Data Source Administrator, click the Drivers tab. Information for the Microsoft SQL Server entry is displayed in the Version column.

How do I create an ODBC connection to a SQL database in Windows 10?

  1. Click Start and select Settings > Control Panel > Administrative Tools.
  2. Double-click Data Sources (ODBC) to open the ODBC Data Source Administrator.
  3. Select the System DSN tab.
  4. Click Add.
  5. Select SQL Server and click Finish.
  6. Complete the DSN Configuration wizard (see example screen shots below)

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

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. To indicate the type of DSN, you can add ‘_32’ to the 32-bit user DSNs and ‘_64’ to the 64-bit user DSNs.

How can I tell if Excel is 64 bit?

First, select “File” from the main menu. The select “Account” from the left menu. Then select “About Excel” from the box on the right. The text at the top of the dialog will show if Excel is 32 or 64 bit.

Where do ODBC connections get stored?

System ODBC data sources are stored in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC. INI . User ODBC data sources are stored in HKEY_CURRENT_USER\Software\ODBC\ODBC.

How do I know if my ODBC driver is 64 bit?

On Windows 8 and later versions, open the Control Panel and search ODBC, and then choose Set up ODBC data sources (64-bit). Then go to the System DSN tab, choose the DSN and click configure. The version number appears at the bottom left of the window that pops up.

Is 64-bit Excel better than 32-bit?

Computers running 64-bit versions of Windows generally have more resources such as processing power and memory, than their 32-bit predecessors. Also, 64-bit applications can access more memory than 32-bit applications (up to 18.4 million Petabytes).

Can you have both 32-bit and 64-bit Excel?

Make sure all versions of Office are either 32-bit or 64-bit. You can’t have a mix of both.

Where is ODBC 64bit?

Windows\System32 folder
The 64-bit version of the Odbcad32.exe file is located in the %systemdrive%\Windows\System32 folder.