ASP.NET

Error in my connection string RSS

5 replies

Last post Dec 24, 2012 07:28 PM by bthumber

‹ Previous Thread|Next Thread ›

- Reply
bthumber

Member

244 Points

669 Posts

Error in my connection string

Dec 24, 2012 12:38 PM|LINK

<connectionStrings>

<add name="EFDbContext" connectionString="Data Source=BRENTHUMBER-PC\SQLEXPRESS;Initial Catalog=SportsStore;Integrated Security=True;Pooling=False;providerName=.Net SqlClient Data Provider" />

</connectionStrings>

Please see the connectionstring above. When I run the program I get this error: The connection string 'EFDbContext' in the application's configuration file does not contain the required providerName attribute."
- Moved by XIII on Dec 24, 2012 12:44 PM
- Reply
adeelehsan

All-Star

18319 Points

2746 Posts
Re: Error in my connection string

Dec 24, 2012 12:45 PM|LINK
Use the following:
```
<add name="EFDbContext" connectionString="Data Source=BRENTHUMBER-PC\SQLEXPRESS;Initial Catalog=SportsStore;Integrated Security=True;Pooling=False;providerName="System.Data.SqlClient" />
```
Please Mark As Answer if it helped.

MCPD ASP.NET 4.0 and 3.5, MCTS WSS, MOSS, SharePoint 2010, MCT
Microsoft Community Contributor Award 2011
- Edited by decker dong - msft on Dec 25, 2012 12:28 AM
- Edited by decker dong - msft on Dec 30, 2012 03:14 AM
- Marked as answer by decker dong - msft on Dec 30, 2012 03:14 AM
- Reply
Shailendra S...

Member

551 Points

145 Posts

Re: Error in my connection string

Dec 24, 2012 02:30 PM|LINK

change providername to System.Data.SqlClinet

Mark as answer if it answered your question.

www.techaray.com
- Reply
bthumber

Member

244 Points

669 Posts
Re: Error in my connection string

Dec 24, 2012 07:15 PM|LINK
Now the error "Missing required whitespace"
```
;providerName="System.Data.SqlClient"
```
red line under providerName and System.Data.SqlClient
- Reply
eric2820

Contributor

2777 Points

1161 Posts

Re: Error in my connection string

Dec 24, 2012 07:25 PM|LINK

Try this:

<add name="some string" connectionString=".....Trusted_Connection=False" providerName="System.Data.SqlClient" />

Eric

http://www.my-msi.net/Admin
blog

If a post helps you, please mark it as Ansered, thank-you.
- Edited by decker dong - msft on Dec 25, 2012 12:28 AM
- Edited by decker dong - msft on Dec 30, 2012 03:14 AM
- Marked as answer by decker dong - msft on Dec 30, 2012 03:14 AM
- Reply
bthumber

Member

244 Points

669 Posts

Re: Error in my connection string

Dec 24, 2012 07:28 PM|LINK

Think you, I just found the solution as I got the email and you are correct.
- Edited by bthumber on Dec 24, 2012 07:29 PM
- Edited by decker dong - msft on Dec 25, 2012 12:28 AM