ODBC Issue with Pervasive

[dgillz]

Crystal 8.5, Windows XP Pro workstation, using Pervasive SQL 2000i database.

When I execute a report I get the following error:

ODBC Error:[Intersolv]{ODBC Btrieve Driver]Invalid Character value

Any ideas?

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

http://www.trianglepartners.com

 

[rosemaryl]

Hey Dgillz,

Was this database upgraded to 2000 from a previous version?

Is it possible that the table and or field names contain invalid characters such as %, $, # ...

Also, have you tried turning odbc tracing on and reading through the log file to see where it is choking?

Regards,

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[dgillz]

There are no invalid characters.

How do I turn on tracing? Once I have done this, what do I do next?

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

http://www.trianglepartners.com

 

[rosemaryl]

Dear DGillz,

In ODBC Administrator, start/run/odbcad32, you will see that there is a tab TRACING.

Click that tab. Turn tracing on by clicking start tracing now.

Below that you can set the name and location of the log file.

Do that.

Now, run your report, when you get the error message, open up the log file. You should see exactly where it ran into the issue.

Make sure to turn tracing off. This can quickly fill up a hard drive <smile>.

Maybe if you provided a little more information, we could work this out.

Best regards,

ro

Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.