Login problem while Accesssing password protected Access DataBase with Crystal Reports

[innocentpal]

Facing some problem to access dynamically crystal reports in c# with
password protected Access(MDB) database.

I have created a Form on that I placed crystalReportViewer1.If we put
password in Databse then it asks the passoword while opening the
report.



How we can create crystal report dynamically with queries. dataset,
datatable.

I has set the created dataset with reportsource property of a report.
but it does not shows the records which is in Dataset.

Please Any body help me. it is very urgent.

 

[Brendan Reynolds]

For help with C# and Crystal Reports, you might need to ask in a C# or .NET
Windows Forms newsgroup. But if the problem is how to specify the database
password in the connection string, this example that I posted recently in
response to another question might help ...

Const strcConnection As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"User ID=Admin;Password=Whatever;Data
Source=c:\usenet\passtest.mdb;" & _
"Persist Security Info=False;Jet OLEDBatabase Password=Whatever"

Provider=Microsoft.Jet.OLEDB.4.0; - You probably know this one, specifies
which provider to use.

User ID=Admin; - Not necessary if you're not using user-level security, as
'Admin' is the default. If you were using user-level security instead of or
in addition to the database password, you'd specify the user name and the
user password (not the database password) like so ... User
ID=SomeUser;Password=SomePassword;

Data Source=c:\usenet\passtest.mdb; - I'm sure you know this one, the path
and name of the data file.

Jet OLEDBatabase Password=Whatever; - The database password (not the user
password, see above). The 'Jet OLEDB:' prefix identifies this as a
JET-specific extended property rather than a standard OLEDB property.

Persist Security Info=False; - I won't try to explain that one myself.
Here's a link to an MSDN article that explains it instead ...
http://msdn2.microsoft.com/en-us/library/ms254499.aspx

A good source of information about connection strings is Carl Prothman's
site, which you can find at the following URL ...

http://www.carlprothman.net/Default.aspx?tabid=81