changing MS Acces to MySQL
I have a web site using ASP and access as database
and now im gonna change access to MySQL
all i need to do is to create a MySQL database with same tables and fields and change my
adoCon.connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("****.mdb")
to
adoCon.connectionstring = "Driver={MySQL ODBC 5.1 Driver};Port=3306;Option=3;Server=****;User ID=****;Password=***;Database=*****;"
?
or is there anything else i should care about ?
Subject
Views
Written By
Posted
changing MS Acces to MySQL
5892
September 30, 2011 01:30AM
2192
October 04, 2011 12:11AM
1870
October 04, 2011 02:14AM
2109
October 06, 2011 02:23PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.