Password Prompt

[WhiZa]

When trying to open a crystal report it always asks me for the password to access the database. Is there anyway to store this so that it won't get a prompt?

 

[AndrewBaines]

Crystal won't store the password - your DBA wouldn't be too happy!
If you're using MS SQL Server with NT security, you can use a trusted connection but you'll still need to click a check box everytime.
Andrew Baines
Chase International

http://www.chase-international.com

 

[dgillz]

As Andrew alluded to, the Database controls this, not crystal. If your database requires a password for access, crystal WILL ask for it.

If your database is not critical in nature you can modify it to have no password and not be bothered by this. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[WhiZa]

This database is important enough to have a password.
Right now I open the crystal report in C#. Is there a way to make C# send the password to crystal report instead of the user having to type it in?
btw, I am using SQL Server 2000.
Thanks for the replys

 

[AndrewBaines]

For each table
table.SetLogOnInfo "", "", usr, pwd Andrew Baines
Chase International

http://www.chase-international.com