How to configure PSD to connect to remote database with no Oracle locally...

[WexSoft]

Hi Folks

I have installed Beta 9 on a new Windows 7 PC that does not have Oracle installed. Is it possible to configure PSD to be able to connect to remote DBs without having Oracle installed locally? I have a TNSNAMES.ORA file with all the details, but how do I get PSD to pick it up?

Any help greatly appreciated.

 

[Marco Kalter]

You will need an Oracle Client. This can be an Oracle Instant Client, which only requires that you unzip a client package into a directory on the PC, or a full Oracle Client that needs to be installed.

 

[WexSoft]

Thanks for the details Marco. I have downloaded the Oracle Instant Client v18.3, installed the Visual Studio 2013 redistributable and restarted the PC (per the instructions). However, I'm still getting the "Initialization error - Could not locate OCI dll" message. Is there something else I need to configure in PSD?

 

[WexSoft]

Never mind Marco - I had added the directory containing the instant client to the Path user environment variable instead of the Path system environment variable.
All working fine now - thanks for your help.