List:MySQL on Win32« Previous MessageNext Message »
From:Amr Mohamed Date:August 26 2003 4:17am
Subject:OleDbConnection problem (C#)
View as plain text  
- To Connect to Mysql  ODBC driver, you need to have both MyODBC driver and the .net ODBC.
- After that Add a reference to the ODBC.NET dll, its name is Microsoft.Data.Odbc.dll
- The ArgumentException that occured in System.data.dll proves that you didnnot add
refernce to odbc dll because the error should happen in the odbc dll
- For the issue of when to use "provider" and "driver" conflict:
    * you use the "Provider = ; Datasource = ; Initial catalog =" syntax with the OLEDB,
SQLClient, Oracle providers
    * you use the "Dirver = ; Server = ; Database = ;" syntax with ODBC Providers
- If you find any problems, feel free to E-Mail me, Also you will find useful information
at http://www.mysql.com/articles/dotnet/
Thread
• OleDbConnection problem (C#)Amr Mohamed25 Aug