Kbase P69145: Quick configuration of an ODBC / JDBC connection to a Progress DB without concerns regarding user li
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/5/2008 |
|
Status: Verified
GOAL:
How to simplify the configuration of an ODBC / JDBC connection to a Progress DB
GOAL:
How to configure ODBC / JDBC access to Progress DB with minimal concerns regarding database access rights.
GOAL:
Configuration steps for ODBC / JDBC access to a Progress DB without having to add or maintain a database user list.
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
There is a generic user named 'user1' with password 'x' which has access to the Progress DB via ODBC / JDBC. In order to activate this account, you will need to assign the user proper access rights. There is also another special user name 'sysprogress' - this user has database administrator rights from SQL point of view. This user can be used to grant access rights to 'user1'. Lets begin configuring for ODBC / JDBC connectivity to a Progress Database.
1. Connect to database.
Windows platform:
Start -> Programs -> Progress -> Data Dictionary.
Enter information to connect to your database
UNIX platform:
pro or mpro dbname -p dict.p
2. Once connected need to access Security options:
Windows platform:
Tools -> Data Administration -> Admin -> Security -> Edit user list...
UNIX platform:
Admin ->Security -> Edit user list...
3. add the following user:
User ID: sysprogress
User name: sysprogress
Password: s
(User id MUST be sysprogress, name and password can be different.)
4. Now connect to the database via an ODBC compliant software or via
SQL Explorer.
Start -> Programs -> Progress -> SQL Explorer Tool -> File -> Connect
Enter connection information:
Host: localhost or machine where database is running (-H parameter)
Service: Service or port # that database was started with for (-S parameter)
Database: dbname (database name)
User: sysprogress
Password: s
5. After connecting to database copy/paste into upper window:
grant dba to 'user1';
grant resource to 'user1';
commit;
Finish with Ctrl-E to execute or press leftmost icon on a toolbar.
6. Disconnect from ODBC compliant software or SQL Explorer Tool.
7. Now to delete the sysprogress user so that you do not need to have
or maintain a user listing in Progress from the 4GL side, follow
steps 1 - 3 above, only instead of adding the sysprogress user, delete it.
Now you should be able connect to your database from the 4GL side without a user id. Via SQL, you can connect as user1 to create and grant user access as necessary. You should also be able to run the following code in any ODBC / JDBC client connection to this database and select data from your tables.
select * from pub.your_table_name;
Example against sports2000 database:
select * from pub.customer;