Is there a better way to do all of this, or am I on the right track? I would appreciate any assistance. I just want to build out a package that will allow me to pull data from the MySQL and push to a SQL server. The problem is that I cannot find a 圆4 driver for MySQL for VS. I looked up the error, and it appears that there is a mismatch between the x86 and 圆4 drivers. However, now when I try to connect, I get "ERROR The specified DSN contains an architecture mismatch between the Driver and Application". It seemed to work, and I was able to see the connector in VS. I still could not get the MySQL connector to appear when I tried to connect a new database to VS, though.įrustrated, I decided to create a User DSN (as opposed to a System DSN) and connect that way. So then I installed the connector by itself, BEFORE installing the ODBC or NET connectors and I got it to install.
#Microsoft visual studio 2017 connect to mysql install
Each time I would attempt to install the MySQL for Visual Studio connector, the installer would say that Visual Studio was not installed on my computer. NET connectors, and I tried reinstalling them over and over again.
![microsoft visual studio 2017 connect to mysql microsoft visual studio 2017 connect to mysql](https://codeinsane.files.wordpress.com/2019/04/vc-01.png)
So I uninstalled Visual Studio, the MySQL ODBC and. My first problems began because the MySQL installer would not recognize the installation of Visual Studio (even though I ALSO have 2013 installed!). MySQL for Visual Studio provides access to MySQL.
![microsoft visual studio 2017 connect to mysql microsoft visual studio 2017 connect to mysql](https://i.stack.imgur.com/9eNnM.jpg)
I have followed the instructions listed on the MySQL website - I have tried the MySQL Installer as well as the standalone download. MySQL for Visual Studio works with Connector/NET and Microsoft Visual Studio 2012, 2013, 2015, and 2017.
![microsoft visual studio 2017 connect to mysql microsoft visual studio 2017 connect to mysql](https://i.stack.imgur.com/4AY9X.jpg)
I just want to be able to add a MySQL database as a database connection in VS so I can build an integration. For the life of me, I cannot get the MySQL for Visual Force connector to work in VS.