I've found a Webmatrix help article that says MS Webmatrix "publishes the (SQL Server or MySQL) database by creating scripts that run in a database that has been created for you by your hosting provider." That is wonderful, except I can't get it to work when I'm trying to publish a MySQL database (backing wordpress) through FTP (my hosting provider does not support 'web deploy'). Again, no problem, since it is already documented that " FTP protocols cannot be used to publish MySQL database. " But this does not excuse Webmatrix from generating MySQL database install scripts for me. During the publishing step, no database install script is generated - at least that I can tell - and there is no manual option to create a database export / backup / install script.
In short, as Webmatrix goes, I'm dead in the water trying to get my database uploaded to my hosting provider. Does anyone know the trick to force Webmatrix to create the MySQL database install scripts on my local box? Once created, I can take-over the upload and install process.
I just installed the WebMatrix Beta 3 on a machine and tried to create a site from web gallery. The site required MySql. MySql does not get installed so I looked at the install log files for WebMatrix and I see that WebMatrix is trying to download MySql from http://mysql.llarian.net/Downloads/MySQL-5.1/mysql-5.1.49-winx64.msi. The log indicates the return was 404. When I take a look at the llarian site, I no longer see this file available for download. The oldest file available is mysql-5.1.53-winx64.msi.
I have mysql 5.5 on my computer, but when I try to install joomla 1.6 the Web Platform installer does not recognise the mysql 5.5 database allready installed on my machine (os windows 7 64 bit). Instead it prompts me to download and install mysql 5.1.Am I doing something wrong? I this a bug or there is some incompatibility between webMatrix and my sql 5.5?
oledbCon.ConnectionString = "Provider=MySqlProv; Data Source=localhost; Initial Catalog = AnymoreComputers; User id=WeakUser2;Password=1234";
my site is working and running wrote in c# and mssql 2005,
now i want to make it run with mysql.....i converted all my data base...and created the same users (same names)
anc copied all to my sql .
the question is how do i connect to mysql wit c# ......
my regular connection for mssql :
oledbCon.ConnectionString = "Provider = SQLOLEDB.1; DATA Source = (local); Initial Catalog = test1; Integrated Security = SSPI; User ID=WeakUser2;Password=1234"; the connection to mysql : oledbCon.ConnectionString = "Provider=MySqlProv; Data Source=localhost; Initial Catalog = test1; User id=WeakUser2;Password=1234";
this connection doesnt works ... where is my mistake ? what hsould i do ... ?
and this is the error ig get when i run my solution :"The ConnectionString property has not been initialized."
I have the following piece of code in my web.config file.. I am trying to connect to a MySQL database. The code compiles fine and when I am ruuning the website I come across this error - 'Keyword not supported: 'server'.':
i have used the following connection string, but it only works for localhost, when i am trying to upload it on server it gives error.,error is specied below..it urgent plz resolve as soon as possible...
<add name="connectionname" connectionString="Server=servername;port=3307;User Id=xyz;Password=abc; database=databasename"/> Error - Unable to connect to any of the specified MySQL hosts. Exception Details: MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts.
how to connect ASP to MySQL database. I have already install MySQL in my localhost, Add a connection through Data Source (ODBC) in ctrl panel and test connection succeed. Now I want to show the query on my default.aspx page so that I can do the insert / update / delete my table data in MySQL.
I have a MySQL data at a web hotel. I can connect to the database from my web application hosted at the hotel . But trying to connect from a client application running on my PC fails using the same ConnetionString. The error is: Unable to connect to any of the specified MySQL hosts
In fact the method below (the method is protected in the web application) fails in my client application but works in my web application.
I just tried to download WorkBench 5.2 and HeidiSQL, both connects to the database from my PC when supplying server and password information.
System.Data.Odbc.OdbcException: ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '127.0.0.1' (10048)ERROR [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '127.0.0.1' (10048)
I m using visual studio 2010 and i downloaded mySQL connector /net 6.3 (latest one). But when i try to connect mySQL Server it says "there is no support prior to 5.0". I think our mySQL server is version 4.0. How can i connect it?
I have my site in asp.net and my sql server data base. My application is running fine from my local PC. Earlier I was running fine on server also but before some days back, it started showing error "Unable to connect to any of the specified MySQL hosts" on server machine and local is still running fine. I am confused how it is possible when I am using same data base for both local and server. Hope to get any clue.
I started the Bakery site demo...everything runs fine on my local machine.When I publish the site to production server in w2k8r2+iis7.5 and with .net 4.0 (integrate) pool, my bakery apps not able to connect to the .sdf file.
Error I got is :
Connection string "bakery" was not found. Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidOperationException: Connection string "bakery" was not found.
Line 2: Layout = "_SiteLayout.cshtml";
Line 4: FacebookSocialPlugins.Initialize("[xxx]", "[xxx]","bakery");