on 06-05-2013 1:35 AM
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.