How do we setup "Configurable ODBC" with Oracle DB?

[#1]

This would help if anyone provide step by step guide for setting "configurable ODBC" for DSP services using oracle as db source.

Regards,

Supratim Ray

[#2]

Hi Supratim,

   Choose Oracle Client as a driver  when you creating a DSN.

Step1 :  Goto Script Editor and click Tools Menu under that choose ODBC Administrator 64-bit/32-bit.

Step2 : Go to System DSN click on Add button.

Step3 : Chosse the Oracle Client Driver from list

Step4 : Give DSN Name and Server Name, user credentials click on Test Connection and click ok

Step5 : Come to Script editor click on connection choose the DSN and provide the user credentials and click on Test connection. Automatically it establish the connection string after that click on select to read the Tables.

Santhosh

[#3]

We did that. After that what to put where in DSP setup at Server side.