This discussion is archived
1 Reply Latest reply: Oct 16, 2012 7:10 AM by 968671 RSS

Connect to Oracle Database from Windows 64 bit to Offic2007 32bit

884504 Newbie
Currently Being Moderated
Good day to all,

I know that there are many threads with similar subject, but I could't found how can I put the connection string to my code

I have installed insance clinet 32bit for oracle, all about TNS, configurations, I have created UDL file running for 32 bit application through command

C:\Windows\syswow64\rundll32.exe "C:\Program Files (x86)\Common Files\System\Ole DB\oledb32.dll",OpenDSLFile C:\test.udl

and test connection is ok.

But I put in my code (VBA Access 2007 32 bit) the connection string:"Provider=MSDASQL.1;Password=psw;Persist Security Info=True;User ID=user;Data Source=DSNName-32bit"

and I receive the error: "[Microsoft][ODBC driver for Oracle][Oracle]ORA-06413: Connection not open."

I think that I am close to solution but I need a help

Pls advise

Michael

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points