rama0411
asked on
Error 20534 VB-Crystal Report
Hello,
I am creating a report in Crystal Report 8.0 with text datatype using SQL Server. I am able to view the report when i check it on my machine. But when i move Exe to user's machine, i get error "Error 20534. Error connecting database dll". From my machine it works fine at both the times, design and run, but on user's machine it does not run. If i change datatype to char from text, the report comes fine on user's machine. If i change it back to text, report gives error 20534.
Can anyone help,
Thanks,
Ramesh.
I am creating a report in Crystal Report 8.0 with text datatype using SQL Server. I am able to view the report when i check it on my machine. But when i move Exe to user's machine, i get error "Error 20534. Error connecting database dll". From my machine it works fine at both the times, design and run, but on user's machine it does not run. If i change datatype to char from text, the report comes fine on user's machine. If i change it back to text, report gives error 20534.
Can anyone help,
Thanks,
Ramesh.
look for the datatype of the field in the database and as well as in the crystal reports mismatch of them can lead them to crash a char placeholder cannot be suited for a char.
ASKER
mlpk_tyr,
I am using stored procedure to populate report, so there should not be any data type mismatch issue. Also, i am able to open report on my machine. It only happens when i try to run report from user's machine.
mlmcc,
I already tried module and moved all files from my machine to user's machine which module was showing as different. still no luck.
Finally i have created setup.exe from VB-Wizard for that application and ran setup on user's machine and now report is coming fine. I have to go through now at least 200 files and try to find which one is giving issue as we can not run setup on user's machine every time also there are more than 100 users of application.
Thanks,
Ramesh.
I am using stored procedure to populate report, so there should not be any data type mismatch issue. Also, i am able to open report on my machine. It only happens when i try to run report from user's machine.
mlmcc,
I already tried module and moved all files from my machine to user's machine which module was showing as different. still no luck.
Finally i have created setup.exe from VB-Wizard for that application and ran setup on user's machine and now report is coming fine. I have to go through now at least 200 files and try to find which one is giving issue as we can not run setup on user's machine every time also there are more than 100 users of application.
Thanks,
Ramesh.
How are you connecting to the report?
What code are you using in VB?
mlmcc
What code are you using in VB?
mlmcc
This shows the required files for Crystal 8
http://support.businessobjects.com/library/kbase/articles/c2007290.asp
Be sure to look at the developer.hlp file either on the CD or in the Crystal directories.
mlmcc
http://support.businessobjects.com/library/kbase/articles/c2007290.asp
Be sure to look at the developer.hlp file either on the CD or in the Crystal directories.
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.