32 and 64 bit oracle client on same machine

[Moehre]

Dear sirs, I am using the latest UniDac version 6.2.10 with delphi seatle on a windows 10 / 64 bit server with oracle 12c database. I have no problems to use the 64 bit client, but as the delphi ide is 32 bit I installed the 32 bit oracle 12c instant client software. It is located in another path and this path is stored in the path variable, but when I start an app as 32 bit the "Can't initialize oci: error -1" error occures.

What am I missing here? (as I told the path variable is set and the oci.dll and ociw32.dll files can be found there)

Thx in advance
Detlev

[Moehre]

I found the solution!

You have to install the Oracle 12c 32bit runtime environment, not the instant client! Unfortunately oracle had messed up the installer on windows 10:

1. edit the orapam.ini file before (!) installation: change the "MSVCREDIST_LOC" parameter to "vcredist_x86.exe" - it will incorrectly sign to "vcredist_x64.exe" which is wrong!
2. Add the key "ORACLE" using regedit under "HKEY_LOCAL_MACHINE/Software/Wow6432Node"
3. Add a new parameter "inst_loc" with value "C:\Program Files (x86)\Oracle\Inventory"

There are some other pits with oracle_home and oracle_base here and you'll have to create the tnsnames.ora file by hand but after all I can now use the 32bit and 64bit versions with UniDac

[MaximG]

We are glad to see the problem resolved. Please don't hesitate to contact us with questions concerning UniDAC usage