Error 534 trying to run report

I have written a report in the Crystal IDE that runs fine. It is using OLE DB to a SQL Server database. When I then try to run that report at runtime, outside of Crystal, I get an error 534 returned. I am using the CPRE32 API and I am using version 8.5.Try looking up the error number or error description on www.google.com or on Crystal's Website: http://support.businessobjects.com/search/advsearch.asp|||I have done both of those. There is quite a bit of good information out there. But none of it so far has helped me. I recently tried switching from using P2SOLEDB.DLL to P2SSQL.DLL just to see what would happen, but I still get 534...|||Have you verified database?I usually get error 534 when database verification is needed.|||I will post this info here in hopes that it will help others who search for this problem.

The solution to my 534 problem was to use the PESetNthTableLocation API call. I had to call Crystal support to get this information.

The problem was caused by my changing database names at runtime.

I wrote all my reports to report on database "A", so to Crystal, the database "location" was "A.dbo.tablename". Then, at runtime, if the user of my application was running the reports on database "B", I was calling PESetNthTableLogOnInfo and setting the database to "B". However, according to Crystal support, sometimes that is not enough. Sometimes you also have to change the database location. So, once I called PESetNthTableLocation (setting it to "B.dbo.tablename") in addition to PESetNthTableLogOnInfo, it worked fine...

Error 500, Not Enough memory (Really Emergency)

hi everybody,

I am using delphi 7 and Crystal Reports 9. I am exporting some Crystal reports which connect to the Oracle DB, but for some reports i am getting this error (Error 500). In crystal report, this reports are running as well... but in delphi i couldn't do it. do you have an idea ?

PS: i searched for this error and found somethings but they dont help me...

thanks.isnt there anyone? thats really emergency for me :(|||Try to run in other pc with more memory to discard that is not really "Not Enough memory"|||There is enough memory... be sure :) i run this program on a server (3 GB memomry)|||Ok, i guess nobody knows this, is there anyone who knows how i could find some info about this?|||it is me again,

I found the reason of this problem :) the reason is OLE Objects. in this reports, one who create this report, used OLE Object (Microsoft Word)..

i deleted the ole object and Application runned very well :)

Error 500 and Error 692 trying to export

I am trying to export a report to PDF and HTML. I am currently using Crystal Reports 8.5, and I'm using the CRPE32 API. On my development machine, this works great. I get PDF files that I can view with Acrobat, and HTML files that come up fine in IE.

However, when I run the same code on a clean machine that doesn't have Crystal installed, I get error 500 returned after PEStartJob fails if I try to export to PDF, and I get error 692 when trying to export to HTML.

I did a search on the web, and there is an article that says error 692 if for unsupported export types, specifically HTML 3.0, which was stopped supporting as of Crystal 8. But, I am trying to export in HTML 4.0, which, like I said before, works fine on my dev box.

The error 500 means out of memory, but it's really just the catch all error code. Crystal sends back error 500 for many, many reasons.

So, it seems like maybe a DLL mismatch or missing DLL or something, but I can't track it down. Anyone have any ideas?You have to make sure you install all the necessary Export dlls on the new machine. Crystal reports 8.5 includes a file called runtime.hlp that lists all of the files needed. You're probably just missing a key dll or something.|||i've looked at the runtime.hlp file, and to the best of my knowledge, all the export dlls are there, with the same date/time stamps as the ones on my dev box|||Okay, I figured out the error 500 problem. I was missing the msvcp71.dll and msvcr71.dll.

But, I'm still having the error 692 problem...|||Look at this:

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

Error 20535

I'm running VB6, Crystal 8.0, and Access 2000. The Crystal Report does a dump of an Access table. My VB6 program calls the Crystal Report like this:

MyForm.MyCrystalControl.ReportFileName = "C:\MyReport.rpt"
MyForm.MyCrystalControl.Action = 1

When I run the program, I get the error "20535 : Unable to Connect : Incorrect Session Parameters".

There is no password on the database.
There are no subqueries or subreports in the Crystal Report.
It is a very simple report.
It works fine on my Win XP Pro development PC. It gives me this error message on my Win XP Pro deployment PC.

This is driving me nuts! Anyone give me a solution? I've looked all through the Crystal Reports website solutions, but none of them helped.

