Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Wrong Datasource

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

Former Member
Not what you were looking for? View more on this topic or Ask a question