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