Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB Components
|
VB Components Issues specific to components in VB.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Components section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 6th, 2006, 05:21 AM
Registered User
 
Join Date: Mar 2005
Posts: 9
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to Anup Gavate Send a message via Yahoo to Anup Gavate
Default VB 6.0 & Crystal Report 8.5 - Lot of Problems

Hi,

We are working on a CMS project, uses VB 6.0 with reports created in Crystal Report 8.5. We are accessing data from remote server.

So, to install the CMS system, we created a package in VB, installed it on different systems on client side.

On few systems, VB CMS working well but when we tried to open Crystal Reports, always showing the message -
'Run-time error '20532': Cannot find database DLL.' and i am not able to open any of the Report to view.

I saw this problem before, so i already took precaution and added all DLL files need for the execution of Crystal Report. Even though it is showing the same error message. I search on internet, came accross the different articles suggesting me to add different DLL files, but i already added them to the package. Pleaseeee, suggest me something that will work and get me out of this biggest trouble of my life.

Apart from this, on few systems, i am not able to connect to the remote database, the database is on remote server, where my web site is and i am trying to connect from client office. It is saying
'[Microsoft ODBC SQLServer Driver][DBNETLIB]SQLServer does not exist or access denied.'
I checked all known things but yet not able to solve it. I feel strange that when i am conncting to remote server from my system, i have to do nothing (by the way, my system is development system) but on client system, its not. Please have a look at the problem.

Thanks and Regards,
Anup :(
 
Old July 26th, 2006, 03:12 AM
Registered User
 
Join Date: Jul 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi Anup,

I am also facing the same problem. While installing VB Module in client system, it says cant intall "msvcp60.dll" since it is in use by OS. I ignored the err msg and continue to install. but crystal report is not working and says "Runtime error 20532. Can't find Database dll".

I cant even re-register the msvcp60.dll.

pl help. thnx in advance
 
Old August 26th, 2008, 06:24 AM
Registered User
 
Join Date: Aug 2008
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to brandonteohno1
Default

This is because you are not using Crystal Report 8.5 ActiveX Designer RunTime Library (craxdrt.dll)

Check out the complete solution here.

http://rapidshare.com/files/14002503...e-DLL.zip.html

Check out the blog entry here.

http://www.it-sideways.com/2008/08/u...dll-cr-85.html

It works for me. Contact me if you want.


 
Old June 5th, 2013, 01:54 AM
Registered User
 
Join Date: Jun 2013
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Arrow Crystal Report (8.5) is not working on win7/windows 2008 64 bit system

Crystal Report (8.5) is not working on win7/windows 2008 64 bit system

My application is a vb application and I am using Crystal report 8.5. It is working fine on 32 bit system and 64 bit system of Windows 2003 server. When I run the same application either on win7 64 bit or on 2008 64 bit, report does not open.
I am using vb script to access the database.
Part of the code written in the VB script file is as follows:
Dim objrsRecordSet 'As RecordSet
Dim strSQL 'As String

'**** Open Database Connection using the parameters passed from the main program
Set dbConnection = CreateObject("ADODB.Connection")
dbConnection.ConnectionString = "Provider=SQLOLEDB;Server=" & mstrServer & ";uid=" & mstrUserName _
& ";pwd=" & mstrPassword & ";Database=" & mstrDatabase & ";"

dbConnection.Open
dbConnection.CommandTimeout = 200

dbConnection.Properties("Enable Fastload").Value = True




Basically we have two visual basic projects developed in VB 6.0 language: let’s say
1. Diapp (we consume the report.dll in this application, in order to generating the reports)
2. Adacrystalapp (which is used for making the report.dll)


Diapp application generating the reports on windows-XP(32 bit machines) without any problems but when I run the same application on 64 bit machines(win7/Vista…etc) report is not generating.
If I run the both applications (Diapp, Adacrystalapp) in debug mode then reports are generating on 64 bit machines (win7/vista) also without any problems.



Please help me out with this issue, i will appreciate for your response.





Similar Threads
Thread Thread Starter Forum Replies Last Post
Crystal Report & VB6 & SQL Server wlho VB How-To 2 June 5th, 2013 01:58 AM
simple report and crystal report in vb.net saket123 .NET Framework 2.0 0 August 13th, 2008 06:55 AM
problem with oracle & crystal report with Vb abhijhegde Beginning VB 6 1 May 3rd, 2007 12:03 PM
Crystal Report & .NET Eagle Crystal Reports 0 June 22nd, 2005 09:15 PM
Crystal Report & Java ritesh12 Crystal Reports 0 May 25th, 2005 04:17 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.