Article ID: 310374 - View products that this article applies to.
This article was previously published under Q310374
This article refers to the following Microsoft .NET Framework Class Library namespace:
The OleDbConnection class specifically prohibits you from using MSDASQL or data source names (DSNs) when you connect to your data sources in ADO.NET. If you try to use MSDASQL or DSNs, you receive the following error message:
An unhandled exception of type 'System.NotSupportedException' occurred in systemldata.dll. Additional information: The .Net Data OLE DB Provider(System.Data.Oledb) does not support the MSDASQL Provider, Microsoft OLE DB Provider for ODBC Drivers.
To resolve this problem, use an OLE DB Provider rather than an ODBC driver. Alternately, download, reference, and use the ODBC Managed Provider.
The ODBC .NET Data Provider is an add-on component to the Microsoft .NET Framework Software Development Kit (SDK). The ODBC .NET Data Provider provides access to native ODBC drivers in the same way that the OLE DB .NET Data Provider provides access to native OLE DB providers.
The ODBC .NET Data Provider should work with most ODBC drivers. However, only the following drivers have been tested with and are known to be compatible with the ODBC .NET Data Provider:
Microsoft Universal Data Access (MDAC) Web page
Steps to Reproduce the Behavior
You can download the ODBC Provider from the following Microsoft Web site:
Microsoft Universal Data Access (MDAC) Web pageFor additional information ODBC .NET Data Provider, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/310985/EN-US/ )HOW TO: Use the ODBC .NET Managed Provider in Visual Basic .NET and Connection Strings
Article ID: 310374 - Last Review: July 18, 2012 - Revision: 4.0