Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
my.msi.net
Starting Member
3 Posts |
 Posted - 2012-09-21 : 15:46:47
|
| Connection string:"Data Source=GEMSFAMILY\GEMSFAMILY;Initial Catalog=My-MSI.Net;User ID=**********;Password=***********;provideerName=System.Data.EntityClient"What I am getting when I run the site:"The connection string 'EFDbContext' in the application's configuration file does not contain the required providerName attribute."The way things are configured in the Weg.config file are:<configuration> <connectionStrings configSource="App_Data\My-MSI.Private.config" />The connection string provided above is from this file!- Eric www.my-msi.net |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-09-21 : 15:56:23
|
| You have "provideerName=System.Data.EntityClient", should be "providerName=System.Data.EntityClient |
 |
|
|
my.msi.net
Starting Member
3 Posts |
Posted - 2012-09-22 : 06:13:47
|
| Here is the real connection string in context:<connectionStrings> <add name="EFDbContext" connectionString="Data Source=GEMSFAMILY\GEMSFAMILY;Initial Catalog=My-MSI.Net;User ID=***********;Password=***********;providerName=System.Data.EntityClient" /></connectionStrings>There must be something else wrong with this and I know that the user name and password are NOT part of the problem becuase I connect the the DB from VS 2010 with that user name and password!Everything stated in my initial message still applies.- Eric www.my-msi.net |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-09-22 : 06:43:23
|
| The only other suggestion I have to to try ProviderName=SQLOLEDB. |
|
|
|
|
|
|
What is wrong with this connection string?