By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,527 Members | 2,155 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,527 IT Pros & Developers. It's quick & easy.

Crystal Reports, select access database at runtime

P: n/a
Hi,

I'm trying to use Crystal Reports to generate reports from an Access
database.
I'm using VS2003 and C#. I need to select the database the report uses
as data source at runtime. The database does not have any password
protection.

I've tried using ODBC connections, but all I get is logon errors. It
seems that I should be able to pass a connection string in
table.LogOnInfo.ConnectionInfo.ServerName, but trying that results in
an "incorrect log on parameters" -error.

I could use DAO connections, and I found some documentation that
mentioned changing the report.Database.Tables[n].Location -property,
but all I get is a "The Report Application Server failed" -error.

I'm getting desperate. If anyone has example code that works, or any
suggestions, I would be very grateful.

- Mikko Pulkkinen
Jul 21 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.