I am using MySQL and Visual Studio .Net(C#)
I downloaded and installed the ODBC .Net Data Provider
I can connect to my database and look at all my tables in the server explorer.
But when I create a new dataset and try to drag a table to it then I get a "You can not use an OLE DB provideer for ODBC driver" message. It doesn't give me the choice of ODBC .Net Dataprovider when I add the connection to server explorer.
It only lists OLE DB Providers which I tried the Microsoft OLE DB Provider for ODBC Drivers.
Re: Samplclnt example in MDAC 2.8: My Story ... I was incorrect when I stated that ODBC as a whole is deprecated. ...ODBC provider for OLE DB is deprecated; ... > | compiler errors.... (microsoft.public.data.oledb)
Re: Word 2007 mailmerge ... Word is trying to connect using the OLE DB provider ... it either fails because that provider is not present or because the table name is in the wrong format for the provider. ... (this is what Word generates when you try to connect manually using ODBC) ... on Vista, the default folder for Data Sources is now some kind of "search folder" that does not appear to pick up data sources recently saved in the former default folder, i.e. the user's My Data Sources folder ... (microsoft.public.word.vba.general)
OLE DB Provider for ODBC and Oracle ... I created a linked server for MS SQL Server 2005 Express to an Oracle ... database using the OLE DB Provider for ODBC.... I'm using the OLE DB Provider for ODBC instead of the Oracle OLE DB ... (comp.databases.ms-sqlserver)
Re: OLE DB Provider for ODBC/Win XP ... The Data Sources (ODBC) control panel applet only deals with ODBC data ... You are referring to an OLE DB provider....OLE DB has a similar data sources interface.... (microsoft.public.sqlserver.odbc)