Odbc Driver Manager Missing

Posted on |

Nov 23, 2016  ODBC Driver for Excel 2016 is missing. Microsoft Office Office 2013 and Office 365 ProPlus - Planning, Deployment, and Compatibility. Please check if the Microsoft Open Database Connectivity (ODBC) Data Source Administrator tool (Odbcad32.exe) is existed in the following path.

  1. Odbc Driver Manager Error
  2. Odbc Driver Not Showing Up
  3. Mysql Install Windows
  4. Odbc Driver Manager Missing Download

Hi Team,

Odbc driver manager missing windows 7

I am trying to connect to Oracle 9i database using below VB code:

strConnection = 'Driver={Microsoft ODBC for Oracle};Server=SERVERNAME;Uid=USERID;Pwd=PASSWORD'
Connect = New ADODB.Connection
Connect.Open(strConnection)

The last line throws me below error:

[Microsoft][ODBC Driver Manager] Data Source Name not found and no default driver specified

The VB code is working fine and able to connect to dev database in dev server. The same script with UAT server name is not working in UAT server.

Both the servers are of Windows server 2007 - 32 bit.

When I checked the drivers tab in ODBC Data Source Administrator, dev server has below entry:

Microsoft ODBC For Oracle - 6.00.6001.18000 - Microsoft Corporation - MSORCL32.dll - Date

Whereas UAT server has below entry:

Microsoft ODBC For Oracle -

The driver Microsoft ODBC for oracle is listed in the drivers tab of UAT server but does not have the version & dll file details. Is this driver not installed properly? If yes, how to re install it? Please help to resolve this issue ASAP.

Regards,

Tamil

-->

This article contains instructions to install the unixODBC Driver Manager for use with all the versions of Microsoft ODBC Driver for SQL Server on Linux and macOS.

Important

Delete any driver manager packages installed on your computer before you install the unixODBC Driver Manager. Installing the unixODBC Driver Manager could cause a failure of an existing Driver Manager.

Installing the Driver Manager for Microsoft ODBC Driver 13, 13.1, and 17

Odbc Driver Manager Error

The driver manager dependency is resolved automatically by the package management system when you install the Microsoft ODBC Driver 13, 13.1, or 17 for SQL Server on Linux or macOS by following the instructions in Installing the Microsoft ODBC Driver for SQL Server on Linux or macOS.

Installing the Driver Manager for Microsoft ODBC Driver 11 for SQL Server

Odbc driver not showing up

(SUSE and Red Hat Linux only.)

Using the Installation Script

Important

These instructions refer to msodbcsql-11.0.2270.0.tar.gz, which is the installation file for Red Hat Linux. If you are installing the Preview for SUSE Linux, the file name is msodbcsql-11.0.2260.0.tar.gz.

To install the driver manager:

  1. Make sure that you have root permission.

  2. Go to the directory where the MicrosoftSQL Server ODBC Driver download placed the file called msodbcsql-11.0.2270.0.tar.gz. Make sure that you have the *.tar.gz file that matches your version of Linux. To extract the files, execute the following command: tar xvzf msodbcsql-11.0.2270.0.tar.gz.

  3. Change to the msodbcsql-11.0.2270.0 directory and there you should see a file called build_dm.sh. You can run build_dm.sh to install the unixODBC Driver Manager.

  4. To see a list of the available options, execute the following command: ./build_dm.sh --help.

  5. When you are ready to install, and if your computer can access an external site via FTP, execute the following command: ./build_dm.sh.

If your computer cannot access an external site via FTP, get unixODBC-2.3.0.tar.gz. You can get unixODBC-2.3.0.tar.gz from http://www.unixodbc.org. Click the Download link on the left side of the page to go to the download page. Then click the appropriate link to download unixODBC-2.3.0 (not unixODBC-2.3.1). unixODBC-2.3.1 is not supported with this release of the Microsoft ODBC Driver 11 for SQL Server. Execute the following command to begin the unixODBC Driver Manager installation: ./build_dm.sh --download-url=file://unixODBC-2.3.0.tar.gz.

  1. Type YES to proceed with unpacking the files. This part of the process can take up to five minutes to complete.

  2. After the script stops running, follow the instructions on the screen to install the unixODBC Driver Manager.

You are now ready to install the driver. For more information, see Installing the Microsoft ODBC Driver for SQL Server on Linux and macOS.

Manual Installation

Odbc Driver Not Showing Up

If the installation script is unable to complete, configure and build the proper driver manager yourself.

  1. Remove any older installed version of unixODBC (for example, unixODBC 2.2.11). On Red Hat Enterprise Linux 5 or 6, execute the following command: yum remove unixODBC. On SUSE Linux Enterprise, zypper remove unixODBC.

  2. Go to http://www.unixodbc.org. Click the Download link on the left side of the page to go to the download page. Then click the appropriate link to save the file unixODBC-2.3.0.tar.gz to your computer. UnixODBC-2.3.1 is not supported with this release of the Microsoft ODBC Driver 11 for SQL Server.

  3. On your Linux computer, execute the command: tar xvzf unixODBC-2.3.0.tar.gz.

  4. Change to the unixODBC-2.3.0 directory.

  5. At a command prompt, execute the command: CPPFLAGS='-DSIZEOF_LONG_INT=8'.

  6. At a command prompt, execute the command: export CPPFLAGS.

  7. At a command prompt, execute the command: './configure --prefix=/usr --libdir=/usr/lib64 --sysconfdir=/etc --enable-gui=no --enable-drivers=no --enable-iconv --with-iconv-char-enc=UTF8 --with-iconv-ucode-enc=UTF16LE'.

  8. At a command prompt (logged in as root), execute the command: make.

  9. At a command prompt (logged in as root), execute the command: make install.

You are now ready to install the driver. For more information, see Installing the Microsoft ODBC Driver for SQL Server on Linux and macOS.

Mysql Install Windows

Odbc Driver Manager Missing

Odbc Driver Manager Missing Download

See Also