cocacola
asked on
Run-Time Error 20532: Can't find database DLL
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:
With CrystalReport1
.ReportFileName = App.Path & "\Report1.rpt"
.WindowState = crptMaximized
.DiscardSavedData = True
.Destination = 0
.Action = 1
End With
So maybe I have to use LogOnServer but how can I pass the "Trusted Connection" setting.
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:
With CrystalReport1
.ReportFileName = App.Path & "\Report1.rpt"
.WindowState = crptMaximized
.DiscardSavedData = True
.Destination = 0
.Action = 1
End With
So maybe I have to use LogOnServer but how can I pass the "Trusted Connection" setting.
ASKER
The error message persist. Is there other files I have to include with the distribution package?
Note: I'm able to open the form with the OCX of Crystal but the error occur when I want to print the report.
Note: I'm able to open the form with the OCX of Crystal but the error occur when I want to print the report.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Keep failing!!
I check every files to be carefully registered. Every file looks fine to me on the computer users.
Users 'cause I tried on two different user.
Both of the dev computers are working find though.
Maybe it's not about file distribution ...
I check every files to be carefully registered. Every file looks fine to me on the computer users.
Users 'cause I tried on two different user.
Both of the dev computers are working find though.
Maybe it's not about file distribution ...
ASKER
I know but I can't make it work!
I'm still working on it ...
I'm still working on it ...
ASKER
I found my problem thx to you and the list of files you gave me in your post.
The problem was my P2SSQL.DLL file that was not properly registered. When I tried manually to register the file with regsvr32 it said that the NTWDBLIB.DLL was not on the user computer. This is the Microsoft SQL Client Library.
So I include the NTWDBLIB.DLL in my distribution package and voilà!
I'm a happy guy!
The problem was my P2SSQL.DLL file that was not properly registered. When I tried manually to register the file with regsvr32 it said that the NTWDBLIB.DLL was not on the user computer. This is the Microsoft SQL Client Library.
So I include the NTWDBLIB.DLL in my distribution package and voilà!
I'm a happy guy!
This error message appears because Msvcp60.dll has not been distributed to the client computer.
Resolve this error message by including Msvcp60.dll as part of the runtime distribution package.
Best of luck,
jrmn