Solved: error 20536 - crystal reports and oracle 8.i

Create Account

Crystal Reports

Questions

Followers

Top Experts

rambosh

error 20536 - crystal reports and oracle 8.i

I have a vb 6 project that connects to an oracle stored procedure and prints the crystal 8.0 report to a file. I have it working on 1 NT machine. Now I'm trying to get it working on the other machine and I'm getting error 20536. I can't remember how I fixed it on the 1st machine. I downloaded cror_815.dll. What else do I have to download or do? My dsn is and odbc source using the crystal for oracle driver. I have updated this driver.

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Mike McCracken

Which edition of CR do you have?

Is CR installed on the second machine?

mlmcc

EwaldL

which object model are you using (ocx, rdc..)?

make sure the odbc source is a system dsn, not a user dsn.

you can test the odbc source by sending it a select query using sqlcon http://support.crystaldecisions.com/library/kbase/articles/c2007753.asp

in case some crystal runtime files are missing you can compare dev + target machine with modules
http://support.crystaldecisions.com/communityCS/TechnicalPapers/modules_how_to_use.pdf.asp

rambosh

ASKER

I'm using Crystal 8 and ocx. I can run the report through Crystal and it works fine. But when I try to run it through VB, I get the error. I had the same problem on the original machine, I just don't remember how I fixed it. I know that I had to update the crystal for oracle driver(cror_815.dll) which I did. I don't know what else I have to download or do. It's using the logonserver method. Yes Crystal is installed on both machines.

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

mpaulagain

Unable To Connect:Incorrect Log On Parameters.This occurs when You have attempted to log on using incomplete or incorrect logon parameters.

So use correct "connect" method of the act-x control with proper dsn parameter if you are using the crystal active-x control(ocx)
check the values..
Martin

rambosh

ASKER

I'm not sure what I have to do here, but I got this working. Oddly enough, in the code, the pdsodbc.dll was in upper case. I changed it to lower case and it worked. I'm not sure how to close out this question.

ASKER CERTIFIED SOLUTION

modulo

membership

Signing up is free and takes 30 seconds. No credit card required.

Create Account

Crystal Reports

Questions

Followers

Top Experts

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.