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..
aviator21114Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Are you creating a NEW connection or modifying the old one?

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
0
aviator21114Author Commented:
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.
0
mlmccCommented:
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
0
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

aviator21114Author Commented:
There must be some way to do this...
0
mlmccCommented:
Were all the reports using the same ODBC connection?

Can you name the new ODBC connection the same as the old one?

mlmcc
0
aviator21114Author Commented:
Although I thought I could change this in one place, I ended up going into each report and changed the data set location.
0
aviator21114Author Commented:
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...
0
mlmccCommented:
Isn't that what I said in my comments?

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.