How to disable database login in crystal report

Question

0.00/5 (No votes)

See more:

I've deployed my vb application on a client's machine. But when he executes the crystal report section it requests for database login. I also remember I didn't use any userid or password for the database.

I used ms access as the database (OLEDB).

Please help me out.

What I have tried:

I've tried all what I could and have been searching online for the past 1week now.

But I don't get any solution to this problem

So please help me out

Posted 29-May-16 15:14pm

Richmond Boateng

Updated 29-May-16 15:28pm

Add a Solution

1 solution

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)

Garth J Lancaster · Answer 1 · 2016-05-29T15:28:00

Solution 1

Questions you need to ask yourself and answer

- Are you deploying the MS Access database to the client's machine or was that only for your testing ?
- Is the production data in another database - eg MYSQL, MS SQL Server etc

I would search your Crystal report setup and/or app.config (for example) and look for the Connection String that says how to connect to MS Access - then based on your answers to the 'questions', either

a) Deploy the MS Access database to the Client's machine OR
b) Change the Connection String to connect to the correct/production database - you may wish to create a 'Crystal' Account with read-only permissions and have those account details in the Connection String

Posted 29-May-16 15:28pm

Garth J Lancaster

Comments

Richmond Boateng 1-Jun-16 12:33pm

I don't get your solution please. Kindly explain it further.

Garth J Lancaster 1-Jun-16 21:15pm

since I'm not a Crystal expert, I suggest you Google something like "Crystal Report Connection String" and find out where & what that is in your project/code - once you find that you can then change it to whatever is required - since you havnt answered my question on what database/how are you deploying a database to the client machine, I cant tell you any more

Richmond Boateng 2-Jun-16 18:42pm

Please help me out because I've tried a whole lot of connection string. However, I've searched online for the past weeks now, I've tried all helps at various forums but they are all not giving me the solution to my problems ☹️

Garth J Lancaster 2-Jun-16 19:24pm

Ive tried to help you - but twice you havnt told me what database is being used on your client's computer / how its set up, as I have asked - since I cannot read your mind, see your computer, or the client computer, these are pretty mandatory details I dont have

Richmond Boateng 4-Jun-16 5:34am

The database is access and I definitely know that there is no password on the database file. But when I try to refresh the report on client's machine then it asks for a password.

I used advance installer to package the Visual Basic application