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
2
Replies
AdChoices