Kbase P19271: How To Connect To a Progress V9.1D Database With Crystal Reports
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/09/2010 |
|
Status: Verified
GOAL:
How To Connect To a Progress 9.1D Database With Crystal Reports
GOAL:
Connecting Crystal Reports to Progress V9 database with SQL-92
FACT(s) (Environment):
Progress 9.1D
MERANT 3.60 32-BIT Progress SQL-92
DataDirect 4.1 32-Bit Progress SQL92 9.1D
Crystal Reports
Windows
FIX:
Requirement: The Progress server needs to be Version 9.1D or later. Service pack is optional.
Steps:
1. Install Progress 9.1D (?Complete? install is required)
2. Start Proenv (shortcut installed by progress in the Progress group)
3. Change directory to the directory containing the database
4. Start the DB server with the following parameter in your command or pf file
proserve dbname -S (service Name)
5. Start the SQL explorer (use the shortcut available in the Progress group)
6. Connect the database using the following settings:
Host: Localhost (or IP address from the machine hosting the db server for db)
Service or Port: (service Name - same as one used to start db "-S parameter")
Database: dbname
User: (Must be a valid user on the system)
Password: (Leave blank - Login validation is not enabled)
Once connected, the following statement should display the tables and the Progress system tables in alphabetical order:
select * from sysprogress.systables
Configure the ODBC Data Source using the same parameters as the Connection step above (the location of these settings varies from system to system, but should be in the Control Panel). Ensure that the ODBC isolation level is set to "read uncommitted".
Save the connection.
Test the connection with the ?Test Connect? button.
In Crystal Reports, change the data source for any existing reports, and they should be ready to use with the Progress RDBMS.
For new reports, start with blank, or create with Wizard, and in the ODBC section, select the ODBC DSN that you have just configured.