- #MICROSOFT WEBMATRIX LINK TO MYSQL DATABASE DOWNLOAD#
- #MICROSOFT WEBMATRIX LINK TO MYSQL DATABASE WINDOWS#
I had no idea Windows had a command line program in there with MySQL, I won't be afraid to go into command line now for working with MySQL.Īny other MySQL tools you would recommend for creating databases etc. Query OK seems like an odd way of confirming the database creation, but does that sound right then? It supports to import Oracle, MS SQL, MS Access, Excel, CSV, XML, or other formats to MySQL.
#MICROSOFT WEBMATRIX LINK TO MYSQL DATABASE DOWNLOAD#
Still stepping throough it, but here was the command line prompt following entering that line: - If you need a GUI for MySQL Database, you can download - NAVICAT (MySQL GUI). Click here to get more information about .ni.dll.
Was the semi color part of the command line for create the database, it looks like it was )ĭoes this sound like confirmation that the Db was indeed created then in MySQL, Further, MySQL workbench is a different tool to connect to your cloud DB. However, if your DB is required VPN connectivity, you may also need to connect to VPN before using ODBC DSN. I have used similar approach to connect mysql db which was in AWS cloud to connet from powerbi. I was looking within the content area of Webmatrix, under databases, where the only option was:Īdd a database to your site, and SQL compact being the only option there. This might help you in connecting to the MY SQL DB from powerbi. This will make me sound like a n00b for sure, but I was totally overlooking the ribbon controls. One option to implement such a link is by using MS SQL’s ‘linked server’ feature. This situation requires a link between the local MS SQL Server and the MySQL server on the web, so that changes to information in the MS SQL Server can immediately be propagated to the web database. When I reload WebMatrix however, the connection I created under the database tree is gone. I've edited the web.config with the correct connection string, as far as I can tell anyways. Thanks Faith, that helped alot, I'll give a shout if I have problems. The web pages, however, use a MySQL database for data storage. In order to do so however, I need to connect to my remote MySQL database, which uses a different port than the standard 3306.
0 kommentar(er)
