MySQL Forums
Forum List  »  Microsoft Access

changing MS Acces to MySQL
Posted by: Massoud Hosseinali
Date: September 30, 2011 01:30AM

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 ?

Options: ReplyQuote


Subject
Views
Written By
Posted
changing MS Acces to MySQL
5876
September 30, 2011 01:30AM
2188
October 04, 2011 12:11AM
1868
October 04, 2011 02:14AM
2105
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.