Login problem

arnab-jit · April 21st, 2011, 04:33 AM

When I am trying to login to my planetwrox web site, I am getting this error in web browser.

The database filename can not contain the following 3 characters: [ (open square brace), ] (close square brace) and ' (single quote)

Please help me.

Imar · April 21st, 2011, 04:37 AM

Can you provide more information? How are you browsing to the site? How does your connection string in web.config look? What's the name of the database?

Without information like this, it's hard to tell what's wrong...

Cheers,

Imar

arnab-jit · April 21st, 2011, 06:51 AM

I have a connection string of planetwrox database and in membership this is my code.

Code:

<membership>
<providers>
<clear />
<addname="AspNetSqlMembershipProvider"type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"connectionStringName="LocalSqlServer"enablePasswordRetrieval="false"enablePasswordReset="true"requiresQuestionAndAnswer="true"applicationName="/"requiresUniqueEmail="false"passwordFormat="Hashed"maxInvalidPasswordAttempts="5"minRequiredPasswordLength="7"minRequiredNonalphanumericCharacters="1"passwordAttemptWindow="10"passwordStrengthRegularExpression=""/>
</providers>
</membership>

Imar · April 21st, 2011, 07:19 AM

Quote:

I have a connection string of planetwrox database and in membership this is my code

Since you're having a problem with the connection to the database, posting the connection string might help.

When you post code, can you paste and copy it to Notepad first and then use the Code button (#) on the toolbar? Makes the code easier to read.

Cheers,

Imar

arnab-jit · April 22nd, 2011, 08:16 AM

My connection string area is :

Code:

<connectionStrings>
    <add name="PlanetWroxConnectionString1" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\PlanetWrox.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
  </connectionStrings>

Member ship area :

Code:

<membership>
      <providers>
        <clear/>
        <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" applicationName="/" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="1" passwordAttemptWindow="10" passwordStrengthRegularExpression=""/>
      </providers>
    </membership>
    <authentication mode="Forms"/>

Imar · April 22nd, 2011, 08:25 AM

Is your connection string all on one line in your web.config file?

Imar

arnab-jit · April 22nd, 2011, 08:31 AM

Yes all in one line....

Imar · April 22nd, 2011, 08:53 AM

Then I don't know what's going on.

The only thing I can see is that your connection string is called PlanetWroxConnectionString1, while your providers make use of LocalSqlServer. Maybe the latter one is incorrect (did you make changes to machine.config)?

If this doesn't help, you need to supply *a lot* more information about your set up, how you run the site, where, when and how you get this error and so on. Please be as specific as possible or I can't help you.

Cheers,

Imar

arnab-jit · April 22nd, 2011, 09:05 AM

In the connection string area i have the connection string for my database named planetwrox. But I am having problem with menbership, role, profile, which is maintained by aspnetdb.mdf. It reads by the SqlMembershipProvider from machine.config. I am using this provider not from machine.cofig but from web.config of my application. ASP.NET create this aspnetdb.mdf database when we first try to login. But when I try to login first time it is showing the error.

Now please help me.

Imar · April 22nd, 2011, 09:19 AM

This is still not enough.

Did you modify machine.config? If you look at that file do you see the LocalSqlServer connection string? What code does it contain? Can you see the database being created in App_Data? Do you have a local SQL Server instance called Sql Express?

What happens when you try File | New Web site, throw a CreateUserWizard on a page and try to register for an account? Does that work?

And so on and so forth yadadada

Quote:

Now please help me.

Yiu have to help me help you or I can't help you. I am not psychic so I need information about your system, site and situation....

Imar