Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pervasive ODBC

Status
Not open for further replies.
goolawah

goolawah

Technical User
Jan 6, 2005
94
AU
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.
 
Sort by date Sort by votes
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
 
Upvote 0 Downvote
Does this work in both Pervasive WorkGroup and Pervasive Client/Server?
Click to expand...
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?
Click to expand...
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.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
 
Upvote 0 Downvote
Many thanks, 'dgillz' and 'mertheil' for very helpful responses.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ianbtheog
  • Locked
  • Question
Connection Manager is not running at the specified port number - Pervasive 13.31.014 - Intermittent
Replies
2
Views
545
ianbtheog
ianbtheog
dgillz
  • Locked
  • Question
DDF Builder for Actian fka Pervasive SQL
Replies
3
Views
533
mirtheil
mirtheil
profoundhypnotic
  • Locked
  • Question
How to read a csv file in Pervasive?
Replies
1
Views
578
mirtheil
mirtheil
michellepace
  • Locked
  • Question
Source control for pervasive? (git)
Replies
1
Views
342
mirtheil
mirtheil
Ambientguitar
  • Locked
  • Question
Need help opening a Pervasive Database or BTR files
Replies
3
Views
674
mirtheil
mirtheil

Part and Inventory Search

Sponsor

Back
Top