hi there,

i'm not sure if i'm doing it the right way or not.. but i have the following profile in web.config:

<profile enabled="true">
      <properties>
        <add name="ServiceSessionId" allowAnonymous="true"/>
      </properties>
    </profile>

and i try to assign a value in one of the button click event as follow:

protected void Button2_Click(object sender, EventArgs e)
        {
            
            HttpContext.Current.Profile["ServiceSessionId"] = "Hello World";

        }

but i'm getting an error : "Cannot connect to SQL database" at line "HttpContext.Current.Profile["ServiceSessionId"] = "Hello World";"

can anyone help?

ronald_yoh:

<profile enabled="true">
      <properties>
        <add name="ServiceSessionId" allowAnonymous="true"/>
      </properties>
    </profile>

• Looking at the error implies your profile setting is looking for the data store.

Change your web.config profile setting similar to  below.

<profile defaultProvider="AspNetSqlProfileProvider">
  <properties>
     <add name="Name" />
     <add name="Weight" type="System.Int32" />
     <add name="BirthDate" type="System.DateTime" />
  </properties>
</profile>

You may check various <profile> properties here.

Let me know further Queries.

 Check this .. same issue .

http://forums.asp.net/t/1337875.aspx

hi all.. thanks for your suggestions.. but i haven't really tested what you have suggested due to tight deadline on my projects.. at the moment i'm using the session as the temporary solution and replacement to profile.

i will try what you have suggested and will surely mark as answer if your suggestion is truely what i'm looking for.