The only installation order for 11.1 is to install the 11.1 Oracle Client,ODBC, ODP, and OLEDB first. Then apply any Oracle Database patchsets, if needed to fix a specific issue. 64-bit Oracle Client Installation: For 64-bit Oracle clients, install the Oracle client and ODBC from the Oracle client installation into the 64bitclient Oracle home. Download Oracle ODBC driver (32/64 bit) for free. Oracle ODBC driver (32/64 bit) - Devart ODBC Driver for Oracle provides high-performance and feature-rich connectivity solution for ODBC-based applications to access Oracle databases from Windows, Linux and Mac OS X, both 32-bit and 64-bit. Database client stack is in general required for the ODBC driver to use - think of it as sitting at the application layer. Then the 'end' application is a layer on top. That's one reason to differentiate between native and odbc apps. ODBC apps require an additional API layer over the native API layer e.g. OCI in Oracle's case.
I recently had an issue where after the installation of a Third party Client side tools, we were not able view the drivers listed in the ODBC Data Source Administrator (odbcad32.exe).
In order to create a DSN to use this third party driver, we had to take a backup/export of the registry key of an existing DSN, edit the content of the registry and rename the existing DSN name to new DSN and then had to merge it back to the registry.
We did check that we had the sufficient privileges on the system, the third party client tools is properly installed and we are able to use this driver for connecting to the third party databases without any issues. So we realized that the issue is not with the third party driver rather it is the registry key from where the ODBC Data Source Administrator (ODBCAD32.exe) actually picks up the list of drivers.
The ODBC Data Source Administrator (ODBCAD32.exe) picks up the list of entries from the following registry path.
On a x64 bit system for a x64 bit drivers: HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIODBC Drivers
On a x64 bit system for a x32 bit drivers: HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBCINST.INIODBC Drivers
On a x32 bit system:
HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIODBC Drivers
Oracle Odbc Client Install
Note: Above screenshot is taken from a x64 bit system for a x64 bit driver
We realized that the values for the following registry keys should always be (value not set) and if the value is set to an empty string or any other value (either by Third party application or open this registry and close it without any changes) we will run into similar kind of issues where the drivers are not listed in ODBC Data Source Administrator (odbcad32)
On a x64 bit system for a x64 bit drivers:
1) HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIODBC Drivers(Default) and
2) HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INI(Default)
On a x64 bit system for a x32 bit drivers:
1) HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBCINST.INIODBC Drivers(Default) and
Oracle 11g Client Odbc Driver 32 Bit
2) HKEY_LOCAL_MACHINESOFTWAREWow6432NodeODBCODBCINST.INI(Default)
On a x32 bit system:
1) HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIODBC Drivers(Default) and
2) HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INI(Default)
So in order to make this change we would need to perform the following registry changes.
1. Please note before modifying any registry entries we would recommend you to perform a backup of the registry. Please refer the following article on how to backup and restore the registry.
How to back up and restore the registry in Windows: http://support.microsoft.com/default.aspx?scid=kb;EN-US;322756
a. On Windows Vista and later - Go to Start | Run and enter the following: regedit
Click OK and the Registry Editor will open.
b. On prior versions of Windows
Start > Run > type Regedit.exe and press Enter or
Start > Run > type Regedt32.exe and press Enter
On a x64 bit system for a x64 bit driver:
a. Go to Start | Run and enter the following: odbcad32.exe (By default this will load the odbcad32.exe from C:WindowsSystem32odbcad32.exe).
Click OK and the Registry Editor will open.
On a x64 bit system for a x32 bit driver:
a. Go to the following path C:WindowsSysWOW64 and open the odbcad32.exe
(This will load the 32 bit version of ODBC Data Source Administrator)
On a x32 bit system:
a. Go to Start | Run and enter the following: odbcad32.exe (By default this will load the odbcad32.exe from C:WindowsSystem32odbcad32.exe).
Click OK and the Registry Editor will open.
Oracle Instant Client Odbc Driver
We should be able to successfully see the drivers listed in the drivers Tab and should be able to create the DSN’s using that driver.
Or
1. To make this even easier we just need to execute the following command in elevated command prompt and refresh the registry
reg.exe DELETE 'HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIODBC Drivers' /ve /f
and
reg.exe DELETE 'HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INI' /ve /f
Oracle Client Odbc Driver Download
If you run into issues similar to this wherein the system DSN’s are missing please follow the below article.
System DSN Entries Do Not Appear in ODBC Data Source Administrator (odbcad32.exe): http://support.microsoft.com/kb/2000277
Oracle Instant Client Odbc Driver Install
Author : Krishnakumar Rukmangathan(MSFT), SQL Developer Engineer, Microsoft
Gann Lines Analyzer is a powerful application designed to show the Pivot price and time by Square of nine Gann Lines Analyzer is a powerful application designed to show the Pivot price and time by Square of nine, advanced and simple Gann fan, Super Andrews Pitchfork, the star of David d-OC?OCo1 and the star of David d-OC?OCo2 by presenting the result in graphical form.This Gann tool is compatible with any other Forex software, as well as with any other trading system, and with any images and charts.
Reviewed by : Jason(MSFT), SQL Escalation Services, Microsoft
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |