'multipleactiveresultsets' Keyword Not Supported

I am trying to read from an SQL Server database which is hosted on MS Azure, through an ASP.NET WebForms website, created in Visual Studio 2013.

I've stored the connection string in Web.Config, and have referenced it in the Code-Behind.

However, when I try to run Default.aspx, the below error is displayed:

Additional information: Keyword is not supported: 'multipleactiveresultsets'.

Here is my Web.Config:

        <add name="FYPConnectionString1" connectionString="Data Source=damo.database.windows.net,1433‌​;Initial Catalog=Ballinora_db;
             Persist Security Info=False;User ID={username};Password={password};MultipleActiveRe‌​‌​sultSets=False;Enc‌​ry‌​pt=True;
             TrustSer‌​verC‌​ertificate=Fal‌​se;Con‌​nection Timeout=30;"
             providerName="System.Data.SqlClient" />

        <compilation debug="true" targetFramework="4.5" />
        <httpRuntime targetFramework="4.5" />

I removed "MultipleActiveResultsSets=False" from the Connection String to see if the error stopped, but instead, the error now displays for "Encrypt".

So the error is appearing for the next item after the Password part of the connection string. Would the password have anything to do with the problem?

Also, this username and password which are required, are they the Server Admin Login details which appear in the Azure portal?

If not, then can anyone please help me try and fix this issue?

0 answers