is this possible, i had to use the mysql class to connect to the database, but i would rather use oledb.
the connection string i used is "Provider=MySQLProv;Data Source=mySQLDB;User Id=myUsername;Password=myPassword"
when i try to connect a popup titled "MySql Data Source Name Setup" always comes up. even if i try entering the login information i fail to connect. Has anyone else experienced this and/or knows the solution?