My Connection inside my Crystal Reports is pointing to sqltst01. As long as my "data source" below is pointing to sqltst01 it works great...If I change the "data source" code below to sqldrk03 it doesn't find data b/c it appears its still trying to look at sqltst01.
Any thoughts why it doesn't chnge the reports data source to sqldrk03?
connectionInfo.Add "Provider", "SQLOLEDB.1;"
connectionInfo.Add "Data Source", "sqltst01" //with sqltst01 it works. change to sqldrk03 and it still appears to be using sqltst01
connectionInfo.Add "UserID", "*********"
connectionInfo.Add "Pwd", "**********"
connectionInfo.Add "Initial Catalog", AH#RDP
Is "Data Source" what I should be using for connectionInfo.Add "Data Source"? When I use:
connectionInfo.Add "DSN" I get an "invalid call or procedure" on this line....If I change it to connectionInfo.Add "Data SourceXXXX" I don't get an errors it just uses the default data source that is set in the report itself.
Edited by: Kacy Reiss on Sep 23, 2008 10:55 PM