What are the different methods to provide Oracle database connection parameters in odbc.ini file?
Article ID: KB0092012
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | - |
| Not Applicable | - |
Description
Resolution:
Following is the summary of the two methods that you can be used to connect to the database using the entry in odbc.ini file.
Method1: Provide HostName, PortNumber and SID / ServiceName parameters and do not provide ServerName and TNSNamesFile parameters.
Method2: Comment HostName, PortNumber and SID / ServiceName parameters and provide TNSNamesFile and ServerName parameters.
--> TNSNamesFile should point to the complete location of tnsnames.ora file and the user running the adapter should have atleast read access to this file.
--> ServerName parameter should point to the service entry name in the tnsnames.ora file not the SID or ServiceName of the database
For more information please refer to DataDirect help under <TIBCO_ADB_HOME>/odbc/help folder.
Following is the summary of the two methods that you can be used to connect to the database using the entry in odbc.ini file.
Method1: Provide HostName, PortNumber and SID / ServiceName parameters and do not provide ServerName and TNSNamesFile parameters.
Method2: Comment HostName, PortNumber and SID / ServiceName parameters and provide TNSNamesFile and ServerName parameters.
--> TNSNamesFile should point to the complete location of tnsnames.ora file and the user running the adapter should have atleast read access to this file.
--> ServerName parameter should point to the service entry name in the tnsnames.ora file not the SID or ServiceName of the database
For more information please refer to DataDirect help under <TIBCO_ADB_HOME>/odbc/help folder.
Issue/Introduction
What are the different methods to provide Oracle database connection parameters in odbc.ini file?
Feedback
Yes
No
Powered by
