Menu

Navigation

How do I run a 64-bit ODBC Administrator?

Posted on by Arif Clayton

How do I run a 64-bit ODBC Administrator?

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 configure ODBC Data Source Administrator?

Add an ODBC data source

  1. Click Start, and then click Control Panel.
  2. In the Control Panel, double-click Administrative Tools.
  3. In the Administrative Tools dialog box, double-click Data Sources (ODBC).
  4. Click User DSN, System DSN, or File DSN, depending on the type of data source you want to add.
  5. Click Add.

How do I run ODBC as administrator?

To open the ODBC Data Source Administrator in Windows 7

  1. On the Start menu, click Control Panel.
  2. In Control Panel, click Administrative Tools.
  3. In Administrative Tools, click Data Sources (ODBC).

What is the location of 64-bit ODBC Administrator?

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

What is a 64-bit ODBC?

The 64-bit ODBC Administrator tool can be invoked from Control Panel to manage user DSNs and system DSNs that are used by 64-bit processes. On a 64-bit operating system, the 32-bit ODBC Administrator tool is used for Windows on Windows 64 (WOW64) processes.

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

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

How do I install 64 bit ODBC drivers?

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.

Where are the ODBC drivers stored?

The ODBC driver must be installed locally. The . dsn file is a text file that you can view in any text editor, such as Microsoft Notepad. The File DSNs are stored by default in the following location:Program Files\Common Files\Odbc\Data Sources folder.

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

Where to find Microsoft ODBC data source administrator?

The Microsoft® ODBC Data Source Administrator manages database drivers and data sources. This application is located in the Windows Control Panel under Administrative Tools. Beginning in Windows 8, the icon is named ODBC Data Sources, and on 64-bit operating systems there is a 32-bit and 64-bit version.

Is there a 32 bit or 64 bit ODBC Administrator Tool?

Similarly, the 32-bit ODBC Administrator tool does not display system DSNs that are created by the 64-bit ODBC Administrator tool. Also, the 64-bit ODBC Administrator tool does not display system DSNs that use 32-bit drivers. Similarly, the 32-bit ODBC Administrator tool does not display system DSNs that use 64-bit drivers.

How to create a 32-bit ODBC data source?

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.

Where to find ODBC in Windows Control Panel?

You can find ODBC in the Windows Control Panel by searching for ODBC. Once you are in the ODBC Data Source Administrator (64-bit), do these steps: Select the Firebird/Interbase ODBC driver you previously installed. Type a Data Source Name (DSN) such as DBA.