"Unable to connect to SQL Server database" error when using profile

Peter Afonin

Hello,

I'm using CreateUserWizard control in ASP.NET 2.0. I'm storing the data in
SQL Server 2005.

The first and last steps run smoothly without any problems. But I added one
middle step to collect some other information from the user. I've added this
to Web.config:

<profile>
<properties>
<add name="FirstName" />
<add name="LastName" />
<add name="Country" />
<add name="City" />
<add name="Email2" />
</properties>
</profile>

Then I try to collect this data:

Protected Sub cuzGudzon_FinishButtonClick(ByVal sender As Object, ByVal e As
System.Web.UI.WebControls.WizardNavigationEventArg s) Handles
cuzGudzon.FinishButtonClick
Try
With Profile
..FirstName = Me.txtFirstName.Text
..LastName = Me.txtLastName.Text
..Country = Me.txtCountry.Text
..City = Me.txtCity.Text
..Email2 = Me.txtEmail2.Text
End With
Catch ex As Exception
Me.lblError.Text = ex.Message
Finally
End Try
End Sub

This is where I get an error: Unable to connect to SQL Server database

Aparently, the connection string I specified in Web.config is correct, since
the first step where the user creates a user name and password runs without
any problems, and the data is entered into the database. Am I missing
something in this additional step?

I would appreciate your help.

Thank you,

--
Peter Afonin

Oct 8 '06 #1

Cowboy \(Gregory A. Beamer\)

Make sure you have set up the Profile to use the proper connection string.
Membership and Profile are two completely separate sections in the
web.config. Same is true for Roles. While this may seem counter intuitive,
the reason for this is flexibility, as you might want to include the default
membership, but custom profile and role providers. You can do this with a
simple config change (and code to support the custom elements, of course).

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com/

*************************************************
Think Outside the Box!
*************************************************
"Peter Afonin" <pa*****@hotmail.comwrote in message
news:ua**************@TK2MSFTNGP04.phx.gbl...

Hello,

I'm using CreateUserWizard control in ASP.NET 2.0. I'm storing the data in
SQL Server 2005.

The first and last steps run smoothly without any problems. But I added
one middle step to collect some other information from the user. I've
added this to Web.config:

<profile>
<properties>
<add name="FirstName" />
<add name="LastName" />
<add name="Country" />
<add name="City" />
<add name="Email2" />
</properties>
</profile>

Then I try to collect this data:

Protected Sub cuzGudzon_FinishButtonClick(ByVal sender As Object, ByVal e
As System.Web.UI.WebControls.WizardNavigationEventArg s) Handles
cuzGudzon.FinishButtonClick
Try
With Profile
.FirstName = Me.txtFirstName.Text
.LastName = Me.txtLastName.Text
.Country = Me.txtCountry.Text
.City = Me.txtCity.Text
.Email2 = Me.txtEmail2.Text
End With
Catch ex As Exception
Me.lblError.Text = ex.Message
Finally
End Try
End Sub

This is where I get an error: Unable to connect to SQL Server database

Aparently, the connection string I specified in Web.config is correct,
since the first step where the user creates a user name and password runs
without any problems, and the data is entered into the database. Am I
missing something in this additional step?

I would appreciate your help.

Thank you,

--
Peter Afonin

Oct 8 '06 #2

Peter Afonin

Thank you, Gregory,

This was a main problem - I couldn't find any example on how to do this.
Finally figured this out:

<profile defaultProvider="GudzonProfileProvider">
<providers>
<add name="GudzonProfileProvider"
type="System.Web.Profile.SqlProfileProvider" connectionStringName="Gudzon"/>
</providers>
<properties>
<add name="FirstName" />
<add name="LastName" />
<add name="Country" />
<add name="City" />
<add name="Email2" />
</properties>
</profile>

Peter

"Cowboy (Gregory A. Beamer)" <No************@comcast.netNoSpamMwrote in
message news:%2****************@TK2MSFTNGP04.phx.gbl...

Make sure you have set up the Profile to use the proper connection string.
Membership and Profile are two completely separate sections in the
web.config. Same is true for Roles. While this may seem counter intuitive,
the reason for this is flexibility, as you might want to include the
default membership, but custom profile and role providers. You can do this
with a simple config change (and code to support the custom elements, of
course).

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
http://gregorybeamer.spaces.live.com/

*************************************************
Think Outside the Box!
*************************************************
"Peter Afonin" <pa*****@hotmail.comwrote in message
news:ua**************@TK2MSFTNGP04.phx.gbl...

>Hello,

I'm using CreateUserWizard control in ASP.NET 2.0. I'm storing the data
in SQL Server 2005.

The first and last steps run smoothly without any problems. But I added
one middle step to collect some other information from the user. I've
added this to Web.config:

<profile>
<properties>
<add name="FirstName" />
<add name="LastName" />
<add name="Country" />
<add name="City" />
<add name="Email2" />
</properties>
</profile>

Then I try to collect this data:

Protected Sub cuzGudzon_FinishButtonClick(ByVal sender As Object, ByVal e
As System.Web.UI.WebControls.WizardNavigationEventArg s) Handles
cuzGudzon.FinishButtonClick
Try
With Profile
.FirstName = Me.txtFirstName.Text
.LastName = Me.txtLastName.Text
.Country = Me.txtCountry.Text
.City = Me.txtCity.Text
.Email2 = Me.txtEmail2.Text
End With
Catch ex As Exception
Me.lblError.Text = ex.Message
Finally
End Try
End Sub

This is where I get an error: Unable to connect to SQL Server database

Aparently, the connection string I specified in Web.config is correct,
since the first step where the user creates a user name and password runs
without any problems, and the data is entered into the database. Am I
missing something in this additional step?

I would appreciate your help.

Thank you,

--
Peter Afonin

Oct 8 '06 #3