Question
Connecting mySQL with ASP.NET
I have an existing application, written in ASP.NET/C# with
Dreamweaver, and using MS Access as the database.
However, I now wish to upsize the database to mySQL - but I can't figure out how to connect to it with Dreamweaver. All the help seems to be centred around using PHP/mySQL - but it would be a royal pain in the butt to have to rewrite the whole of my application in PHP!
I tried the following connection stuff in the web.config file:
<add key="MM_CONNECTION_STRING_myConnection" value="Provider=MySQLProv;Data Source=myDatabase;User Id=myUserName; Password=myPassword;" />
<add key="MM_CONNECTION_DATABASETYPE_myConnection" value="OleDb" />
But nothing seems to work! The application falls over with the following error:
System.InvalidOperationException: The 'MySQLProv' provider is not registered on the local machine. ---> System.Data.OleDb.OleDbException: No error information available: REGDB_E_CLASSNOTREG(0x80040154).
--- End of inner exception stack trace ---
at System.Data.OleDb.OleDbConnection.CreateProviderError(Int32 hr)
at System.Data.OleDb.OleDbConnection.CreateProvider(OleDbConnectionString constr)
at System.Data.OleDb.OleDbConnection.Open()
at DreamweaverCtrls.DataSet.DoInit()
Any help would be greatly appreciatied (a new tutorial would be even better!)
And if it can't be done, I'd like to know that also, as I won't waste any more of my time searching for a solution.
Thanks
Caz Mockett
However, I now wish to upsize the database to mySQL - but I can't figure out how to connect to it with Dreamweaver. All the help seems to be centred around using PHP/mySQL - but it would be a royal pain in the butt to have to rewrite the whole of my application in PHP!
I tried the following connection stuff in the web.config file:
<add key="MM_CONNECTION_STRING_myConnection" value="Provider=MySQLProv;Data Source=myDatabase;User Id=myUserName; Password=myPassword;" />
<add key="MM_CONNECTION_DATABASETYPE_myConnection" value="OleDb" />
But nothing seems to work! The application falls over with the following error:
System.InvalidOperationException: The 'MySQLProv' provider is not registered on the local machine. ---> System.Data.OleDb.OleDbException: No error information available: REGDB_E_CLASSNOTREG(0x80040154).
--- End of inner exception stack trace ---
at System.Data.OleDb.OleDbConnection.CreateProviderError(Int32 hr)
at System.Data.OleDb.OleDbConnection.CreateProvider(OleDbConnectionString constr)
at System.Data.OleDb.OleDbConnection.Open()
at DreamweaverCtrls.DataSet.DoInit()
Any help would be greatly appreciatied (a new tutorial would be even better!)
And if it can't be done, I'd like to know that also, as I won't waste any more of my time searching for a solution.
Thanks
Caz Mockett
