Solved

asp.net connection string value lost

Posted on 2007-12-03
7
157 Views
Last Modified: 2013-11-07
I setup my connection string in my web.config.

I have a custom membership provider that defines it in the initialize....
connStr = config("connectionString")

When I call the validateuser(), it hits the connection string okay.

I call the exact same code in my GetUser(), and now my connection string is empty.

both have these at the top:
        Using conn As New SqlConnection(connStr)

What is happening? Why is it now empty for this function?
thanks.
0
Comment
Question by:BobCSD
  • 6
7 Comments
 
LVL 15

Accepted Solution

by:
spprivate earned 500 total points
ID: 20398618
connStr = config("connectionString")
I assume this connstr variable scope is not public or class level.You would have declared it in a method level and hence you are not getting the value.
Declare the connStr initialization on a class level and then use it.
0
 
LVL 1

Author Comment

by:BobCSD
ID: 20398755
It IS class level:

Public Class CustomMembershipProvider
    Inherits MembershipProvider

    Private connStr As String
    Private comm As New SqlClient.SqlCommand
0
 
LVL 1

Author Comment

by:BobCSD
ID: 20398816
I declared it Public and that didn't fix it either.

I do notice stepping through it, that the Initialize is not called on the GetUser. It is called on the ValidateUser, but not the GetUser....

???
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 1

Author Comment

by:BobCSD
ID: 20398842
I take that back. When I log in, it hits the validateuser, but putting a breakpoint on the initialize, I never see it hit that.

Although, the ValidateUser does have a valid connstr.
0
 
LVL 1

Author Comment

by:BobCSD
ID: 20398875
Hmmm. I have old backup copies that are hitting the initialize on log in when I debug, but my latest version is not.

What could be the reason?
thanks.
0
 
LVL 1

Author Comment

by:BobCSD
ID: 20398898
Okay, I notice that when I put code to call my getuser in my pre_init on my master page, it never hits the initialize. I'll have to look at that.

Meanwhile, if anyone has any thoughts, would appreciate it.

thanks.
0
 
LVL 1

Author Comment

by:BobCSD
ID: 20398987
I need to create a new question on this.

My problem is that my initialize is not firing. So I need to ask about that.

thanks.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Summary Displaying images in RichTextBox is a common requirement with limited solutions available. Pasting through clipboard or embedding into RTF content only support static images.  This article describes how to insert Windows control objects int…
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
This video discusses moving either the default database or any database to a new volume.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now