Print Page | Close Window

[Crystal SQL Designer] suite Crystal Reports 7

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9386
Printed Date: 03 May 2025 at 8:02am


Topic: [Crystal SQL Designer] suite Crystal Reports 7
Posted By: Josh Maikyy
Subject: [Crystal SQL Designer] suite Crystal Reports 7
Date Posted: 15 Mar 2010 at 10:47pm

Hi there,

I am having some troubles using Crystal SQL Designer in Crystal Reports 7 (unfortunately I can not upgrade this version because of other software needs).

In details, I can not create a SQL query to process the data stored in my Access database (that has been created by Access '97: I can not upgrade or convert it, too because this file is automatically reprocessed and rewritten by the other software I am using, every time I generate a report).

When I open Crystal SQL query designer, if I use as origin my Access file (I even tried to create different ODBC data origins by using different drivers) I get this error:
"xBase error: Could not open the file"

I have also tried to create a query using the sample database archived in Crystal Reports and the error I get is:
"ODBC error: [Microsoft][Driver ODBC Microsoft Access]..."
 

Does anyone know how to deal with that?

Oh, by the way, I am running XP Professional SP3.


Thanks so much!
Josh Maikyy


Print Page | Close Window