The installation takes a long time and there's no uninstaller, so I have to manually delete the files after installation. I'm doing trial and error, but it's messy. Since I cannot get InstantClient to work with my companies restrictions, I'm now aiming to use this package, but hopefully to slim it down to just the component I need. ERROR 42000 MicrosoftODBC SQL Server DriverSQL ServerProcedure or. However, it contains several other components that I do not need, and throws some errors during installation that are disconcerting.Ĭan anyone tell me which of the following components I actually need to select in order to get the ODBC Driver? 0 software for the Microsoft Windows Server 2008, Windows Server 2008 R2. This package includes the Oracle ODBC driver which works for my application. However, I have installed the ODAC 12.2c Release 1 and Oracle Developer Tools for Visual Studio (12.2.0.1.0), available HERE. Once I installed it, if I go to ODBC 64-Bit there is only SQL Server as a driver.
#Install excel odbc driver windows 7 install#
Posting this screen shot may not have helped either. Hi all, I am trying to install ODBC driver IBM Informix 64-Bit on a Windows 2012 R2 server but it is unsuccessfull. I’d referred them to this post on adding MySQL’s ODBC driver to Windows 7 but that didn’t help enough.
The installation requires a number of configuration steps that I cannot perform due to administrative restrictions on my workstation. Somebody was trying to query Oracle via Microsoft Excel 2007, and didn’t have an Oracle ODBC Data Source that enable them to choose Oracle. Many have advised Oracle Instant Client, but this has not worked for me. Run the following command in the command prompt: Install.bat. I am using an Excel VBA application to connect to an Oracle 12c database. Open the Command Prompt as an administrator and navigate to the extracted.