INFO: OLE DB .NET Managed Provider Does Not Support Some OLE DB Providers in Visual Basic .NET (310448)


The information in this article applies to:

  • Microsoft ADO.NET (included with the .NET Framework) 1.0
  • Microsoft ADO.NET (included with the .NET Framework 1.1)
  • Microsoft Visual Basic .NET (2002)
  • Microsoft Visual Basic .NET (2003)
This article was previously published under Q310448
For a Microsoft Visual C# .NET version of this article, see 312794.

This article refers to the following Microsoft .NET Framework Class Library namespace:
  • System.Data.OleDb

SUMMARY

The OLE DB .NET managed provider does not support all OLE DB providers.

MORE INFORMATION

The OLE DB .NET managed provider does not support the Microsoft OLE DB Provider for ODBC (MSDASQL). You must use the ODBC .NET managed provider instead. For additional information about the ODBC .NET managed provider, click the article number below to view the article in the Microsoft Knowledge Base:

310985 HOW TO: Use the ODBC .NET Managed Provider in Visual Basic .NET and Connection Strings

The OLE DB managed provider requires that the OLE DB provider support a command syntax to select and update data. Most simple OLE DB providers meet this requirement. Because the Microsoft OLE DB Provider for Exchange only supports updates through cursors, the OLE DB managed provider does not support the OLE DB Provider for Exchange.

The OLE DB (OleDb) and SQL Server (SqlClient) managed providers require multi-statement batch support to retrieve any changes that you make after updates or inserts (for example, if you retrieve the value of an AutoNumber or Identity column). Because Microsoft Jet does not support multi-statement batches, you must include additional code to handle this case.

The following code sample demonstrates how to use the OLE DB managed provider to connect to a Microsoft SQL Server database.

NOTE: You must ensure that the System.Data.OleDb namespace is declared in the "General Declarations" section first. 
    Dim cn As OleDbConnection = New OleDbConnection("Provider=SQLOLEDB.1;Data Source=MySQLServer")
    cn.Open()

REFERENCES

For more information about .NET managed providers, refer to the following MSDN Web site:

Inside .NET Managed Providers
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndive/html/data010112001.asp

Modification Type:MajorLast Reviewed:1/22/2004
Keywords:kbinfo kbSystemData KB310448 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.