Skip navigation links

MySQL Forums :: Microsoft Access :: changing MS Acces to MySQL


Advanced Search

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 3595 Massoud Hosseinali 09/30/2011 01:30AM
Re: changing MS Acces to MySQL 1209 Devart Team 10/04/2011 12:11AM
Re: changing MS Acces to MySQL 1081 Massoud Hosseinali 10/04/2011 02:14AM
Re: changing MS Acces to MySQL 1100 Peter Rafeiner 10/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.