Progress
ODBC Driver Guide
Adding a New Data Source
To add an ODBC data source:
- Choose Settings
Control Panel from the Windows Start menu. The Control Panel displays.
- Double-click the ODBC icon in the Control Panel:
![]()
- The ODBC Administrator displays the ODBC Data Source Administrator dialog box:
![]()
- Click Add to display a list of installed drivers. The Create New Data Source dialog box appears:
![]()
- Highlight the MERANT 3.60 32-BIT Progress SQL-92 ODBC driver, then click Finish to display the ODBC Progress SQL-92 Driver Setup dialog box.
- Specify values for the following:
Data Source Name
Identifies this Progress data source configuration in the system information. Examples include “Accounting” or “9.1 newsports.”
Description
An optional long description of the data source name. For example, “My Accounting Database” or “Progress 9.1 local newsports.”
Host Name
The name of the system where the database or database broker is located.
Port Number
The system port number setup for the database listener process.
Database Name
The name of the database to which you want to connect by default.
User ID
The default logon ID (user name) used to connect to your Progress database. Your ODBC application may override this value or you may override it in the Logon dialog box or connection string:
![]()
- Click on the Advanced tab:
![]()
- Specify values for the following:
Default Isolation Level
Specifies the default isolation level for concurrent transactions. Choose from the following values: READ COMMITTED, READ UNCOMMITTED, REPEATABLE READ, and SERIALIZABLE. REPEATABLE READ is the default. See the Progress SQL-92 Guide and Reference for an explanation of the SET TRANSACTION ISOLATION LEVEL command.
Fetch Array Size
The number of rows the driver retrieves when fetching from the server. This is not the number of rows given to the user. The default is 50.
- Click Test Connect to attempt to connect to the data source using the connection properties specified in the Driver Setup dialog box.
- If the driver can connect, it releases the connection and displays a connection established message. Click OK:
![]()
- The ODBC Progress SQL92 Driver Setup dialog box appears. Click Apply:
![]()
- Click OK or Cancel to close the Driver Setup dialog box. If you click OK, the values you have specified become the defaults when you connect to the data source. You can change these defaults by using this procedure to reconfigure your data source. You can override these defaults by connecting to the data source using a connection string with alternative values. The data source appears in the ODBC Data Source Administrator:
![]()
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |