1 Reply Latest reply: Oct 16, 2012 9:10 AM by 968671 RSS

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

    884504
      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