Database Login window...
-
I am working with VB.Net 2005 looking at an Access 2003 database. When I run my Crystal Report (version 10.0.5.1279) I get a Database Login screen even though I don’t have passwords set at all in this datatbase. Can anyone tell me of a way to stop this from coming up? Thanks in advance for all of you help.
-
I am working with VB.Net 2005 looking at an Access 2003 database. When I run my Crystal Report (version 10.0.5.1279) I get a Database Login screen even though I don’t have passwords set at all in this datatbase. Can anyone tell me of a way to stop this from coming up? Thanks in advance for all of you help.
I've had a similar issue and was only able to get around it with a rather complicated work around. It has to do with the database you designed the report with no longer being located in the same file structure as it was during design time...which is NEVER once you've deployed it and the report is being run on your client's machine. I got past the issue by including an access database that contained the same table and field structures as I used during design of my crystal report. Then, before I set the report documents datasource or the crystal viewer's ReportSource property, I do the following:
'My schema database has been downloaded to the CurrentUserApplicationData folder via ClickOnce publish settings
Dim strSchemaPath As String = My.Computer.FileSystem.SpecialDirectories.CurrentUserApplicationData & System.IO.Path.DirectorySeparatorChar & "SchemaDB.mdb"
'This will set the login info to the schema DB, even though it has no passwords set, so the login screen will not display
cdReportDocument.DataSourceConnections.Item(0).SetConnection(strSchemaPath, "", False)This workaround seems very silly, and requires the user to download a good sized file when they really shouldn't have to. But I've posted this question in several forums and no one has been able to help me with a better fix. If you find anything better please let me know.