cancel
Showing results for 
Search instead for 
Did you mean: 

Help, please..

Former Member
0 Kudos

Im not sure where to start this discussion.. this place is confusing.

I am having trouble with the Crystal Reports 2011.

I have created a database connection, and I am trying to edit a report. When I click over to print preview to look at my changes, I am unable to. It will ask me for my server information again, and then bring up an error saying: " Failed to retrieve data from database.". I click "ok" (my only option), and then I get another error:

"Failed to retrieve data from the database.

Details: ADO Error Code: 0x80040e37

Source: Microsoft OLE DB Provider for SQL Server

Description: Invalid object name 'DemoGolf.dbo.VI_PS_DOC_HDR'.

SQL State: 42S02

Native Error: 208 [Database Vendor Code:208]

I can not figure this out. I have tried re-creating my database connection, deleting the sub-report connection and many other things.

Please help!

Thank you in advance!

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Mallory,

You can choose to do a 'Verify Database' before trying to refresh the report. Its under 'Database' menu.

This will help to know if a table name has changed or a column does not exist anymore etc.

Also, a new report could be created based on the same set of tables for testing purpose.

-Prathamesh

abhilash_kumar
Active Contributor
0 Kudos

Hi Mallory,

Install the SQL SERVER NATIVE CLIENT (SQLNCLI 10.0) from Microsoft's website.

Then create an OLEDB connection from CR using this driver.

You might also want to see whether the table your connecting to connects and returns records from the Management Console. Database Vendor code errors are usually not CR issues, they're mostly database issues.

Let us know the results.

-Abhilash

Former Member
0 Kudos

Hi!

I think, one of the field value is not defined, so for example, if your query is trying to extract data for vendor code  'V001', and if VEndor 'V001' does not exist, it will throw an error.

Regards,

KS