Thanks in advanceWell, this just gets weirder by the minute. I changed the Access database to the Access 97 format, and gave it a new name. When I tried to run the report again, it said it couldn't find the database, and asked me to identify it. I gave it the new Access 97 database, and then the report ran absolutely fine on the deployment PC.

So, with no other changes made, it appears that Crystal Reports 8 just doesn't want to work with an Access 2000 database. Can anyone tell me why, and how I can solve that problem?

Thanks

Error 20534 "Error detected by database DLL"

hi,

I'm using Crystal reports 8.0 with VB 6.0 and SQL Server 2000..I am getting the error "Error detected by database DLL" We were using SQL server 7.0 earlier and have recently upgraded to SQL 2000.The error appeared after this upgradation.Could anyone please help me with this.I've found some threads related to this error but none of them could solve my problem..Any help would be highly appreciated.

Thanks & Regards,
Ekta Singh.how are you passing the values to the report ? And also, are you using tables or stored procedures in the report ?|||If you installed ur package some where and getting this error then just make a check for the list of DLLs mentioned below, if any of them is not present in ur package then manually add it.

' FOR VB 6.0
MSVBVM50.DLL
MSVBVM60.DLL
msvcp50.dll
msvcp60.dll

'For SQL connection
P2ssql.dll
P2lsql.dll

'For Crystal reports
craxddt.dll
craxdrt.dll
Crpaig80.dll
crviewer.dll
Crxlat32.dll
Implode.dll
itircl.dll
itss.dll
MSADODC.OCX
MSBIND.DLL
MSSTDFMT.DLL
MSVCRT.DLL
MSVCRT40.DLL
msvfw32.dll
OLEAUT32.DLL
OLEPRO32.DLL
P2smon.dll
p2sodbc.dll
p2soledb.dll
SHLWAPI.DLL
sscdlg.dll
sscrc.dll
sscsdk80.dll
STDOLE2.TLB
u252000.dll
u25dts.dll
u2dapp.dll
u2ddisk.dll
u2dmapi.dll
u2dnotes.dll
u2fhtml.dll
u2frtf.dll
u2ftext.dll
u2fwks.dll
u2fwordw.dll
u2fxls.dll
u2l2000.dll
URLMON.DLL

'Not necessary to include
msldbusr.dll
UXDDISK.DLL
UXFDOC.DLL
UXFWKS.DLL
UXFWORDW.DLL

Still if u r facing the same error, then either problem with the connection string or some table or field or SP or view missing.

Make sure and checkout.|||I'm using Crystal reports 8.0 with VB 6.0 and SQL Server 2005..I am getting the error "Error detected by database DLL" when i create a left outer join on the table .
plz answer.....|||I'm using Crystal reports 8.0 with VB 6.0 and SQL Server 2005..I am getting the error "Error detected by database DLL" when i create a left outer join on the table .
plz answer.....

it happens when query is wrong
review your query using query analyzer of SQL server.

error 20534

Hi Everyone,

I am trying to print crystal reports from my VB
program. I have this command in my VB program
CrystalReports1.Action=1. My program is breaking
right here. It is gving me error , Error Detected by
database DLL. Err Msg: 20534. I searched this error
> code in google and saw that I can bypass this errror
> by writing

#Const fDebug = true
Dim logon as integer

On Error GoTo traperror:

With CrystalReport1
.ReportFileName = <path to report file>
logon = .LogOnServer("pdsodbc.dll","<Your
DSN>","","","")
.Action = 1
End With

Traperror:

#If fDebug = true then
If Err.Number = 20534 Then
CrystalReport1.Action = 1
End If
#End If

My program goes in this statement but breaks again
at crystalreport1.action=1. It breaks inside the
trap error label. Please anyone let me know what can
I do to avoid this error.

Any help will be greatly appreciated.

Thanks.Can be caused by a number of things...like ODBC Text Driver in VB6 SP3, like using subreport in your report and not passing login info to subreport, like incorrectly formned parameters, etc.

Given previous experience, I'd bet on a subreport, an incorrectly formed statement passed to .LogonServer, or a dodgy ODBC driver.

You should be using PDB*.DLL for standard (non-SQL) databases, and PDS*.DLL for SQL/ODBC databases....

Dave