Visual Studio Xampp数据连接 [英] Visual Studio Xampp data connection
问题描述
我想在Visual Studio 2013中添加数据连接。我想使用Xampp在本地主机上托管数据库。我用phpmyadmin设置了数据库。现在,我想在VS中添加一个连接。
I want to add a data connection in Visual Studio 2013. I want to use Xampp for hosting my database on localhost. I seted up my database with phpmyadmin. Now i want to add a connection in VS.
在服务器浏览器下,我选择添加新数据连接。我选择了micorosoft odbc数据结构。接下来,我想建立一个新的连接字符串。但是我找不到一个Mysql odbc驱动程序。
所以我直接从mysql http://dev.mysql.com/downloads下载/ connector / odbc / 并安装它。我试图重新启动计算机和VS,但此驱动程序仍然没有出现。
Under server explorer i choose add new data connection. I choose the micorosoft odbc data structure. Next i wanted to build a new connection string. But i cannot find a Mysql odbc driver for that. So i downloaded it directly from mysql http://dev.mysql.com/downloads/connector/odbc/ and installed it. I tried to restart my computer and VS but this driver still doesnt appear.
推荐答案
我首先下载并安装了此MySQL for Visual Studio。
http://dev.mysql.com/downloads/windows/visualstudio/
,然后连接器
http://dev.mysql.com / downloads / connector / net /
I downloaded and installed this MySQL For Visual Studio first http://dev.mysql.com/downloads/windows/visualstudio/ then the connector http://dev.mysql.com/downloads/connector/net/
我没有问题可以连接到MySQL。尝试连接时,请确保XAMPP MySQL正在运行。
I have no problem connecting to MySQL. Make sure XAMPP MySQL running though when you trying to connect.
PS。我正在使用Visual Studio Ultimate 2013和最新的XAMPP。我只安装了MySQL Workbench,什么也没有。
PS. I am using Visual Studio Ultimate 2013 and latest XAMPP. I have only installed MySQL Workbench and nothing else.
这篇关于Visual Studio Xampp数据连接的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!