10/13/2025 8:44:13 PM
|
| |
| 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!
Forum to discuss reports for SalesLogix including Crystal, SQL Reports, etc. View the code of conduct for posting guidelines.
|
|
|
|
Failed to retrieve data from database.
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!
|
|
|
|
Re: Failed to retrieve data from database.
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... |
|
|
|
Re: Failed to retrieve data from database.
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! |
|
|
|
Re: Failed to retrieve data from database.
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. |
|
|
|
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!
|
|
|
|
|
|
|
|