Can I use ADO.NET, C#, VisualBasic.NET, or the .NET framework with the Pervasive OLE DB provider?
The Pervasive.SQL V8 provider has been fully regressed with ADO.NET. It should be fully functional. Unfortunately, the provider within Pervasive.SQL 2000i (SP4) and all before it are not compatible with the .NET framework. The root of the problem is that the current provider was created for use in an Apartment threaded application (Visual Basic or Apartment threaded C++). Microsoft has changed their threading structure within the .NET framework that renders our provider useless. To change the provider to work within a Multi-Threaded Apartment (free-threaded) is substantial and will not be introduced until the next Pervasive product release.
