Failed to retrieve data from the database

[JLR1234]

I am using VB6 and CR11. I have about 500 standard reports that I've converted from CR8 to CR11 and updated the VB6 code to work with cR11. All of these reports work fine.

I then created a new report in CR11. It uses the same VB6 code as the reports above. This report works when I view it through the app to a database that has the same DSN as the database I used to create the report (DSN1). This report does not work if I try to connect through the app to a DSN on another computer (DSN2).

If I reverify the database using DSN2 then the report works for DSN2 databases only. It no longer works for DSN1 dbs.

I am completely stumped because the reports are viewed using the same VB Code - so it must be in the report itself. Yet when I look at the properties for a standard report and this new report they seem to be the same. Am I missing a property in Crystal? Any ideas?

 

[JLR1234]

I forgot to tell the error message. The message I receive is "Failed to retrieve data from Database. Details: [Database vendor code 208]

 

[JLR1234]

I found that in the reports that work, the tables do not have specified catalogs or owners. These properties are not available.

In the reports that don't work, the catalogs and owners are specified for each table. How do I reset these properties so they can be passed in the code?