Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Microsoft JET OleDb driver
Message
From
09/05/2013 10:58:10
 
 
To
09/05/2013 08:47:21
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
VB 9.0
OS:
Windows 7
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01573051
Message ID:
01573212
Views:
55
This message has been marked as a message which has helped to the initial question of the thread.
I can think of two reasons

- OLEDB goes through the COM layer. It's very likely faster and uses less memory to go through ODBC

- Microsoft is dropping OLEDB. At some point they won't update the Jet OLEDB Provider. Then you'll either a) be forced to stay with older versions or b) Be in crisis mode trying to rewrite for ODBC.


>This is an isolated process which is not part of the framework data dictionary, thus accessing that table is disconnected from the regular environment. To make it work, an example was found on the net and it seemed everyone was using the same approach from .NET to access a DBF. There is a new 64-bit driver and I believe the developer is using it presently. I still haven't had the chance to verify the results. What are the advantages of using that one over the other?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform