Crystal Reports in VB.Net

trims30
trims30 used Ask the Experts™
on
Am struggling to learn Crystal Reports and have two stumbling blocks at the moment that I need some help resolving.

Computer is Win7 64 with VS2008
Database is MsAccess

Have added CrystalReportiewer to my form, used the Wizard to connect to database and select my tables.  Have been able to design a simple report and view it in Main Report Preview mode.

When I attempt to run the report I get error :
"Failed to load Database information Details: The database DLL ‘crdb_doa.dll’ could not be loaded. "

Have tried setting my project to build for X86 processor with no improvement.
How do I get this issue resolved?

Next issue is - how do I set page layout so I can design in Portrait?  I can't find that setting

help is appreciated.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
In the full versions  Portrait - FILE --> PAGE SETUP

What version of Crystal?
What framework of .Net?
What version of MS Access?

mlmcc

Author

Commented:
Am using Crystal that's included with VS2008 (CrystalReportViewer toolbox item)
Access is  2007
.Net Framework 3.5

Finally Found the page setup and was able to make that change
Most Valuable Expert 2012
Top Expert 2014
Commented:
When you connected the report to data source, what driver did you choose?

http://blogs.cametoofar.com/post/The-database-DLL-e28098crdb_daodlle28099-could-not-be-loaded.aspx
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

Author

Commented:
Access/Excel DAO is how I'm connecting to my MDB file
Most Valuable Expert 2012
Top Expert 2014

Commented:
What other drivers do you see in the list?
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Do you have the latest service pack for VS2008 Crystal?
I believe you need it to be 64-bit compatible.

mlmcc

Author

Commented:
Evidently Access/Excel DAO not compatible with Win7 64.
Tried making VB.Net run as 32 bit x86 but still same problem

CodeCruiser - I saw that blog before I posted question - same problem I'm experiencing.

looked further at Build properties and was able to change to x86 and it works now.

Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial