- #Tns service name oracle odbc driver configuration how to#
- #Tns service name oracle odbc driver configuration install#
The configuration looks like the following screenshot.Ĭlick OK to save the DSN configuration and close the dialog box. In this demo, we are using HR users, so specify it in the UserID textbox Specify the User ID that you want to use to connect to the oracle database. In our case, the TNS Service name will be ELTECH, so specify it in the TNS Service name drop-down box Alternatively, you can find it by executing the following query: We can get the TNS Service name from the Oracle Net Configuration Assistant. Specify the location of the oracle database from which the ODBC will populate the data. Specify the appropriate description of the data source The DSN will be used to identify the data source uniquely You can specify the following options in the dialog box. Select Oracle in OraDB19Home1 from the list of data sources listed in Create New DataĪ dialog box named Oracle ODBC Driver Configuration opens.
🡪 Click on the Add button on the ODBC Data Source Administrator dialog box. Open Control Panel 🡪 Administrative tools 🡪 ODBC Data Source Administrator (64-bit) 🡪 Select System DSN The ODBC Data Source administrator MMC (Microsoft management console) is in the Administrative tools directory of the control panel. We can create a DSN by using the ODBC Data Source Administrator. We will create a DSN to access the oracle database using ODBC Driver. The DSN is used in any application that uses the ODBC driver to connect to the database. To view the data populated from the oracle database, I have installed the PowerBI for Desktop on my workstation.
Once the schema is enabled, I have changed the password of the HR user. The HR schema is associated with the HR user, so we will enable the HR user by running the following query. I have enabled the HR schema of the ELTECH database. It is a sample database, and it contains the oracle sample schemas.
#Tns service name oracle odbc driver configuration install#
When we install the oracle database on the workstation and the oracle database, the setup installs the client connectivity tools and drivers. I have installed oracle 19c on my workstation.
#Tns service name oracle odbc driver configuration how to#
How to configure the ODBC driver using ODBC Data Source AdministratorĬreate a sample PowerBI report to populate and view the data from the oracle database This article explains the process to configure the ODBC driver for oracle 19c.
0 kommentar(er)
