What are the advantages of using the Pervasive data provider for .NET instead of the generic System.Data.Odbc provider and just passing in the Pervasive driver name?
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
I'm not sure I understand how the Pervasive provider is any more or less "managed" than the System.Data.Odbc provider... they're both managed code are they not? I suppose I see how a certain layer is removed because the Pervasive provider already knows what driver to use... but does that really matter? There must be some good reason they continue to release new versions... otherwise why bother?
The only advantages of using the native Managed provider is that it is fully managed (up to the engine) where as using ODBC, you get to unmanaged code faster and have two additional layers (MS ODBC Driver Manager and Pervasive Client ODBC driver). Because of this, you usually see better performance.
The only advantage of using ODBC is that it is not tied to a "native" database driver and might be easier to use multiple databases (I say might because unless you are only using simple SQL, you'll probably have to deal with syntax differences).
Business Accounts
Answer for Membership
by: mirtheilPosted on 2009-05-28 at 08:30:03ID: 24494354
The main advantage is that the Pervasive provider is Managed and avoids the overhead of the ODBC layer on the client. Both communicate to the server using the same protocol.
I haven't done any testing in a while but when it first came out, I found that the data provider was faster than using ODBC. I can't find my numbers to support that though.