I have some Crystal Report files that are linked to Microsoft SQL Server... I can open them fine on any computer that has Crystal Reports installed , but on other computers that I install the VB program on that uses the report, I get an error when trying to open the report. The error states that pdssql.dll is not found.. Now I figure the reason why the report doesn't work on computers that don't have Crystal reports installed is that they don't have the Crystal reports ODBC drivers that are necessary for linking to SQL... the only thing I want to know is how I can distribute the necessary files with my application and have them setup correctly as drivers in the computers that need them.

Can anyone help ?