CODEWITHSUNDEEP
mysqlvisual-studio-2010ms-accessms-access-2007
Sithelo
Sithelo

Reputation: 307

Visual Studio 2010 Ultimate fails to connect to MySql

I have two database. One in Access 2007 and another remote in MySQL. The Access 2007 has to update the MySQL database. In Visual Studio there is tool under Data-->New Data Comparison which seems to compare the databases and synchronize them.

I have two challenges:

  1. Connect to MySQL database. It defaults to port 3306 and this is not the port I want.
    How do I change the that port to 3307 ?

  2. How to make this database show on Data Comparison so that I can compare my two databases i.e access 2007 and MySQL.

Upvotes: 0

Views: 318

Answers (1)

Mandar Pande
Mandar Pande

Reputation: 12974

Regarding your first Question:

You can change the port number to 3307from my.cnf file.

Stop MySQL [3306] -> modify my.cnf ->Start MySQL [3307]..

Upvotes: 2

Related Questions