Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.3K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 394 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
Excel to Oracle connection Windows 64bit, Excel 32 bit

I have seen various flavors of this discussion, but am not able to solve my specific problem.
- I am running 64-bit Windows 7 Professional.
- I have Office 32-bit.
- I have both 64-bit Oracle 12, and 32-bit 11g client installed
- My path is
C:\app\**\product\32bit\11.2.0\client_1;C:\app\**\product\12.1.0\dbhome_2\bin;
- I do not have an ORACLE_HOME or TNS_ADMIN variable configured
Now I want to connect Excel to a remote data
base. In the Excel ribbon Data -> Connections, there is a connection of type 'OLE DB Query', with a Connection string
Provider=MSDAORA.1;User ID=**;Data Source=[Host]:1521:[SID];Password=[**]
There is no other database configuration. How can I tell it to connect to the 32bit client? Now when I run this, I get
'ORA-12545: Connect failed because target host or object does not exist'
(I am able to connect to the database using SQLDeveloper)
So next, I modify the 'Connection Properties' - > 'Connection string' to
Provider=MSDAORA.1;User ID=**;Data Source=(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)
(HOST = [Host])
(PORT = 1521)
)
(CONNECT_DATA = (SID = [SID])
(SERVER = DEDICATED)
)
)
'ORA-12154: TNS: could not resolve the connect identifier specified'
Does anyone know how to fix this please?
Answers
-
Hi,
If you are trying to connect Oracle DB from Excel using Oracle Client, follow the steps as below :
1. Click on Data in Excel workbook
2. Choose "From other sources" icon.
3. In the dropdown menu, choose "From Data Connection Wizard"
4. Select "Other/Advanced" and click next
5. Select "Oracle Provider for OLEDB"
In data link properties provide data source, user id and password to establish DB connection.
thanks and regards
Venkat
-
When I try to do that, I get error
'OraOLEDBpus10.dll: The specified module not found'.
SO is it not able to use the client that I installed?
Thanks so much!
-
Hi,
The message "OraOLEDBpus10.dll: The specified module not found" indicates that the client version is 10g.
Register the 11g client (using rEGSVR32 utility) and try to establish the connection.
thanks and regards
Venkat
-
The oracle client I have installed is 11g. I have a 10g oracle installed, but i removed that from the path. OK, I found the rEGSVR32 file in my
C:\Windows\winsxs\x86_microsoft-windows-regsvr32_31bf3856ad364e35_6.1.7600.16385_none_782d737490d72da3
directory..hope that is correct.
It says that I ave to run it with the name of a dll. Which one should I use please?
Thanks so much!
-
Also, I am looking at
C:\app\**\product\32bit\win64_11gR2_client\client
There is no bin directory here. And no OraOLEDB11.dll file....
-
OK, I managed to do a custom install of Oracle11g driver, and ran the rgsrv32 on the OraOleDB11.dll.
When I try to make the data connection I still get the
'OraOLEDBpus10.dll: The specified module not found'.
Do i have to install Oracle 10g client?
-
Hi,
Please perform udl test using 11g client after registering the dll.
If the connection to database is successful, use it in your application.
thanks and regards
Venkat