alegitimatebusiness.com

As a reforming PHP MySql developer, one thing i really love in LAMP development is the simplicity and no fuss approach. Mysql is small (22mb download) fast and quite capable of most website datastorage. Also the fact that it doesnt cost $5000.00 per processor… thats good too.

So it seems like a good choice to use the advantages of the .NET framework, with the power of MySql. Is this available for VWD Express users however?The answer is yes!

Due to restrictions on the pluginability (technically speaking) VWD Express cannot install the Native Mysql for .NET connectors (mysql conector .net) which would give the best performanc. If you use Visual Studio 2005 then this would be the best choice.

To use Mysql with Visual Web Developer 2005 install Mysql ODBC as follows:

1. Download the ODBC data drivers .

2. Setup your ODBC connection

3. in your config.xml or connection .NET SqlDataSource Object use the mysql connection string found here

In your config.xml you will set up a connection similar to this:

<connectionstrings>
<add name="ConnectionString"
	connectionString="Driver={MySQL ODBC 3.51 Driver};
	Server=localhost;
	Database=test;
	User=root;
	Password=;
	Option=3;"
     providerName="System.Data.Odbc">
     </add>
</connectionstrings>

This entry was posted on Wednesday, August 29th, 2007 at 3:07 pm and is filed under .net. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.