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