Kbase P16790: How to Eliminate Password Prompting When Using An ODBC Conne
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/11/2003 |
|
Status: Unverified
GOAL:
How to Eliminate Password Prompting When Using An ODBC Connection And The Report Builder Engine.
FACT(s) (Environment):
Windows
FACT(s) (Environment):
ODBC Drivers
FACT(s) (Environment):
Progress 9.x
FACT(s) (Environment):
Progress 8.x
FIX:
This can only be done via the Report Builder Table Interface.
For example if the report is generated against the following database connections;
DB Name Type Connect String
------------------------------------------------------------------------------
SportsSQL Progress -db sportssql -H alex01 -S 5200 -N TCP -U alex -P dbpw
SQL Sports Access -db sqlsports -ld sqlsports -dt ODBC -U alex -P dbpw
The following is an example of how to impliment this process;
CREATE RBREPORT.
ASSIGN
RBREPORT.RB-REPORT-LIBRARY = "rbsample.prl"
RBREPORT.RB-REPORT-NAME = "Customer"
RBREPORT.RB-PRINT-DESTINATION = "D"
RBREPORT.RB-DISPLAY-STATUS = yes
RBREPORT.RB-DISPLAY-ERRORS = yes.
RBREPORT.RB-DB-Connection = "SportsSQL = -db sportssql -H alex01 -S 5200 -N TCP -U alex -P dbpw~nSQLSports = -db sqlsports -ld sqlsports -dt ODBC -U alex -P dbpw".
RELEASE RBREPORT.
This will overide the inital DB connections and preform the same connections but, will include the Password. Report Builder saves the fact that you require a password for a Database connection however, it will not save the password in the report.