Click Add…
Select Oracle related driver, in my case ‘Oracle in XE’ Then click ‘Finish’, then it opens Oracle ODBC Driver Configuration as follows..
Data Source Name: Some custom name that we want to define.
Description: Just description of custom name.
TNS Service Name: TNS Service Name that we fine in the following path( in my case it is for Oracle 11g Express edition) : C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN\tnsnames.ora
User ID: User ID that is created to access the Oracle database (Ex: INUSER01 that I created to access Oracle database)
No comments:
Post a Comment