Geek Answers Handbook

Connecting to a 32-bit Oracle server with 64-bit Excel

I am trying to connect my Excel to Oracle with this connection string in VBA:

dim cn As New ADODB.Connection
cn.Open "Provider=OraOLEDB.Oracle;Data Source=source;User Id=userid;Password=pwd;"

I get this error:

Run-time error '3706':
Provider cannot be found. It may not be properly installed.

Relevant links:

Microsoft ActiveX Data Objects 6.1 Library
OraOLEDB 1.0 Type Library
  • Excel is the 64-bit version of MS Office Professional Plus 2010.
  • Windows - 7 Enterprise Service Pack 1 64 bit
  • Oracle Client - 11.2.0 32 bit (I think)
  • Oracle server is Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

... , , , 32- 64- , . , , - , . Oracle 64-, MS Office? 64- Oracle? , MSDAORA OraOLEDB.Oracle...

+4
3

, 64- Excel, 64- Oracle 64- OLE DB.

OLE DB Microsoft (.. MSDAORA) 64-. 32- .

, 32- Oracle - , , , . 32-, 64- Oracle Client . Oracle Client x86 x64

+3

, - oracle excel 32- excel.

Bat, excel, - :

#
Set Temp=C:\Temp
Set TMP=C:\Temp
Set Oracle_Home= #YourDriveLetterhere - >M:\ORA12C\product\12.1.0\client_1
Set Path=C:\Windows;C:\Windows\System32;M:\ORA12C\product\12.1.0\client_1\bin;M:\ORA12C\product\12.1.0\client_1\nls\mesg;M:\ORA12C\product\12.1.0\client_1\network\admin;

START "" "C:\MacroFileNameWhichConnectsToOracle.xlsm"
#
0

oracle .

Try to open dos window and type c: \ tnsping yourservername

look at the installation problems.

-2
source

More articles:


All Articles