Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Pervasive ODBC

Pervasive ODBC

Pervasive ODBC

I have been getting help with Crystal XI from the Business Objects forum but hope members of this forum will have more experience specifically with the Pervasive ODBC Interface.

Before I upgrade to CRXI Professional to get full ODBC connectivity, I wanted to confirm from other's experience that the Pervasive ODBC Interface will allow me to set up a data source that I can use for Crystal Reports.

Does this work in both Pervasive WorkGroup and Pervasive Client/Server?

How do I decide whether/when to use the Pervasive Engine Interface, or Client Interface?

Any feedback, comments or advice gratefully appreciated.

RE: Pervasive ODBC

I have been writing crystal from Pervasive datasources for many years.  I always use the engine interface.  I've never even tried the client.  I've never used workgroup either.

It is worth pointing out that you do not have to use ODBC in a Pervasive environment, you can connect directly to the .ddfs.  ODBC is preferred however, IMHO.

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

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

RE: Pervasive ODBC


Does this work in both Pervasive WorkGroup and Pervasive Client/Server?
Most applications do not detect the difference between a Workgroup Engine and a Client/Server engine. While it is possible to detect which engine is being used, most applications do not. Most application will work with either engine.


How do I decide whether/when to use the Pervasive Engine Interface, or Client Interface?
It depends on when engine you are using, where the data resides, and where the application is running.  If you are using Client/Server, the data is on the server, and you are trying to access the data from a client then you would use the Client Interface pointing to an ENgine interface defined on the server.  In a Workgroup environment, or locally at the server, you would use the Engine interface.

Certified Pervasive Developer
Certified Pervasive Technician

RE: Pervasive ODBC

Many thanks, 'dgillz' and 'mertheil' for very helpful responses.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close