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")
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 4838 Massoud Hosseinali 09/30/2011 01:30AM
Re: changing MS Acces to MySQL 1739 Devart Team 10/04/2011 12:11AM
Re: changing MS Acces to MySQL 1528 Massoud Hosseinali 10/04/2011 02:14AM
Re: changing MS Acces to MySQL 1611 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.