Firstly download the MDAC 2.8 (available from http://www.microsoft.com/downloads/d...DisplayLang=en
at time of writing this was most recent.
Then ensure MyODBC has been downloaded. This is available form MySQL website under downloads. I used a dummy Access connection for testing the connection proving the drivers worked. After this I used the connection string from http://www.connectionstrings.com
. If this fails, try the instructions at http://www.planetsourcecode.com/vb/s...1288&lngWId=10
selecting .NET when it asked for the forum you require. It is entended for VB
.NET users, but it is easy enough to adapt to C#, using your current connection string.
when using the URLs, it might be worth copying them to the clipboard and pasting them, when I looked at this message, half the URLs didn't render correctly!
Hope that works for you
David Thorne, Student