Joined: 24 Jun 2014
Location: United States
Online Status: Offline
Posts: 6
Topic: Xi R2 error message Posted: 30 Jul 2014 at 11:16am
I am rewriting a report in CR Xi R2 that has been working just fine in 8.5. The report connects to an Access database. The message I am getting is "Failed to retrieve data from database". The next message says "Database Connector Error: 'DAO error Code: 0xd20 Source:DAO.Database Description: Query is too Complex.'"
There are about 40 tables in the report (this is fewer than were in the 8.5 version of the report). I have changed, 1-by-1, all the links to 'left outer'.
Does anyone have any suggestions/help/ideas? (BTW, I have tried different versions of MS Access db's with CR Xi R2; the preferred db is MS Access 2007).
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 30 Jul 2014 at 12:20pm
FYI: I do not believe CR XI R2 will support a DB that is in 2007-2010 format.
I am surprised that a 8.5 report converted to a newer version would have this error. Of course is it is based on the connector. I do not know if you have tried creating (or if it feasible within your setup) to create an ODBC connection.
Joined: 24 Jun 2014
Location: United States
Online Status: Offline
Posts: 6
Posted: 30 Jul 2014 at 12:23pm
I downloaded the latest MS Access ODBC drivers, created an ODBC connection (32 bit) and connected to that from CR Xi. All seemed fine and dandy... until the dreaded query error. Am I hitting some kind of XiR2 or MS Access2007 boundry?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum