slxdeveloper.com Community Forums

The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!

Reporting & Notification Forums - Reporting
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Reporting | New Thread

View: Search:

Author

Thread: Failed to retrieve data from database.

orodriguez
Posts: 26

Failed to retrieve data from database. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 22 Apr 08 8:10 PM

When I try preview the report, Crystal show me this message:
Failed to retrieve data from database. Details: ADO Error Code:ox
Source: Saleslogix OLE DB Provider.
Description: Failed to parse SQL.
Native Error: [Database Vendor: 3]
--------
I using:
- SQL Server 2005
- CR R2
- SLX 7.0

Anyone can help me pls!

[Reply][Quote]

Snow Monkey
Posts: 214

Re: Failed to retrieve data from database. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Apr 08 2:05 PM

Yes simple. Try to run the sql which cr genarates and run that in wg admin in slx(Tools - Mange) It has to show you a "failed to parse" error. SLXOLEDB provider is NOT as smart as the SQL OLEDB provider or any other MS provider for sql server. SLXOLEDB provlider translates it inot another sql whch gets executed in the db.

So getting the sql that is inputted to the slx is the key here...

[Reply][Quote]

orodriguez
Posts: 26

Re: Failed to retrieve data from database. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 25 Apr 08 6:06 PM

Thxs Nandu.

I fix the error re-linking the tables in Database Expert of the Crystal. The table relationship in CR is not the same concepts about RDBMS (Relational Database Management System).

Regards!

[Reply][Quote]

Dan Delisle
Posts: 38

Re: Failed to retrieve data from database. Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 12 Feb 13 3:54 PM

This totally saved me. I had been struggling with this problem for over a week. Thank you so much for sharing this problem and solution. In my case I just had to reverse the links.

[Reply][Quote]

Page 1 of 1

You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/25/2024 2:53:49 AM