Microsoft Odbc For Oracle Windows 2008
I have an installed Oracle 11g client and have verified that I can connect the client to the database. I can also connect to the Oracle server from the client's Microsoft ODBC Administrator. However, the server is not included in the list of ODBC data sources in either Access or MS-Query. I tried to add the database in Access as new data source, selected 'Microsoft ODBC for Oracle' and got the error message 'The Oracle(tm) client and networking components were not found.' Any insights would be greatly appreciated.
We are testing the operational system Windows Server 2008 r2 in one of our clients. This system does not accept the installation of the tool Microsoft ODBC for Oracle. We’d like to know how to install this Driver, once Microsoft’s webpage does not mention any help related to this issue (there is instruction only for the installation of MDAC). We’ve consulted discussion forums and all types of ocurrence on the Internet, but we started to think it’s a Bug of the version. Can you inform us what’s the solution for the problem? We are looking forward to your answer.
I'd like to thank you for the hints. I found the solution by searching information in the forums you indicated. This is the solution: The 32bit Oracle driver is used more often even on a 64bit Windows OS. This is because all 32bit applications are using the 32bit ODBC. If you are trying to use the 32bit client in order to use MS Access and such, you need a work around. Yes there is the problem when oracle parses the brackets and the workaround is not to install the Oracle client to another directory without (x86).
You can install as usual but it seems that the inventory is forced to be installed in 'Program Files (x86)'. This is the part where things break. So after the installation, search for 'Oracle Inventory' in the registry and change it to another location without brackets and move the directory over.
Microsoft Odbc For Oracle Setup
This resolves one problem. Second problems is that ODBC management in 'Administrator Tools' doesn't include the management of the 32bit ODBC connections. This is located in the SysWow64 folder with the same exe name. Make a shortcut of this to make it easier. I'd like to thank you for the hints. I found the solution by searching information in the forums you indicated.
This is the solution: The 32bit Oracle driver is used more often even on a 64bit Windows OS. This is because all 32bit applications are using the 32bit ODBC. If you are trying to use the 32bit client in order to use MS Access and such, you need a work around. Yes there is the problem when oracle parses the brackets and the workaround is not to install the Oracle client to another directory without (x86). You can install as usual but it seems that the inventory is forced to be installed in 'Program Files (x86)'. This is the part where things break.
So after the installation, search for 'Oracle Inventory' in the registry and change it to another location without brackets and move the directory over. This resolves one problem. Second problems is that ODBC management in 'Administrator Tools' doesn't include the management of the 32bit ODBC connections.
Features of the Oracle ODBC Driver Release 12.1.0.1.0 software for the Microsoft Windows Server 2008, Windows Server. And before using the Oracle ODBC Driver. Microsoft odbc for oracle windows 7 32 bit. Distributed environment Microsoft Windows 2008. How to fix Microsoft ODBC for Oracle on a Windows Server 2008 R2 RDP.
Apr 16, 2017 Fixes an issue in which you can't connect to Oracle database by using Microsoft ODBC or OLE DB Driver for Oracle or Microsoft DTC in Windows 8.1, Windows.
This is located in the SysWow64 folder with the same exe name. Make a shortcut of this to make it easier. I got it working with a clean install on Windows Server 2008 R2 64-bit with the 64-bit client: extract 11107w2k8x64productionclient.zip, r ight-click on setup and select “Run as Administrator” During the Oracle install – it will fail operating system checks (only goes to ver 6.0 – R2 is 6.1) so manually check the top 2 boxes and click next. After the install, search c: for “Oracle Inventory” – if it is in 'C: Program Files (x86)' move it to 'C: Program Files' and then go to the registry editor.
Search for 'Oracle Inventory'. Chang the instloc value from C: Program Files (x86) Oracle Inventory to C: Program Files Oracle Inventory. Then reboot the server for good measures. We just installed 10204vistaw2k8x64productionclient on a clean w2k r2 64bit. For us, we always had to use the Microsoft ODBC for Oracle driver, since we needed to connect to more than 1 version away of Oracle databases.
Microsoft Odbc For Oracle Download
(for example: with the Oracle v10, then it will connect to only v9, v10, and v11 databases. In our case, we have v8 on ticket vending machines) The install does put the oracle inventory in the c: Program Files, so, it does appear that the install works.(we still had to use the parameter: -ignoreSysPrereqs to have the installer ignore the os version) However, we still do not see a Microsoft ODBC for Oracle driver.