Network Programming in .NET

If you don’t have the origional installation disk for Visual Souce Safe, but have it installed somewhere. You can still integrate it with Dreamweaver and VS.NET, by following the steps:

1. Copy the VSSWin32 folder to your local hard drive

2. Run Regsvr32 on SSSCC.DLL, SSAPI.DLL and NLHTML.DLL

3. Run SSINT.Exe

Although it’s a hack, I just figured out how to install IIS on XP Home. With the help of these two urls.

http://www.iis-resources.com/modules/AMS/article.php?storyid=48

and

http://www.webthang.co.uk/tuts/tuts_server/iis_xph/pippo_xp.asp

I did hit two problems, one was that it came up with an error "The Specified Module Could not be found" – This is fioxed by opening the IIS snap in, properties > Directory Security > Anonymous access > edit > then uncheck "Allow IIS to control password".

Then, to install .NET, I used aspnet_regiis.exe -i

———-

As an experiment, I tried to get .NET beta 2 to install aswell,but I got this error in the event log

Often, when you work on a large scale database-driven application, you end up with hundreds of stored procedures. As the project evolves, the stored procedures get modified over time, and you often loose older versions of stored procedures.

Although there are many ways to provide stored procedure version control, I opted for a simple approach.

If you have a stored proc called MyProc, before editiing it, create a new procedure called MyProc;2. then edit MyProc (which I shall refer to as MyProc;1 for clarity).

When you call exec MyProc, then MyProc;1 will be executed. and MyProc;2 will not appear in any lists of stored procedures in Enterprise manager or Query Analyser.

To view the source of an older version of a stored proc, you can no longer use sp_helptext, but you can say "select text from syscomments where
id=(select id from sysobjects where name=’myProc’)
AND NUMBER=2"

Just noticed that Google UK is going through it’s reshuffle / pruning phase tonight. I’ve seen certain sites rapidly move positions under successive searches for the same keyword, and a large pruning of unscanned pages. (pages whoose link has been indexed, but not the content of the page).

Also a little interesting discovery. Ever notice the BIW parameter in a Google search. It’s your browsers width in pixels. – I thought it was a session id….

When using a httpWebRequest to a page, with an attached Cookie container, you may find sometimes that the Cookie is set with the wrong path, for instance /cgi-bin/process.cgi rather than cgi-bin/ – This may make the cookie unreadable to other pages within that folder.

Fear not, the solution is simple

Dim cA As Cookie
Dim ccS As CookieCollection
ccS = RequestCookies.GetCookies(New Uri(http://www.someuri.com/cgi-bin/process.cgi"))
cA = ccS.Item(0)
cA.Path = "/cgi-bin"
RequestCookies.Add(cAuthID)

RequestCookies being a Cookie Container object.