Login failed for database user

realkewl · March 31st, 2009, 04:58 PM

Hello,

Today I've just finished up the Administration page and I'm curious to see how this is all shaping up. So I complie and fix any outstanding bugs.

However, now I get a login failure for my database user. I'm using sqlexpress and I've modified the app.config file in the DAL project. However, when I set a break point in the HRPaidTimeOffDataContext I cannot determine where's it's getting the connection string from.

It's showing the ID but not the password

The constructor reads as follows:

Code:

Public Sub New()
MyBase.New(Global.V2.PaidTimeOff.DAL.My.MySettings.Default.HRpaidTimeOffConnectionString1, mappingSource)
OnCreated
End Sub

But the return value is not what's in the config file. Can someone point me in the right direction?

Thanks,
realkewl

varallov · March 31st, 2009, 08:20 PM

The sample that comes with the book expects the connection string to be in the web.config file in the web site project.
The code you're showing is for the default constructor of the DataContext. This would only be called if you didn't pass in the connection string when the DataContext is instantiated.

The sample code passes in the connection string to the constructor using a helper function in the DBHelper class.

Code:

using (HRPaidTimeOffDataContext db = new HRPaidTimeOffDataContext(DBHelper.GetHRPaidTimeOffConnectionString()))

varallov · March 31st, 2009, 08:59 PM

I just noticed a bug on Page 44. The code in the book calls the HRPaidTimeOffDataContext's default constructor but it shouldn't. It should use the following line in the using statement.

Code:

using (HRPaidTimeOffDataContext db = newHRPaidTimeOffDataContext(DBHelper.GetHRPaidTimeOffConnectionString()))

This could be what was causing your problem because instead of looking to the web.config file for the connection string it would be looking at your settings file.

realkewl · April 1st, 2009, 11:02 AM

Thanks that does explain a couple of things. For the moment I just added the connection string to the web.config and it does work. BTW I could not find mention of the DBHelper class in Chapter 2, however I did find the class in your source code in chapter 4.

-realkewl

andres.gonzalez · June 18th, 2009, 05:34 PM

hello
I had the same problem and solved it as follows.
code in the web.config

Code:

<connectionStrings>
    <add name="HRPaidTimeOffCON" connectionString="Data Source=LAPTOP\SQLEXPRESS;Initial Catalog=HRPaidTimeOff;User ID=sa;PASSWORD=XXXXXXX;Pooling=False"/>
  </connectionStrings>

and the code-behind:

Code:

HRPaidTimeOffDataContext db = new HRPaidTimeOffDataContext(ConfigurationManager.ConnectionStrings["HRPaidTimeOffCON"].ToString());

The key is to call the connectionstring (with the correct name) and use the ConfigurationManager.connectionStrings. I try to use DBHelper, and was impossible.