Bob Beauchemin
2/22/2002 5:46:00 PM
I am not "another Microsoft MVP" that will send you a link. Only
information. ;-)
The Odbc data provider will work to do data access. Even with the RTM
version, if you download the correct version.
The Odbc data provider is not well integrated into the Visual Studio wizards
and designers. AFAIK, one thing you can do (perhaps the only thing) is to
configure a data source and (with some drivers) browse your database tables.
This is because Visual Studio uses the OLE DB data links dialog to configure
connections and the OLE DB provider for ODBC is not supported. The OLE DB
connection string produced is not "post-processed" for the Odbc data
provider, as it is for the SqlClient data provider.
IMHO, there is a big difference between saying a data provider does not work
and saying it does not work seemlessly with the Visual Studio designers. The
latter can be worked around by coding.
Hope this helps,
Bob Beauchemin
bobb@develop.com
"mike" <mmckee@connx.com> wrote in message
news:usHlW07uBHA.2332@tkmsftngp07...
> Before I get another email from a "Microsoft MVP" giving me a link to to
> ODBC.NET, I would like them to actually try it and see if it works with
the
> released version of DOT NET.
>
> The errors I get (and two of my associates on different machines)
indicates
> that it works on BETA 2, but not on the Release Version. The error can
occur
> just by trying to Configure an OleDB Adapter.
>
> It seems to log on the first time (and you might see a connection
succeed),
> but then it tries to connect again, and you see the message "The
connection
> you have created does not work with the current adapter".
>
> This happens on ACCESS and SQLSERVER.
>
> Thankyou
>
>