2006-12-19

Users Changing ASP.NET Theme

Man i really like codeproject, its articles are awesome.

Is DTS dead?

I was writting some scripts to move/copy databases for my releasing program for mssql 2000, but then couldnt find that many up-to-date resources. It seems there is a new tool for 2005 called SSIS.
http://msdn2.microsoft.com/en-us/library/ms141026.aspx

But i did find some links about how to create a basic DTS file, possibly that could be run from the command line.
http://www.15seconds.com/Issue/030909.htm

And then what files i would need on the running server
http://www.sqldts.com/default.aspx?225

Webservice Envelope Validation

How do you do that, this article explains.

I have got a extension that just logs soap packets, so its not too hard to plug the validator into that.

ASP.NET 1.1 and 2.0 Working Together

Is this possible on a shared provider, i dont think so, but its good for self managed.

SVN Externals No Good

After much work using svn externals for internal class libraries i have come to the realisation that they should not be used for this.

http://www.brunningonline.net/simon/blog/archives/002031.html
http://svn.haxx.se/dev/archive-2003-07/1617.shtml

A few other people tend to agree, or have found the smae problems that i have.
Its just a nightmare to try and manage them.
I'm actually starting to think that no software configuration information should be stored in the svn repository and that should be maintain by an outside program.

More Automated Software Process

I have been using cc.net for a while and its great, but then when i want to do more things, like scripted releases / packages / branching, i dont have a complete tool.
There is maven and lunt build, but both are written in java. And i think they are more similar to cc.net then the linked tool.
If i can't find one written in .net, i might have to build one. A little bit of effort here saves both time and hassel in the future thats for sure.

Server backgrounds

You know how you can have the windows build number and OS version appear on your desktop with a reg setting, what do you do if you want more details. You use this tool, it is awesome on servers where you can then just look at the desktop to see what machine you have connected to. Especially when you are connected to more than one at a time.

SQL XML Not Required

I was under the impression that you had to have the sqlxml component installed to use the feature where xml is returned from a t-sql query. I was using the connection string like this:

var objConn = new ActiveXObject("ADODB.Connection");
//Provider=SQLXMLOLEDB.3.0;Data Provider=SQLOLEDB
var objComm = new ActiveXObject("ADODB.Command")
objComm.ActiveConnection = objConn
objComm.CommandText = tSQL
var objStream = new ActiveXObject("ADODB.Stream")
objStream.Open()
objComm.Properties("Output Stream") = objStream
objComm.Execute(null, null, 0x400)
objStream.Position = 0

This turns out not to be the case, you can use this as the connection string:
//Provider=SQLOLEDB;Data Provider=SQLOLEDB
And then you dont need to install the extra component, good for shared hosting!

Handling Nulls in Webservices

I think i will start using this blog to remember what i have learn and so i can always come back to it if i forget about it.

So this was where if nulls are passed into a .net 2.0 webservice, then the elements are removed from the soap envelope that is sent.