Bob Beauchemin
3/30/2002 3:55:00 AM
There is no integration between the Odbc data provider (which is the access
method for ODBC data sources) and VS.NET. The only piece that works is
creating a connection. Because this uses the OLE DB Data Links API, VS
"thinks" you want to use the OLE DB provider for ODBC rather than the .NET
Odbc data provider when you attempt to use the connection. And, as the
message says, "MSDASQL provider is not supported.
You'll have to code the rest of the Odbc data provider code by hand, for
now. Or use a different OLE DB provider.
Hope this helps,
Bob Beauchemin
bobb@develop.com
"doctor doctor" <g_o_d99@hotmail.com> wrote in message
news:e8#nGD51BHA.1640@tkmsftngp04...
> I'm using VisualStudio.NET trying to connect to either an Access or MySQL
> database (both show up under connections in System Explorer). When I try
to
> set the OleDbConnection Data ConnectionString for a New Connection , at
the
> final step, I get the following error message:
>
> "The .Net Data OLE DB Provider(System.Data.OleDb) does not support the
> MSDASQL Provider, Microsoft OLE DB Provider for ODBC Drivers."
>
> Under the Provider tab, I've selected Microsoft OLE DB Provider for OBDC
> Drivers. Under the Connection tab, all my installed drivers are listed.
> Regardless of the driver I choose, Test Connection works. The error
occurs
> when I attempt to select the .mdb file (Access) or the MySQL database.
>
> Any help or suggestions?
>
> TIA
>
>