Database login dialog occurs when a crystal report generated in client machine

Question

1.00/5 (1 vote)

See more:

VS2010

, +

Hello everyone,
I posted already one question for the same issue(Question link). But yet to solution.
Am using MS access 2007, VS 2010 and VB.Net to develop application. Worked well in developing machine. Installing in client machine also works well. When my application started to generate report it popups the database login window. How to solve this?

Actually popup occurs for report which handles 2 tables to generate.
Reports with single table working properly.

Pop up asks for:
1.Server name : Shows My developing machine database location
2. Database name : Empty
3. User name : Admin
4. Password : Empty

And i tried

VB

Dim crtableLogoninfos As New TableLogOnInfos()
Dim crtableLogoninfo As New TableLogOnInfo()
Dim crConnectionInfo As New ConnectionInfo()
Dim CrTables As Tables
Dim CrTable As Table
'Dim crReportDocument As New CrystalDecisions.CrystalReports.Engine.ReportDocument
With crConnectionInfo
    .DatabaseName = Application.StartupPath & "\sdcartdb.mdb"
    .Password = ""
End With
CrTables = Report.Database.Tables
For Each CrTable In CrTables
    crtableLogoninfo = CrTable.LogOnInfo
    crtableLogoninfo.ConnectionInfo = crConnectionInfo
    CrTable.ApplyLogOnInfo(crtableLogoninfo)
Next

Still popup occuring.
I tried
view.SetDatabaseLogon(user, pwd)
No hope.
Can anyone help me out of this?

Posted 24-Mar-14 20:59pm

Vml_Newbie

Updated 8-Sep-16 2:08am

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Master Vinu · Answer 1 · 2014-03-27T23:31:00

Solution 1

set ODBC SETTING in client machine.
still popup exsisit install crystal runtime version in client machine.

hope it will resolve y r issue.

Posted 27-Mar-14 23:31pm

Master Vinu

Vml_Newbie · Answer 2 · 2014-03-27T23:36:00

Solution 2

I used the following code,

VB

Report.DataSourceConnections.Clear()
Report.DataSourceConnections.Item(0).SetConnection(Application.StartupPath & "\db.mdb", "db.mdb", 1)

And solved... Thanks..

Posted 27-Mar-14 23:36pm

Vml_Newbie

mostafa_edris · Answer 3 · 2016-09-08T02:08:00

Solution 3

C#

my solution was by installing SQL Server 2012 Client Tool Connectivity, and backward client connectivity components using SQL Server setup source.

Posted 8-Sep-16 2:08am

mostafa_edris