Print Page | Close Window

Unknown connectivity

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16516
Printed Date: 21 Apr 2025 at 12:11pm


Topic: Unknown connectivity
Posted By: eberhard
Subject: Unknown connectivity
Date Posted: 22 May 2012 at 8:14am
I have an old Crystal  (written in 8.5)    the author is no longer with the company.    Normally we set up an ODBC to a SQL database, when we want to change database we would "Set Location" to a different ODBC.
 
I need to link to a different database and I have setup the new ODBC and linked to it.   However the data on the report is not changing.   I have switched databases many times   so I know how to do it. 
 
The author has done something to link to the current database tables which is not "our"  norm.  (maybe a view or stored procedure)    I can't find it.   Any suggestions on how to find how he was linking to the current database     I need to run this report on a different database.


Replies:
Posted By: kevlray
Date Posted: 22 May 2012 at 10:02am
The only time I have had the "Set Location" not work is when the new connection is the same name as the old connection. 


Posted By: eberhard
Date Posted: 23 May 2012 at 5:04am
I have verified that the ODBC's are different names and different database.


Print Page | Close Window