Kbase 18610: How to Connect an ODBC Client to Version 9.x and above Progress database.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/10/2005 |
|
Status: Verified
GOAL:
How to Connect an ODBC client to Version 9 and above progress database.
GOAL:
How to configure an ODBC client to connect to SQL-92
GOAL:
How to configure an ODBC client for SQL-92
FACT(s) (Environment):
Progress 9.x
FIX:
1. Define a User in the database, user name sysprogress
1a) On a Windows based environments, use the Data Administration Tool
1b) On character based environments, use the Data Dictionary Tool
2) Choose the Admin menu
3) Select the Security Option
4) Select Edit User List
5) Select Add
6) User ID should be sysprogress
User Name can be left blank if you choose
Password should be something that you will remember
7) Save all your changes
2. Start the Database Server:
1) Open a proenv session.
2) Start a database server with the appropriate startup parameters
you use. (You will need -N -H and -S as minimum parameters.)
3. Define the Datasource:
1) Define a datasource through the ODBC Administrator in the
Windows Control Panel.
NOTE: For use of MicroSoft Query when launched from Excel
you will need to define a File Datasource as well as a User
Datasourse
User Datasources are useful if only one user on a machine will
be working with that Datasource. It is only accessible from
that user's login.
System Datasources are accessible by any user on that system.
File Datasources are files that can be moved from system to
system. They usually have a file extension of .dsn.
2) Pick the appropriate tab (User, File or System) in the Datasource
setup window.
3) Click on the Add button.
4) Select Merant 3.60 32-Bit Progress SQL-92 V9.1x (x can be B,C or D)
NOTE: If you chose to create a file datasource then you will be given
a dialog box on where to create and what to name the file.
5) The next dialog window will allow you to fill in the relevant information for the datasource.
Data Source Name: Your identifier of the Datasource. It is usually helpful to have it be either somewhat descriptive or easily memorable.
Description: A brief description of what this datasource is for.
Host: The host machine name of where the database server was launched
for the database in question. This is the same name that was
supplied for the -H parameter when starting the database.
Normally the host name should be defined in the hosts file
or by a the DNS server to resolve host names to IP addresses.
Port: The service port that the database server was launched with.
This is the same value that was supplied for -S.
Database: The physical name of the database. (You do not need to
to supply the full path to the database, nor do you need
to type the .db extension.
User ID: sysprogress
Password: Use the password you defined earlier when creating
the sysprogress user in the database.
Now that the Database is running and the Datasource has been defined you should be able to make your connection to the Progress database with your non-Progress ODBC client.