Error running SQL SERVER rpt

[DougStiers]

I am attempting to run a SQL SERVER rpt and get the following message: "Error creating crystal report! Cannot find database DLL."

I am calling the rpt via this vb sub:

Dim craApplication As Object
Dim crrReport As Object

Public Sub gsOpenCrystalReport(sRptFileName As String)

Set craApplication =CreateObject("Crystal.CRPE.Application&quot
Set crrReport = craApplication.OpenReport(sRptFileName)
crrReport.Preview sRptFileName

End Sub

I ran an ACCESS rpt to make sure the viewer is working. I installed all the dll's on the list. Any help would be appreciated.

 

[StevenK]

Ensure that you have the appropriate database DLL's (I think they're p2sodbc.dll and p2ssql.dll). Similarly ensure that you have access to the SQL Server database from the client machine (with the appropriate user name and password). If you're making of the CRViewer (Crystal reports Viewer) component ensure that you have the appropriate files installed (I think these are CRViewer.DLL and Crxdrt.dll).
I access Crystal reports through Delphi code. I have to indicate a log-in for the database (namely user-name, password, server-name and database-name) - I remain unsure if you will need to indicate the database access dll you intend to use for the access.
Steve