DevOps, CI/CD and Automation

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