I am using asp.net and mysql. I made a connection using:

"Provider=MSDASQL.1;
DRIVER=MySQL ODBC 5.1 Driver;
Persist Security Info=False;
User ID=root;
SERVER=localhost;
UID=root;
Password=mypassword;
DATABASE=actmain;
PORT=3306;

My connection is successful and am able to make datasets.

However, when add the dataset to display my data and preview the page, I get
the following error (info) in my browser:

System.ArgumentException: The .Net Framework Data Provider for OLEDB
(System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC
Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC
(System.Data.Odbc).
at System.Data.OleDb.OleDbConnectionString.ValidatePr ovider(String progid)
at System.Data.OleDb.OleDbConnectionString.ValidateCo nnectionString(String
connectionString)
at System.Data.OleDb.OleDbConnectionString..ctor(Stri ng connectionString,
Boolean validate)
at System.Data.OleDb.OleDbConnectionFactory.CreateCon nectionOptions(String
connectionString, DbConnectionOptions previous)
at System.Data.ProviderBase.DbConnectionFactory.GetCo nnectionPoolGroup(String
connectionString, DbConnectionPoolGroupOptions poolOptions,
DbConnectionOptions& userConnectionOptions)
at System.Data.OleDb.OleDbConnection.ConnectionString _Set(String value)
at System.Data.OleDb.OleDbConnection.set_ConnectionSt ring(String value)
at System.Data.OleDb.OleDbConnection..ctor(String connectionString)
at DreamweaverCtrls.DataSet.NewDbConnection(String strConnection)
at DreamweaverCtrls.DataSet.DoInit()

--------------------------------------------------------------------------------
System.ArgumentException: The .Net Framework Data Provider for OLEDB
(System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC
Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC
(System.Data.Odbc).
at System.Data.OleDb.OleDbConnectionString.ValidatePr ovider(String progid)
at System.Data.OleDb.OleDbConnectionString.ValidateCo nnectionString(String
connectionString)
at System.Data.OleDb.OleDbConnectionString..ctor(Stri ng connectionString,
Boolean validate)
at System.Data.OleDb.OleDbConnectionFactory.CreateCon nectionOptions(String
connectionString, DbConnectionOptions previous)
at System.Data.ProviderBase.DbConnectionFactory.GetCo nnectionPoolGroup(String
connectionString, DbConnectionPoolGroupOptions poolOptions,
DbConnectionOptions& userConnectionOptions)
at System.Data.OleDb.OleDbConnection.ConnectionString _Set(String value)
at System.Data.OleDb.OleDbConnection.set_ConnectionSt ring(String value)
at System.Data.OleDb.OleDbConnection..ctor(String connectionString)
at DreamweaverCtrls.DataSet.NewDbConnection(String strConnection)
at DreamweaverCtrls.DataSet.DoInit()

--------------------------------------------------------------------------------
System.Exception: The DefaultView was requested but no tables yet exist.
at DreamweaverCtrls.DataSet.get_DefaultView()

--------------------------------------------------------------------------------
System.ArgumentException: The .Net Framework Data Provider for OLEDB
(System.Data.OleDb) does not support the Microsoft OLE DB Provider for ODBC
Drivers (MSDASQL). Use the .Net Framework Data Provider for ODBC
(System.Data.Odbc).
at System.Data.OleDb.OleDbConnectionString.ValidatePr ovider(String progid)
at System.Data.OleDb.OleDbConnectionString.ValidateCo nnectionString(String
connectionString)
at System.Data.OleDb.OleDbConnectionString..ctor(Stri ng connectionString,
Boolean validate)
at System.Data.OleDb.OleDbConnectionFactory.CreateCon nectionOptions(String
connectionString, DbConnectionOptions previous)
at System.Data.ProviderBase.DbConnectionFactory.GetCo nnectionPoolGroup(String
connectionString, DbConnectionPoolGroupOptions poolOptions,
DbConnectionOptions& userConnectionOptions)
at System.Data.OleDb.OleDbConnection.ConnectionString _Set(String value)
at System.Data.OleDb.OleDbConnection.set_ConnectionSt ring(String value)
at System.Data.OleDb.OleDbConnection..ctor(String connectionString)
at DreamweaverCtrls.DataSet.NewDbConnection(String strConnection)
at DreamweaverCtrls.DataSet.DoInit()

--------------------------------------------------------------------------------
System.Exception: The DefaultView was requested but no tables yet exist.
at DreamweaverCtrls.DataSet.get_DefaultView()

--------------------------------------------------------------------------------

I've checked out all the links on the following link but found no useful info:
http://kb.adobe.com/selfservice/view...8848&sliceId=2

Can anyone help please...

Thanks ahead of time.

?