asked on
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.
Crystal Reports
Last Comment
modulo
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
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
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.
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
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
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Is CR installed on the second machine?
mlmcc