Data access on a machine where Crystal is not installed

[sgk17]

I'm using Crystal 8.5 and I'm calling reports from within my application. If I run the app on a machine without Crystal installed I get a 500 - "Invalid ODBC Handle" error. Here's what I want to do. I'm trying to connect through a "Microsoft SQL Server" connection thats listed under "More Data Sources". I'm trying to avoid copying or making an ODBC data source on each machine. But I've also tried file dsn, OLE DB and some other stuff. But each time I try on a machine with no Crystal, I get that error. I am copying over Crystals crpe.dll and p2sodbc.dll files. Am I missing a .dll file or is there another way to connect? Thanks.

 

[sgk17]

In other words, Does the data source option "Microsoft SQL Server" use the p2sodbc.dll or a different .dll file?

 

[hilfy]

Is the MS SQL Server client software installed on the workstations?

-Dell

 

[vidru]

Native connections to SQL Server use p2ssql.dll in CR 8.5.

-dave

 

[sgk17]

No, the SQL Server client software isn't installed on the workstations. Is it required? And I tried copying the p2ssql.dll and it doesn't work either.

 

[vidru]

You need to take a look at the Runtime.hlp file for CR 8.5. The default location for it is:
C:\Program Files\Seagate Software\Crystal Reports\Developer Files\Help\Runtime.hlp

That'll help you track down the necessary .dlls you need to distribute.

-dave

 

[sgk17]

Thanks, I didn't know about that file. Does the MS SQL Server client software have to be installed on the workstations? It is installed on mine, but not the others.