error:"Format of the initialization string does not conform to specification starting at index 0"

Question

_{Monday, April 11, 2011 12:00 PM}

I have an ASP.Net MVC application which runs fine on my local development machine. But when deployed to IIS7 gives the following error when trying to log in:

"Format of the initialization string does not conform to specification starting at index 0"

My connection string on the local and deployed application are the same. The connection string is like this:

<connectionStrings><add name="MyEntities" connectionString="metadata=res://*/Models.Model1.csdl|res://*/Models.Model1.ssdl|res://*/Models.Model1.msl;provider=MySql.Data.MySqlClient;provider connection string="server=127.0.0.1;User Id=webmaster;Persist Security Info=True;database=kellookdb"" providerName="System.Data.EntityClient" /></connectionStrings></configuration>

All replies (2)

_{Thursday, April 21, 2011 5:31 AM ✅Answered}

Hi,

Thanks for reply

I found the solution here:

http://msdn.microsoft.com/en-us/library/dd465342.aspx

 

---

_{Wednesday, April 13, 2011 10:08 PM}

Hi:)

Please try to remove """ in your connection string or just modify it to a single quote ——'

Thx