Crystal Report "Logon Failed. Please Try Again."
-
Im trying to load a Crystal Report I've made in Visual Studio to a Crystal Report Viewer on my form. I used the "database expert" to add the connection (ODBC RDO) to my Access 2007 database. The database has no password on it. The Visual Studio field explorer detects all the fields correctly from my command ( SELECT * FROM Table1; ) so I know it can connect to the databse. The problem is when I run the program I get prompted for the Logon ID and Password and every time I get "Logon Failed. Please Try Again." Again there is no password on this DB. All of my code (this is a test project) Imports CrystalDecisions.CrystalReports.Engine Form Load: Dim crpt As New ReportDocument() Dim rPath As String = "C:\CrystalReport1.rpt" crpt.Load(rPath) CrystalReportViewer1.ReportSource = crpt
-
Im trying to load a Crystal Report I've made in Visual Studio to a Crystal Report Viewer on my form. I used the "database expert" to add the connection (ODBC RDO) to my Access 2007 database. The database has no password on it. The Visual Studio field explorer detects all the fields correctly from my command ( SELECT * FROM Table1; ) so I know it can connect to the databse. The problem is when I run the program I get prompted for the Logon ID and Password and every time I get "Logon Failed. Please Try Again." Again there is no password on this DB. All of my code (this is a test project) Imports CrystalDecisions.CrystalReports.Engine Form Load: Dim crpt As New ReportDocument() Dim rPath As String = "C:\CrystalReport1.rpt" crpt.Load(rPath) CrystalReportViewer1.ReportSource = crpt
Are you supplying it with the right log in credentials? Or have you not been required to do so?
"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak
-
Are you supplying it with the right log in credentials? Or have you not been required to do so?
"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak
I thought that was handled by the ODBC RDO. As I said it can connect to the DB when Im in the Crystal Report Design window but when I run the program it prompts for a Logon ID and Pass but there is no need for this info to make a connection. I read that setting "Persist Security Info" on the connection is supose to fix this but I'm unsure how to apply this setting.