ADO.Net Dataset Object

Hi,

i'm using an ADO.Net Dataset Object, in which i'm dragging a table from server Explorer. The connection in server explorer is straight to the SQL server.

Now i want to make a data connection in server explorer using an OLE DB provider for ODBC Drivers. I can do this, but i'm getting "You cannot use an OLE DB provider for ODBC drivers" message when i drag a table from this connection on my dataset object. :confused: :confused: :confused:



(to be clear: with dataset object, i mean a Dataset1.xsd file in my project)

To use an ODBC connection, you need to download the ODBC .NET Data Provider. The OLEDB connection can not be used.
The ODBC .NET data provider will be included in the new version of the .NET framework (1.1 now in beta) in the System.Data.Odbc namespace, but in the seperate download it is included in the Microsoft.Data.Odbc namespace (I don't want to know what kind of problems this will cause)

http://msdn.microsoft.com/downloads/...mpositedoc.xml

I already have the ODBC .Net data provider already installed.
The error message comes when i try to drag a table from server explorer onto my dataset.xsd file.
When i use another connection type, it works fine.