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

Can you use Crystal Reports with an OledbConnection to Access?

P: n/a
Based on the information I have now, the answer would seem to be No. Does
anyone have information to the contrary?

Here's the problem. On my first attempt to display a report, Crystal
displayed a login prompt even though the (Access) database was unsecured.
According to
http://www.experts-exchange.com/Data..._20544428.html,
this is due to a problem that Crystal has when using a connection based on
the OLEDB Jet provider.

Unfortunately, as explained in
http://www.dotnet247.com/247referenc...;EN-US;Q310374,
you can't use an OLEDB provider for ODBC (MSDASQL) as a workaround.

What's left? Well, there is the ODBC .Net managed provider, referenced in
the latter article. However, this apparently requires using an connection
object of type OdbcConnection rather than OledbConnection. This in turn
appears to prevent the use of the Crystal report expert (in addition to a
support module I had created to streamline data access, which uses an
OledbConnection.)

My other question would be, if the answer to my first question is No is
there any way to use the report expert?

Bob Rosen
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.