Need help with CPEAUT32 error 800a5036

[SandraAnn]

I'm using VBSCRIPT in an active server page to display Oracle data using Crystal Reports. I'm new to web designing and CR, so please excuse me if I'm not using the correct terminology. I've successfully tested the reports via the CR designer and for a while they were successfully being displayed via the web site. Recently I'm getting the error message "CPEAUT32 error 800a5036 Error detected by database DLL" whenever I attempt to run any report. The ASP file is using the Crystal.CRPE.Application object and the datasource information appears to be correct on the web server to access the Oracle back-end db. The line that the error is pointing to is is "Session("oRpt&quot.ReadRecords". I've inserted a bunch of Response.Write statements and have verified that the program does have a connection to the Oracle DB and tables. Any idea of what else I can look at to determine why this error is occurring?

 

[kenhamady]

A clue might be what changed between when it was working and when it first failed.

You might also try looking up that error in Crystal's KB, there is a FAQ with the link in the general forum. Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[balves]

.Readrecords is really running the report. So it's not running the report, either because it doesn't have a connection to Oracle or there's a problem with the report.

One thing Crystal told me to do a long time ago was to install Crystal Designer (if it isn't already) on the web server and run the report right from the console of the web server. If there's a problem there, you can Verify Database, etc.

If the report runs from the console of the web server, then the next most probable reason is that .LogonServer or .SetLogonInfo really isn't connecting to Oracle.

 

[SandraAnn]

This has been one of those elusive problems that has "miraculously" fixed itself in the past without my having done anything to resolve it. Unfortunately, I inherited an almost completed, but buggy, application that I'm trying to get to work correctly. As the developer, I have no access to the web or Oracle server and have to rely on the admins to notify me if anything has changed on them or update/install software, which they're relunctant to do unless I've got proof that it's something on the server. Since the last time it worked, I've updated one of the 7 reports, but now none of them will work. I'm not sure if this is relevant or not, but one forum post suggested running the ODBC tracing from my client when I run the application. It is returning a -1 error when exiting the sqlColumnsw function and I'm trying to determine what that may mean. All suggestions are welcome...

 

[SandraAnn]

As follow up to my previous post of 8/17, the error logged in sql.log for the ODBC trace is "DIAG [S1C00][Microsoft][ODBC driver for Oracle][Driver not capable(0)"

 

[balves]

I think you really need access to the web server and the oracle database server. You need to eliminate possibilities one by one.

One thing I remember reading from Crystal is that they strongly recommend using their OWN ODBC driver for Oracle. Not Oracle's, not Microsoft's. You can download the driver from Crystal's web site. It's made by Merant, which now owns PVCS and MicroFocus COBOL.