PDSSQL.DLL

[ComputerNurse]

I created a report from a SQL Server database. I am able to run the report but others receive the error unable to locate pdssql.dll, the dll p2ssql.dll is present on the workstation in c:/winnt/crystal directory.

I tried changing the driver to pdsodbc but the report does not work. I was not able to find and answer on crystals website.

Can someone offer suggestions on how to fix this?

 

[pgtek]

hi

1.does the report work on your computer?
2. Are u on a network?
3. do the user access this report from the network or have to copy the report on there computer?
3. what version of crystal are u using?

cheers

pgtek

 

[ComputerNurse]

I can open the report and run the report. We are using version 8.5.0.217 each with a local install. Reports are local

 

[pgtek]

Ok
do these other computer have the same sql database access?
same table same permission?

 

[ComputerNurse]

Yes,we are connecting to sql server using the same privledges. The logon I test with has select only privledges and the reports runs.

When the other user connects the report opens if you execute the message "the library.dll cannot be found please check your installation.

 

[pgtek]

Hi

are you using a systems DSN ans a ODBC connection?

 

[ComputerNurse]

ODBC

 

[pgtek]

ok

did you create this report using a odbc connection and a system DSN?

 

[dgillz]

I have seen this before. Make sure all workstations are connecting to the SQL server consistently - i.e. using windows authentication everywhere, or using SQL Server authentication everywhere.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[ComputerNurse]

Thanks for the help,their was a problem the dsn on the other pc