Configuring a Data Source

File DSN: To configure a new file data source, click Add to display a list of installed drivers. Select the driver and click Advanced to specify attributes; otherwise, click Next to proceed. Specify a name for the data source and click Next. Verify the data source information; then, click Finish to display the driver Setup dialog box.

The data source Setup dialog box appears. If you are configuring an existing data source, the dialog is prepopulated with a list of the connection option attribute-value pairs currently stored in the odbc.ini file. For new data sources, the dialog will be empty.

2. On the Setup dialog, provide keyword-value pairs for the connection options in the following table; then, click OK. To add missing pairs, click the Add button

. Then, in the new row, type the attribute name in the Keyword field and the desired valid value in the Value field.

Table 1. Required Connection Options
Keyword	Value
EditionName	Oracle 11g R2 and higher only. The name of the Oracle edition the driver uses when establishing a connection. Oracle 11g R2 and higher allows your database administrator to create multiple editions of schema objects so that your application can still use those objects while the database is being upgraded. This option is only valid for Oracle 11g R2 and higher databases and tells the driver which edition of the schema objects to use.
HostName	The name or the IP address of the server to which you want to connect.
PortNumber	The port number of your Oracle listener. Check with your database administrator for the number.
ServiceName	The Oracle service name that specifies the database used for the connection. The service name is a string that is the global database name—a name that is comprised of the database name and domain name, for example: sales.us.acme.com.
SID	The Oracle System Identifier that refers to the instance of Oracle running on the server. The default is ORCL.