Link to home
Create AccountLog in
Databases

Databases

--

Questions

--

Followers

Top Experts

Avatar of jana
jana🇺🇸

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?

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Avatar of janajana🇺🇸

ASKER

I notice that in the Set Datasource Location, under "Current Data Source", the catalog is WORKS, even though I changed to the UPDATEd WORKINGS.
ASKER CERTIFIED SOLUTION
Avatar of Mike McCrackenMike McCracken

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
SOLUTION
Avatar of Marcus AureliusMarcus Aurelius🇺🇸

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Avatar of janajana🇺🇸

ASKER

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
Avatar of janajana🇺🇸

ASKER

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.

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

SOLUTION
Avatar of Guy Hengel [angelIII / a3]Guy Hengel [angelIII / a3]🇱🇺

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account
Avatar of janajana🇺🇸

ASKER

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.

Avatar of Mike McCrackenMike McCracken

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

mlmcc
Avatar of janajana🇺🇸

ASKER

My programmer just finished informing me that he redid the entire report over the weekend.

Thanx for the support.
Free T-shirt

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Avatar of janajana🇺🇸

ASKER

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)
Avatar of Mike McCrackenMike McCracken

A lot of different things.  It is one of the harder problems to diagnose.

mlmcc
Databases

Databases

--

Questions

--

Followers

Top Experts

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.