-
Crystal 9 security issue
I my continuing saga to upgrade my VB app from CR8.5 to CR9.0.
In the Project refernces area, I removed Report Viewer, Report Export, 8.5 ActiveX Design and Run Time, 8.5 Library, and 8.5 ActiveX Designer Run Time stuff and replaced them with their 9.0 equivalents.
When I run a report now, I get the following error:
An error occurred: [-2147189176] logon failed
Details: DAO error code 0xbd7
Source: DAO workspace
Description: Not a valid password Source: Crystal Reports Active X Designer
I changed no code from 8.5 to 9.0. This is the code:
Set Report = crxApplication.OpenReport("C:\JobsUnder1K.rpt", 1)
For Each crxDatabaseTable In Report.Database.Tables
crxDatabaseTable.SetLogOnInfo "", "", "", "password"
crxDatabaseTable.LOCATION = "C:\Techni.mdb"
Next crxDatabaseTable
Report.SelectPrinter glbPrinterDriver, glbPrinterName, glbPrinterPort
If glbPrinterDestination = 0 Then
glbReportForm = "frmProduction"
CRViewer.Show vbModal
Else
Report.PrintOut False
End If
Any ideas?
-
I tried changing the code to this:
For Each crxDatabaseTable In Report.Database.Tables
crxDatabaseTable.ConnectionProperties("Database Name") = "C:\Techni.mdb"
crxDatabaseTable.ConnectionProperties("Password") = "password"
Next crxDatabaseTable
Now, the error message is:
An error has occurred: [-2147417848] Method 'Value of object 'IConnectionProperty' failed - Source: Techni
(Techni is the system)