I am designing a crystal report using SQL Server Data. when I designed the report I used the Crystal reports data explorer to find my data set on SQL server server1. Now when I try to run the report using server2 I get an error 20599 "Cannot open SQL server".If I got back to the report and click on "refresh report data" the report prompt to login to server1. If I change it to server2 and resave the report then re-run the report from my application it runs fine. I am using the ".LogOnServer("p2ssql.dll","servername","databasename","LOGINID","PASSWORD")" in my application but it only seems to switch server names when I change it in the crystal report itself. Any Ideas on what I am doing wrong ?

Thanks For Your Help !
Stephen J. Hunt