Physical Database Not Found - provided solutions haven't worked

[stnkyminky]

I'm using CR DE 8.0. I create a report from a stored procedure in a SQLServer 2000 database. When settting the location I chose More Data Sources. Then I selected SQL Server and was prompted for the server name, etc. **I didn't use trusted connection for this report**

I can run the report from within Crystal without a hitch. The problems start when I package and deploy the report to the client. When attempting to view the report I'm confronted with a "Physical Database not found" error. I've searched this board and the web for solutions. I've applied several "guaranteed" fixes with no luck.

I've updated my cwr32.exe, updated dlls (p2ssql.dll, p2sodbc.dll)

Below is a list of DLL that are included in my setup application
craxddt.dll
craxdrt.dll
crpaig80.dll
crviewer.dll
p2smon.dll
sscsdk80.dll - If this is left as a dependency file the package will not compile.

Please help!

thx Scott
Programmer Analyst
<{{><

 

[stnkyminky]

I'm using Visual Installer 1.1 to package the application.
Scott
Programmer Analyst
<{{><

 

[dgillz]

Is the ODBC datasource that you used to run the report from the development machine present on the destination machine?
Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[stnkyminky]

I'm not using odbc/DSN. I understood it to be a direct connection.

I just created a System DSN and attempted to connect in my development environment. This worked correctly.

I moved the application to a test machine and rcvd this error.
&quot;File could not be opened because pdssql.dll could not be found.&quot;

Database ->Convert Driver shows that pdssql.dll is the driver that I'm using. WHen I search my pc for it nothing is returned.

I thought that p2s*.dll's where the newer ones? I've got p2ssql.dll on my dev machine.


Thanks!
Scott
Programmer Analyst
<{{><

 

[stnkyminky]

I've cross posted this on the VB5&6 forum
thread222-421415 Scott
Programmer Analyst
<{{><