I have an application that uses a number of Crystal Reports to connect against a choice of SQL Servers.

At runtime the Crystal Reports should connect to the same Server/Database that the application is connected to, however I am having trouble producing a report if the Server I try to connect to, is not the Server that I used when designing the Crystal Report.

ie. If I design a report using Server A and try to run the report when connected to Server A, everything works fine.

However, if I try and run the same report when connected to Server B, I get the message 'SQL Server error'.

(The report I am using is nothing complex and the Databases on each Server are identical in design.)

The only thing I am trying to change is the connect property.
Code:
rptReport.Connect = "DSN=myDSN;UID=myUID;PWD=myPWD;Database=myDatabase"
If this makes sense, can anyone tell me what I am doing wrong??

Any assistance would be grately appreciated - I've been stewing on this one for about 5 months now.

Thanks