Connection error message: keyword not supported: 'initial catalog'
The error occurs in the Global.asax file at the following line:
WebSecurity.InitializeDatabaseConnection("Action", "Member", "MemberId", "Email", autoCreateTables:= True)
Let me say that so far I've made a couple of changes to the web.config file after reading the material in 'Getting Started' and also 'Patterns in Action 4.5'. These changes are:
<add name="Action" connectionString="Data Source=myServerName;Initial Catalog=Action;User ID=myUID;Password=myPWD"/>
(I've changed the actual values, but you get the idea!)
I've also changed the <app settings> tag to the following:
<add key="DataProvider" value="ADO.NET" />
Firstly, I'm not sure if I should also be changing the settings for the 'ActionEntities' connection string and if so what to.
Secondly, I'm fairly certain I was getting the same error message even before I made any changes. Can someone help?
MAI Joomun, Feb 10, 2014
Here is a post with a similar error message: http://stackoverflow.com/questions/8150737/asp-net-mvc3-connection-string-keyword-not-supported-initial-catalog
In their case it was the data provider that was the problem. t would think that that is also the case here:
-First see if adding 'providerName="System.Data.SqlClient" to your connection string solves your problem.
-Secondly try changing the data provider from 'ADO.NET' to "Ado.Net" (although from what I remember case does not matter).
Hope this gets you going.
Jack Poorte, Feb 11, 2014