database table cannot be found

[goolawah]

I am trying to use CRXI Standard Edition to create simple reports for an application (Sage/Pastel Accounting) that uses the Pervasive database engine.

I have set up an ODBC data source using
OLE DB(ADO) - Microsoft OLE DB provider for ODBC Drivers as this iappears to be the only suitable ODBC driver available in the standard edition.

When I try to run the report I get the message "The database table <XXXX> cannot be found. Proceeed to remove this table from the report?"

Click NO and the report runs fine.

Click YES and it removes the file and the report fails (as expected).

Can anyone tell me how to eliminate the error message please?

Thanks,

 

[synapsevampire]

Standard doesn't support ODBC. Not sure about your specifics, it might work in some way...

-k

 

[dgillz]

You could connect directly to the ddfs. As SV indicated, the standard edition is very limited. Consider an upgrade to Crystal XI Pro.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[goolawah]

Thanks for the responses.

I understand that CRXI Standard does not support ODBC(RDO), but as far as I can see it does support OLE DB(ADO) and this provides access to the data source I need. It's just that I get this error message before the report runs.

I'm not sure how I can have any certainty that Upgrading to CRXI Pro, and using ODBC(RDO) would not have the same problem.

I wonder if any members have experience with ODBC and Pervasive Data Sources?

 

[IdoMillet]

You can test by downloading the 30-day evaluation of Crystal XI from:

http://www.businessobjects.com/forms/default.asp?id=701300000000tKv

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[synapsevampire]

You state "I have set up an ODBC data source using
OLE DB(ADO)".

Then say that it should work because the OLE DB uses ODBC???

The standard ismeant forpeople using direct fieldata sources, such as Access and Excel.

Download abd test as Ido suggests, and don't think that because you point OLE DB toODBC that somehow you get around this basic fact.

-k

 

[goolawah]

Great,thanks fellas, I'll download the eval.

 

[pmgatwork]

If when you select No the report runs then you must be connecting to the tables otherwise the report would not run at all.

I had a similar problem with good old sage files and Ido told me to do the following
Set Datasource Location
Properties
Use DSN Default Properties SET THIS TO TRUE
You may have to click this many times to get into edit mode

Give this a try

Peter