C# and MySQL

[Laeg]

Is it possible to connect and retrieve/manipulate data with existing .NET objects in C# without installing MySQL Connector?

I have been trying the following connection string format without success.

<appsettings>
 <add key="C_MY_DSN" value="Provider={MySQL ODBC 3.51 Driver};server=MyServer;database=MyDB;UID=sa;password=password"/>
</appsettings>

I have also tried ...

<connectionStrings>
 <add name="C_MY_DSN" connectionString="Server=MyServer;Database=MyDB;User ID=sa;Password=password" providerName="MYSQL"/>
	</connectionStrings>

 

[dseaver]

you should be able to use the OCDB, you just need the right connection string and

http://www.connectionstrings.com/

should help

 

[dseaver]

Here is a link to all the MySQL connection string

http://www.connectionstrings.com/?carrier=mysql.