I'm using Crystal Report 7 with Visual Basic 6 connect on a database SQL SERVER.
It's working fine on my computer but not on the user computer. Saying "Run-Time Error 20532: Can not find database DLL".
So is there a possibility that I have a corrupted file or maybe my connection settings are not ok?
When I open the report manually with Crystal on my computer and refreshing the data it's asking me about what connection I want. So, I use Microsoft SQL Server, my server is "SRV-SQL1", no user ID and no password and I select "Trusted Connection".
Now, in my VB code I use this:
.ReportFileName = App.Path & "\Report1.rpt"
.WindowState = crptMaximized
.DiscardSavedData = True
.Destination = 0
.Action = 1
So maybe I have to use LogOnServer but how can I pass the "Trusted Connection" setting.