Dude that is cool.

vbboyd · May 16th, 2011, 05:35 PM

Code:

I am currently doing the password control of your book and I have to tell you, honesty, (as much as I hate to admit it) that this stuff is really neato-fleato cool. I can remember all those years writing classic ASP working for the Police Department at City Hall having to write all those login pages by hand having to write a login control by hand that checked the USERID and Password against a SQL Server database and getting the person's authorization level and assigning it to a session object. We couldn't use cookies because the security levels at the police department were put pretty high because of the top secret information on our systems so no cookies were allowed so I was forced to use session objects or to store them in the SQL server database. Anyway, I can remember the pains I had to go to write that code and to make the security features work out so that it was pretty top-secret air tight. What a major league pain that was. I spent nearly thirty percent of my time just writing and keeping security code up to date. With the new stuff in ASP.NET that is all taken away and it is pretty simple and straight forward to do. I know that sounds strange coming from a coder-lover-digger like myself. But if I had this back then what I have now. Boy would my life have been much easier.
PS
While I have you here. I was just wondering I have a SQL Server question to ask of you. I am guessing that you are probably not a SQL Server guru or whatever but I just have to ask..... I have Visual Studio 2010 Professional and it has a SQL Server Express-2008. I would really like to know why I can't launch the SQL Server Management Studio? I look around and there is no icon in the programs section of window to launch like I had in SQL Server 2005. I would really like to use the SQL Server Management Studio as it would make my life a lot easier, is there any way that I can get that to run on my box? Thank you very much.

Imar · May 17th, 2011, 07:33 AM

Quote:

We couldn't use cookies because the security levels at the police department were put pretty high

In Classic ASP, Session state was managed with cookies as well. The server keeps track of the data, associated with a client side cookie.

Anyway, yes, the Login controls are great. This is the part where "ASP.NET makes the hard things easy".

Quote:

I would really like to know why I can't launch the SQL Server Management Studio?

Take a look at the introduction of the Try It Out on page 424 and at Appendix B.

Imar

vbboyd · May 17th, 2011, 09:38 AM

Yes it is true Classic ASP handeled cookies well but because they were Police Department computers, they were required to disable all cookies on their machines due to security precautions. They didn't want anybody storing anykind of information on their machines, that could be used later to maybe spy on people at the Police Department. Too much top secret classified information on criminal investigations that might could get out later. Or so that is what I was told.

Imar · May 17th, 2011, 09:45 AM

Yes, I understand. But what I said was that if you were using Session state, you *were* using cookies, as Session state in classic ASP relies on cookies....

Imar

vbboyd · May 17th, 2011, 09:47 AM

Yes I see that. I use that all the time. I want to be able to launch the SQL Server Express Management studio outside the Visual Studio Environment as a stand alone application. I plan on getting up to speed with Analysis services with data marts for SQL Server 2008 and I also plan to add users and give them permissions to the database, and I want to run backups and recoveries, and do some SSIS stuff as well. Currently I can't do that just in the Visual Studio environment alone. At least I am not sure how to do it that way. Also......There is some really cool data that I would like to import via DTS/SISS that I want to add to the database to enhance your application and I don't have a way other than through the Visaul Studio environment in which to do that right now. I would love to have my old SQL Server Management Studio back again to do some of those things like in the past.

Imar · May 17th, 2011, 09:53 AM

Quote:

SQL Server Express Management studio outside the Visual Studio Environment as a stand alone application

You can do that if you installed SSMS Express edition using the Web Platform Installer.

Some of what you mention is supported by the free Expression edition of SSMS. For the other things you mention you need to get a full version of SQL Server. A good (and cheap) option is probably the SQL Server Developer Edition.

Cheers,

Imar

vbboyd · May 17th, 2011, 10:01 AM

Quote:

Originally Posted by Imar

Yes, I understand. But what I said was that if you were using Session state, you *were* using cookies, as Session state in classic ASP relies on cookies....

Imar

Hmmm........
Now that I think back on it, I think I was probably putting the user information in hidden fields not session state and passing the information when I would post to the other webform whenever they would click a link or a button. I know I had to figure some cludge to get around that issue. Anyhow I forget it was nearly 10 years ago and I haven't touched classic ASP in at least legnth of time.

vbboyd · May 17th, 2011, 10:03 AM

Quote:

Originally Posted by Imar

You can do that if you installed SSMS Express edition using the Web Platform Installer.

Some of what you mention is supported by the free Expression edition of SSMS. For the other things you mention you need to get a full version of SQL Server. A good (and cheap) option is probably the SQL Server Developer Edition.

Cheers,

Imar

I have that cheap version you refer to. Can I install it with SQL Server/Express running on the same box? Or will it mess things up?
PS Any service packs I need to add before I install for windows 7 for SQL Server/ Developer Edition?

Imar · May 17th, 2011, 10:10 AM

Yes. They are all designed to run side by side.

BTW, no need to quote the entire previous message when replying

Imar

vbboyd · May 17th, 2011, 10:16 AM

I tried to do quick reply and when I click the button I get a message box it says you must select one of the icons up above to install quick reply for this message. I am all new to this forum. Maybe you tell me how to do quick replies or tell me what I am doing wrong.