Missing required whitespace from connection string in Web.config

Question

My connection string looks like the following:

<add name="RaiseFantasyLeagueConnectionString" connectionString="Server=ATLAS-SQL-07;Database=Raise;MultipleActiveResultSets="True" User Id=***; Password=*******/>

I am getting an error on MultipleActiveResultSets="True" saying

Missing Required Whitespace.

Can anyone suggest what I am doing wrong?

The highlighting here on SO tells you the answer. – Tim Schmelter Apr 01 '13 at 21:24 — Tim Schmelter, Apr 01 '13 at 21:24

Brian Rogers · Accepted Answer · 2013-04-01T21:34:11.637

This connection string has multiple problems.

The True value in MultipleActiveResultSets=True should not be quoted
There should be a semicolon after MultipleActiveResultSets=True
There should be a closing quote after the password.

Try it like this:

<add name="RaiseFantasyLeagueConnectionString" connectionString="Server=ATLAS-SQL-07;Database=Raise;MultipleActiveResultSets=True;User Id=***;Password=*******"/>

score 0 · Answer 2 · answered Apr 01 '13 at 21:37

0

Put a semicolon

MultipleActiveResultSets="True"; User Id=
                               ^
                               |

answered Apr 01 '13 at 21:37

abatishchev

98,240
88
296
433

Missing required whitespace from connection string in Web.config

2 Answers2