Last post Apr 12, 2015 03:59 PM by JohnBert
Apr 08, 2015 07:43 PM|Heathcote|LINK
I used the same connection string for navicat to so that I could put the database onto azure, I have now connected to that database in webmatrix, I've tried to publish the site but I am getting "Unable to publish site because of missing database connection
strings in Publish Settings."
I have checked the connection settings inside web.config and everything looks ok to me.
EDIT: I've deleted a local database which just contained the same files as which were on the azure server, is this local database important or can I just create a connection string with php and display files.
Apr 09, 2015 03:59 AM|Mikesdotnetting|LINK
Is your site a PHP Site?
Apr 12, 2015 03:59 PM|JohnBert|LINK
Change your web.config file to include
as an attribute on the connection string like this and also do check this link
<add name="ConnString" connectionString="Data Source=IP_OF_SERVER,PORT; Initial Catalog=DATABASE_NAME; UID=USERNAME; pwd=PASSWORD; Integrated Security=True;" providerName="System.Data.SqlClient" />
Another Example:<connectionStrings><clear/><add name="LocalSqlServer" connectionString="Data Source=remotehost;Initial Catalog=remoteDB;User Id=username;Password=password" providerName="System.Data.SqlClient" /></connectionStrings>