Kbase P60991: Error "Insufficient information to connect to the data sourc
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/6/2004 |
|
Status: Verified
FACT(s) (Environment):
Progress 8.3E
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
Crystal Reports 9
FACT(s) (Environment):
MERANT 3.60 32-BIT Progress SQL-92
SYMPTOM(s):
Error "Insufficient information to connect to the data source" when attempting to view a Crystal report in ASP
Logon failed. Details: HY000:[MERANT][ODBC PROGRESS driver]Insufficient information to connect to the data source.
Crystal Reports 9 Runtime Engine
Using the Crystal Report Designer Component version 9 to view reports created against a Progress database
Current ODBC DSN has the same name and user ID as the DSN used to create the report
CAUSE:
A password for the ODBC connection has not been supplied and is not saved in the report.
FIX:
It is possible to set the password for the ODBC connection in the ASP code, using ConnectionProperties, with the following code:
<ReportObjectName>.Database.Tables(1).ConnectionProperties("Password") = "<password>"
The next example is based on the ASP sample code supplied by Crystal Decisions (from BeginHere.zip found in the aspxmps9.exe collection).
Open MoreRequiredOptions.asp and add the following code:
On Error Resume Next
Dim x
For x = 1 to Session("oRpt").Database.Tables.Count Step 1
Session("oRpt").Database.Tables(x).ConnectionProperties("Password") = "pub"
Next
session("oRpt").ReadRecords
Note: Text in bold is new and italised text represents code already present in MoreRequiredOptions.asp