Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Unknown connectivity Post Reply Post New Topic
Author Message
eberhard
Newbie
Newbie


Joined: 21 Sep 2011
Online Status: Offline
Posts: 7
Quote eberhard Replybullet Topic: Unknown connectivity
    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.
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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. 

IP IP Logged
eberhard
Newbie
Newbie


Joined: 21 Sep 2011
Online Status: Offline
Posts: 7
Quote eberhard Replybullet Posted: 23 May 2012 at 5:04am
I have verified that the ODBC's are different names and different database.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.