Database / XML / Reporting Topics include: ADO.NET, SQL, XML structures and schemas, Crystal Reports, and other reporting tools

Go Back  Xtreme .NET Talk > .NET > Database / XML / Reporting > how to avoide Database login dialog?


Reply
 
Thread Tools Display Modes
  #1  
Old 01-08-2004, 08:48 AM
drzoka drzoka is offline
Newcomer
 
Join Date: Feb 2003
Posts: 4
drzoka is on a distinguished road
Question how to avoide Database login dialog?



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 :-))
Reply With Quote
  #2  
Old 01-16-2004, 01:32 PM
krsmurali krsmurali is offline
Newcomer
 
Join Date: Jan 2004
Posts: 5
krsmurali is on a distinguished road
Default

Assign database access to that User.
Or Create a user Group,add users,then give access for this group to ur Database.
Reply With Quote
  #3  
Old 02-06-2004, 01:27 AM
hungheykwun hungheykwun is offline
Newcomer
 
Join Date: Dec 2003
Posts: 14
hungheykwun is on a distinguished road
Default

rpt = New crystalDecisions.CrystalReports.Engine.ReportDocument
rpt.Load("..\Rpt\advance.rpt")
rpt.SetDatabaseLogon("admin", dbPwd)
Reply With Quote
  #4  
Old 02-10-2005, 04:41 AM
Ace Master Ace Master is offline
Centurion

Preferred language:
VB.NET
 
Join Date: Aug 2003
Posts: 140
Ace Master is on a distinguished road
Default

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.
Reply With Quote
  #5  
Old 02-11-2005, 06:51 AM
Ace Master Ace Master is offline
Centurion

Preferred language:
VB.NET
 
Join Date: Aug 2003
Posts: 140
Ace Master is on a distinguished road
Default

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

Reply With Quote
  #6  
Old 02-11-2005, 06:57 AM
PlausiblyDamp's Avatar
PlausiblyDamp PlausiblyDamp is offline
Ultimate Contributor

Preferred language:
C#, VB
 
Join Date: Sep 2002
Location: Lancashire, UK
Posts: 6,463
PlausiblyDamp is on a distinguished road
Default

What are you using for the database server? Does the user you specify have permissions to the database?
__________________
Posting Guidelines FAQ Post Formatting

Intellectuals solve problems; geniuses prevent them.
-- Albert Einstein
Reply With Quote
  #7  
Old 02-11-2005, 07:01 AM
Ace Master Ace Master is offline
Centurion

Preferred language:
VB.NET
 
Join Date: Aug 2003
Posts: 140
Ace Master is on a distinguished road
Default

Quote:
Originally Posted by PlausiblyDamp
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.
Reply With Quote
  #8  
Old 08-19-2009, 03:18 PM
Jay_DEEP Jay_DEEP is offline
Newcomer
 
Join Date: Aug 2009
Posts: 1
Jay_DEEP is on a distinguished road
Thumbs up 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 pondering 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 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....
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Yes No dialog instead of a Ok Cancel dialog. mike55 ASP.NET 1 10-17-2005 09:21 AM
not able to type any character to login, login only success if type int.. pls help kenjiz Database / XML / Reporting 2 04-14-2004 09:56 PM
Help!!! Crystal reports database login problem drzoka Database / XML / Reporting 2 01-12-2004 02:17 AM
Crystal reports database login problem drzoka Database / XML / Reporting 0 01-08-2004 08:51 AM
Database Login... gundavarapu Database / XML / Reporting 2 10-29-2003 09:31 AM

Advertisement:







Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe