Crystal Report Failed to retrieve on a change database

I have a Crystal Report that was using with a DB WORKS.  We had a problems with SQL server and restores the DB but to another name.

That is:

Old DB = WORKS (which doesn't exist in the new SQL server)

New DB = WORKING

Now we get this error:
Failed to retrieve

---------------------------
Crystal Reports
---------------------------
Database Connector Error: '42S02:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'WORKS.dbo.POP10100'. [Database Vendor Code: 208 ]'
---------------------------



We went to Database >> Set Database Location and included the a new ODBC

But we still get the error.

I have CR XI

How can we make the report work with the new database WOKING?
rayluvsAsked:
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.

rayluvsAuthor Commented:
I notice that in the Set Datasource Location, under "Current Data Source", the catalog is WORKS, even though I changed to the UPDATEd WORKINGS.
0
mlmccCommented:
Did you create a new connection to the new database?

You may have to do the update for each table.

Does the report have a subreport?

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
MIKESoftware Solutions ConsultantCommented:
Yes it will retain the Name of the Original DB even though you change the Location.

What it is telling you is that there is NOT a table named:  WORKS.dbo.POP10100
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

rayluvsAuthor Commented:
Sorry for the delay...been out of the country and could reply to some of the questions.

I would like to open this question again or please advice on how to continue.

Thanx
0
rayluvsAuthor Commented:
Understood.  Here are the replies:

mlmcc:

Yes, I created a new database connection, still no good.  The report does not have subreport?

CRXIuser2005:

Understood.  But there is the tables in the database.  Its a restore of the same DB.

0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
is the database name specified in the query itself?
is the query using a stored procedure/view, that refers to the database name in turn?
0
rayluvsAuthor Commented:
Yes.  There are queries involved, but again, they are pointing to tables, no database name is being specified

No stored procedure/view being used.

The curious thing is that the report was not changed only Set Database Location.

0
mlmccCommented:
Can you look at the SQL?
DATABASE --> SHOW SQ SUERY

mlmcc
0
rayluvsAuthor Commented:
My programmer just finished informing me that he redid the entire report over the weekend.

Thanx for the support.
0
rayluvsAuthor Commented:
One last thing and just picking at your brains, what can cause this type of problems of "Failed to retrieve"?

(just in case it repeats itself and would like to plan some sort of contingency)
0
mlmccCommented:
A lot of different things.  It is one of the harder problems to diagnose.

mlmcc
0
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
DB Reporting Tools

From novice to tech pro — start learning today.