Urgent!! - Error 20534 when running Crystal Report

[dougconran]

I get an error 'Run-time error 20534 error detected by database DLL' when I try and run a Crystal Report as part of a deployed application on a new PC with windows XP home.

This works fine on the development PC running windows XP professional.

I am using VB6 and Crystal Reports 4.6

I've searched the net but all I can find is something to the effect that this is a known problem - but no solutions.

I've tried repairing and compacting the db and also using On Error Resume next to bypass the error but all to no avail.

Does anyone know of a work-around or have I just wasted weeks of my time and money on something with a known problem that no one has bothered to fix (or advertise).

If there is no solution is there any alternative to installing the VB development system on each PC.

Doug Conran

 

[jebenson]

I typed the following into Google:

crystal reports 4.6 Run-time error 20534 error detected by database DLL

and among others I got the following hits that may help you out:

[URL unfurl="true"]http://support.businessobjects.com/communityCS/TechnicalPapers/cr_dev_dbissues.pdf[/url]


[URL unfurl="true"]http://www.experts-exchange.com/Miscellaneous/Q_20610835.html[/url]

[URL unfurl="true"]http://support.businessobjects.com/communityCS/TechnicalPapers/cr_error_detected_by_db_dll.pdf[/url]

I think the first link may be of most help to you. Unfortumately, none of these seem to indocate that there is an easy fix, as there apparently several possible causes for this error. You'll have to do some testing to determine what is causingthe error.

Perhaps if I knew more (e.g., what DB are you using, how are you connecting, etc.) I could give a more precise resopnse.

Hope this helps.

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

 

[jebenson]

I typed the following into Google:

crystal reports 4.6 Run-time error 20534 error detected by database DLL

and among others I got the following jits that may help you out:

[URL unfurl="true"]http://support.businessobjects.com/communityCS/TechnicalPapers/cr_dev_dbissues.pdf[/url]


[URL unfurl="true"]http://www.experts-exchange.com/Miscellaneous/Q_20610835.html[/url]

[URL unfurl="true"]http://support.businessobjects.com/communityCS/TechnicalPapers/cr_error_detected_by_db_dll.pdf[/url]

I think the first link may be of most help to you. Unfortumately, none of these seem to indocate that there is an easy fix, as there apparently several possible causes for this error. You'll have to do some testing to determine what is causingthe error.

Perhaps if I knew more (e.g., what DB are you using, how are you connecting, etc.) I could give a more precise resopnse.

Hope this helps.

I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson

 

[vidru]

There are a couple of KB articles on the BizObj site that might help you out:

http://support.businessobjects.com/library/kbase/articles/c2006736.asp

http://support.businessobjects.com/library/kbase/articles/c2006737.asp

Crystal Reports 4.6 (that's the one that was bundled with Visual Studio, right?) is quite old, and I doubt they were supporting it anymore by the time XP was released.

-dave

 

[dougconran]

Thanks for your tips and I'll check them out. In the meantime, I'm using Access 97 (mdb) as the db and connecting using the standard features provided by Crystal Reports.

On checking this out I see that I am specifying a directory that is different from that on the target PC and I guess that might be where the problem is. The only thing is that, to date, I don't seem able to get this to change (even when I change it to a non-existent directory the report still runs on the development PC).

I shall continue to investigate but thatnks for the pointers.

Rgds

Doug

 

[dougconran]

Thanks for your help everyone.

After some 5 hours of moving programs between PCs I can only conclude that the only answer that seems to work is to install Access 97 runtime. Fortunately I have the Developer edition so this is possible. It does beg the question as to why bother using VB and Crystal Reports if Crystal Reports is not going to work.

It would be nice if there was something on the net saying, someting to the effect, DON'T EXPECT TO BE ABLE TO USE CRYSTAL REPORTS WITH VB6 UNLESS YOU ALSO INSTALL ACCESS RUNTIME. YOU WILL JUST GET ERROR 20534 AND A LOT OF GRIEF.

 

[Golom]

The other option is to upgrade your Crystal release. You are at 4.6 and I think that the current release is 10 (or more). You are a long way back in terms of CR.

I use CR and Access routinely without Access Runtime but with CR 9.

 

[dougconran]

That would be a nice solution if I had any money. Even the Access runtime 'solution' does not seem to be working now.

After getting on for 7 hours of pfaffing around I have hit a brick wall. The only solution seems to be to load the VB development onto each PC

Doug