General information
Title:
Error Cannot open SQL server
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only