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
