how to avoide Database login dialog?

[drzoka]

I'm using Crystal reports as a part of Microsoft Visual studio .net 2002. I'm using field definition file (ttx) and a datatable as a datasource for report. (In VB .net code, Datatable is filled with data and then is set to be datasource for the report). Program works fine on the development PC. But when I try to show report on some other PC, 'Database login' dialog appears. How can I avoide this dialog?

 

Any help would be appreciated :-))

[krsmurali]

Assign database access to that User.

Or Create a user Group,add users,then give access for this group to ur Database.

[hungheykwun]

rpt = New crystalDecisions.CrystalReports.Engine.ReportDocument

rpt.Load("..\Rpt\advance.rpt")

rpt.SetDatabaseLogon("admin", dbPwd)

[Ace Master]

I have the same problem and I did this:

 

Dim rpt As New CrystalDecisions.CrystalReports.Engine.ReportDocument

rpt.Load("CrystalReport1.rpt")

rpt.SetDatabaseLogon("user", "pass", "server", "db")

 

is not working :( . On the dev pc is working, but when I deploy the kit to other pc , the login apears.

[Ace Master]

so....there is no hope to get out that stupid login window?

 

:(

[PlausiblyDamp]

What are you using for the database server? Does the user you specify have permissions to the database?

[Ace Master]

What are you using for the database server? Does the user you specify have permissions to the database?

 

thanks for the quick reply

 

Database is Mysql server ODBC installed.

 

I made the permissions for database, but maybe I missed something. Please tell me all the places where I can set permisions for that DB.

 

thanks a lot.

[Jay_DEEP]

FIX FOR - Crystal Report displays database login page for VS2003 .Net Crystal Report

 

I finally was able to resolve this problem. I spent more than two weeks:mad: pondering:confused: on this problem. I had all my crystal Reports developed on a VS 2003 .Net platform. The Crystal Reports are based on ADO.Net datasets (XML). They were working fine at all the 17 clients but when we recently deployed it to a new client in a virtual environment, we got the above error where the Crystal report was asking for database credentials.

Our App already sets the LogOnInfo for each table, subreport, section. Finally after weeks of research through various blogs, Crystal (SAP/Business Objects) support websites.... I found that the problem lies within the current version of your crdbadoplus.dll. It doesn't matter where this dll is there on your machine, but in my case this dll was causing the logon window to come up everytime, the crystal report was launched from the application. To fix the problem. Copy crdbadoplus.dll (Version: 9.2.0.29) into the application root folder where it was deployed to eg: C:\Program Files\Your Client Application\ and :cool: the database logon window stopped popping.....So if all fails please try to get this dll..and try it....Good luck guys...(May be this will help lots of ppl who are spending hours and hours on the net trying to find a resolution to this problem.). Please let me know if this worked for you guys....