The TNS Service Name can be selected from a pull-down list of available TNS names.
For more information, see the NETCA documentation and About Using the Oracle ODBC Driver for the First Time. This is the same name entered in Configuring Oracle Net Services using the Oracle Net Configuration Assistant (NETCA). TNS Service Name - The location of the Oracle database from which the ODBC driver will retrieve data. For example, "Hire date, salary history, and current review of all employees." The Description field is optional. You must enter a DSN.ĭescription - A description or comment about the data in the data source.
The following subtopics explain how to add, change, or delete a data source.ĭata Source Name (DSN) - The name used to identify the data source to ODBC. You can change or delete a data source at any time. You can provide the other information requested in the dialog box, or you can leave the fields blank and provide the information when you run the application.Īfter you have entered the data, click OK or click Return. You must enter the DSN and TNS Service Name. The Oracle ODBC Driver Configuration Dialog Box is displayed.
A list of installed drivers is displayed.Ĭlick Add in the Create New Data Source window and then select the Oracle ODBC Driver in the list of installed drivers.Ĭlick Finish. Follow these steps:įrom the start menu, select Programs, Administrative Tools, Data Sources (ODBC). The Oracle ODBC Driver uses the information you enter when you add the data source to access the data. Oracle ODBC Driver Instant Client uninstall scriptĪfter you have installed the Oracle ODBC Driver, use the ODBC Data Source Administrator to configure or add an Oracle data source for each of your Oracle databases.
Oracle ODBC Driver Instant Client install script Oracle ODBC Driver help file for Japanese Oracle ODBC Driver Instant Client Release Notes Oracle Database ODBC Driver Release Notes Oracle ODBC Driver message file for Japanese nn.n (where nn.n reflects a version number for example, libsqora.so.20.1) Table 25-1 Files Installed by the Oracle ODBC Driver Kit Description This figure shows an ODBC application accessing three separate databases.
The ODBC Driver accesses the database over a network communications link using the database API. Still using the ODBC API, the Driver Manager makes a call to the ODBC Driver. The Driver Manager can be either the Microsoft Driver Manager or the unixODBC Driver Manager.
The model begins with an ODBC application making a call to the Driver Manager through the ODBC application program interface (API). The following figure shows the components of the ODBC model. SQL syntax based on the SQL-99 specification.Ī standard way to connect to and log in to a data source.Ī standard representation for data types. The ODBC interface defines the following:Ī library of ODBC function calls that allows an application to connect to a data source, execute structured query language (SQL) statements, and retrieve results. Therefore, the application can access any data source for which a database driver exists. A database driver is a dynamic-link library that an application can invoke on demand to gain access to a particular data source. A database driver links the application to a specific data source. The application's source code does not have to be recompiled for each data source. Open Database Connectivity (ODBC) provides a standard interface that allows one application to access many different data sources.