If you have to connect to an Oracle database, you will need to know how to configure the Oracle Client in order to connect to the Oracle databases.
The process consists of 2 parts:
First up, I will demonstrate how to configure the Oracle Listener:
Once you have the Oracle Listener up and running, you then have to configure your Local Net Service Name (for your tnsnames.ora file):
While configure the Local Net Service Name and testing the connection, you may have to change the login credentials by using the "Change Login" dialog.
Once you have done that, you still need to configure the Data Sources in the ODBC Data Sources section (odbcad32):
When configuring your ODBC Data Source, you will need to use the TNS Service Name (Local Net Service Name) that you configured earlier.
Finally, you can use an Oracle connection string such as one of the following to connect to your Oracle database instance! (The name of your Data Source is the name of your ODBC DSN): http://www.connectionstrings.com/oracle/
The process consists of 2 parts:
- Configuring an Oracle Listener
- Configuring 1 or more Net Service Names
First up, I will demonstrate how to configure the Oracle Listener:
Once you have the Oracle Listener up and running, you then have to configure your Local Net Service Name (for your tnsnames.ora file):
While configure the Local Net Service Name and testing the connection, you may have to change the login credentials by using the "Change Login" dialog.
Once you have done that, you still need to configure the Data Sources in the ODBC Data Sources section (odbcad32):
Finally, you can use an Oracle connection string such as one of the following to connect to your Oracle database instance! (The name of your Data Source is the name of your ODBC DSN): http://www.connectionstrings.com/oracle/
Awesome directions, helped me a lot.
ReplyDelete