Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 310448 - Last Review: January 22, 2004 - Revision: 3.0
INFO: OLE DB .NET Managed Provider Does Not Support Some OLE DB Providers in Visual Basic .NET
This article was previously published under Q310448
For a Microsoft Visual C# .NET version of this article, see
312794Â
(http://kbalertz.com/Feedback.aspx?kbNumber=312794/EN-US/
)
.
This article refers to the following Microsoft .NET Framework Class Library namespace:
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Â
(http://kbalertz.com/Feedback.aspx?kbNumber=310985/EN-US/
)
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:
APPLIES TO
- Microsoft ADO.NET 1.0
- Microsoft ADO.NET 1.1
- Microsoft Visual Basic .NET 2002 Standard Edition
- Microsoft Visual Basic .NET 2003 Standard Edition
| kbinfo kbsystemdata KB310448 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate
Be the first to leave feedback, to help others about this knowledge base
article.
(Optional) Name
(Optional)
Public URL Or Email
Comments
No
HTML -- Text Only Please