Sunday, December 2, 2018

Create DSN for an Oracle Database - TIBCO ADB Adapter

       TIBCO ADB Adapter is developed on C/C++, hence it needs System DSN/ODBC during run time. We can configure the System DSN for Oracle Database in following way :

STEP-1 : Open the windows control panel ( Start --> Control Panel) and navigate to "Administrative Tools" and then click on "Set up ODBC data sources (32-bit)" or "Set up ODBC data sources (64-bit)" based on the requirement.


From your local, navigate to and click on below executable file to open the ODBC Data Source Administrator.

C:\Windows\System32\odbcad32.exe   -- For 64-bit
C:\Windows\SysWOW64\odbcad32.exe   -- For 32-bit

STEP-2 : In ODBC Data Source Administrator, navigate to "System DSN" and click on "Add" button.

STEP-3 : Then select data source driver as "TIBCO 7.00 Oracle Wire Protocol" and in general tab, provide "Data Source Name" and required DB connection details like Host, Port and SID etc and then click on Test Connection button.

STEP-4 : in Next window, provide the database username and password details, to check/test the database connectivity. Once connection is successful click on OK button.

STEP-5 : Click on Apply button, Finally you can see the System DSN is created with data source name "OracleDSN".

No comments:

Post a Comment

back to top