aviator21114
asked on
Crystal Reports global ODBC connection change
This is similar to a few questions already posted but I haven't found the exact details for waht I need to do. My sql database has moved and I need to globally change the connection to point to the new sql database. It's a 32bit server and I've located the odbc connections panel. I'm not sure which tab (User/System/File) to use in the ODBC Data Source Admin and how to configure. Gave it a couple of trys but when I pull up the report to test it still has the old database.
Big points for the assist here..
Big points for the assist here..
ASKER
The connection was established for each report when it was developed in crystal. I'm told I can make a global DSN and make one change to point the reports to the new database. Just looking for exact details on what to change.
There are 3rd party tools that are supposed to do what you want. I have never used them
http://www.kenhamady.com/bookmarks.html#doc
There is no way in Crystal itself to do it
mlmcc
http://www.kenhamady.com/bookmarks.html#doc
There is no way in Crystal itself to do it
mlmcc
ASKER
There must be some way to do this...
Were all the reports using the same ODBC connection?
Can you name the new ODBC connection the same as the old one?
mlmcc
Can you name the new ODBC connection the same as the old one?
mlmcc
ASKER
Although I thought I could change this in one place, I ended up going into each report and changed the data set location.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for aviator21114's comment #a39460445
for the following reason:
See my previous post...
Accepted answer: 0 points for aviator21114's comment #a39460445
for the following reason:
See my previous post...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Does the old database still exist?
If not when you run the report does it work?
After setting the ODBC connection did you do a VERIFY DATABASE?
If you are building a NEW connection did you use the SET DATABASE LOCATION to change the database location?
mlmcc