Hosting and the web.config file, connection string for Entity

Imar · August 22nd, 2012, 10:33 AM

Quote:

Is it required to configure the profile and roleManager settings?

If you use them, then yes.
Take a look at this:

Code:

 
 <roleManager enabled="true" />

You haven't changed the connection string for the role provider. Take a look at page 774 for the proper configuration code.

Cheers,

Imar

jdlferreira · August 22nd, 2012, 10:50 AM

Cheers Imar, fully working now. I'm sorry to bother you with all these stupid questions... you're an ace dude.

Imar · August 22nd, 2012, 10:55 AM

No problem. That's why you bought a Beginner's book, didn't you? ;-)

Imar

tommein · November 9th, 2012, 02:58 PM

Hi
I am having trouble with the connection string for Entities (see strings below)

Code:

<connectionStrings>
    <add name="ConnectionString" connectionString="Server=ATLAS-SQL-07; Database=carhirechaniacom_968718_db2; User Id=ucar_968718_0002; Password=MariaLena45;" providerName="System.Data.SqlClient"/>

    <add name="carsEntities" connectionString="metadata=res://*/App_Code.CarHire.csdl|res://*/App_Code.CarHire.ssdl|res://*/App_Code.CarHire.msl;provider=System.Data.SqlClient; provider connection string =Server=ATLAS-SQL-07; Database=carhirechaniacom_968718_db2; User Id=ucar_968718_0002; Password=MariaLena45; MultipleActiveResultSets=True" providerName="System.Data.EntityClient" />
    
  </connectionStrings>

Visual studio says that the 'database' keyword is not supported in the Entity Data Model and that part of the website does not function. What am I doing wrong?
Thank you

Ian Ryder · November 10th, 2012, 01:01 AM

Hi,

I can recognise a 123-Reg config string any day of the week. You have missed the quote characters in your connection string. Try this:-

Code:

  <add name="carsEntities" connectionString="metadata=res://*/App_Code.CarHire.csdl|res://*/App_Code.CarHire.ssdl|res://*/App_Code.CarHire.msl;provider=System.Data.SqlClient; provider connection string =&quot;Server=ATLAS-SQL-07; Database=carhirechaniacom_968718_db2; User Id=ucar_968718_0002; Password=MariaLena45; MultipleActiveResultSets=True;&quot;" providerName="System.Data.EntityClient" />

Hope that helps.

Cheers,

Ian

N.B. For your own data security, do not post your passwords to a public forum. You are just asking for trouble!

tommein · November 10th, 2012, 01:12 AM

Thanks Ian
I was trying it with double quotes, but Visual Studio did not like it, then I tried it with single quotes for the string and it worked. Thank you for taking the time to reply.

Ian Ryder · November 10th, 2012, 01:19 AM

No Problem,

I just noticed that you were not the originator of the thread and I need to ask you a question. I will therefore start a new thread in the ASP General Discussion forum. Can you please read and respond if you can.

Cheers,

Ian