New to mySQL, using asp.net(vb.net-fairly new) trying to connect to mySQL database. (i have classic asp pages connecting to mysql for a forum, so i'm pretty sure it's .net related)

i'm following this example http://www.mysql.com/articles/dotnet/#ODBC.NET

when i try to reference the namespace (Microsoft.Data.Odbc ) it's not recognized. The following are installed on my computer:

.NET 1.1
mySQL 4.0.13
ODBC .NET Data Provider
Microsoft fix for .net data provider (FIX: ODBC Driver Manager Incorrectly Reports SQL_NO_DATA_FOUND for ANSI Driver)
mySQL ODBC driver 2.50 (needed for snitz forums) - also noticed 3.51 is also installed.

(and i did reboot after all installs)

does anyone know of any issues and why i can't reference the namespace?

Namespace changed from v1.0 to v1.1 of the .net runtime.

Its now System.Data.Odbc

so whereever you have a

using Microsoft.Data.Odbc; statement, change it to using System.Data.Odbc;

Sorry, I didn't realise you were using VB.NET

It should be:

Imports System.Data.Odbc

Regards,

Malbs

Is this true, Malby? My development PC has .net v1.0 and my server has v1.1 redistributable. I'm using Microsoft.Data.Odbc all the time and I didn't see any error so far.

Has anyone installed Microsoft.Data.Odbc assembly on your server?

If they haven't, then I would imagine your code would throw FileNotFoundException instances.

You have to put the Microsoft.Data.Odbc in the applications /bin folder.

BUT! if you are using v1.1 just change Microsoft.Data.Odbc to, as already pointed, System.Data.Odbc

cya,
/PatrikB