Skip to Content
0
Former Member
Feb 23, 2011 at 06:56 PM

CR does not refresh calls to stored procs when updating ODBC Data Source

27 Views

I am working on a Crystal Reports 2008 SP3 retrieving data from a stored procedure. I am updating the datasource from a SQL Server 2008 odbc to another odbc that points to another database on the same SQL Server. The two stored procedures are identical but retrieve data from different databases (the live and the test database). The CR2008 says that the data source is changed to the new odbc/database but the data preview keeps loading data from the old odbc/database. Then I looked at the "Show SQL Query" and it keeps calling the old odbc stored procedure. I closed and reopened the SQL Server but it's no help. Does anyone know how to change the data source?