Archive
Sage data objects
C# Library for ZIM
Running a block of SQL files sequentially
cls
echo Databse installation utility
echo ——————————————
echo Useage: InstallDB [server] [database name]
for %%1 in (*.*) do osql -S %1 -E -d %2 -i %%1 -n
Microsoft.XMLHTTP to the rescue
{
var xmlhttp=false;
/*@cc_on @*/
/*@if (@_jscript_version >= 5)
// JScript gives us Conditional compilation, we can cope with old IE versions.
// and security blocked creation of the objects.
try {
xmlhttp = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try {
xmlhttp = new ActiveXObject("Microsoft.XMLHTTP");
} catch (E) {
xmlhttp = false;
}
}
@end @*/
if (!xmlhttp && typeof XMLHttpRequest!=’undefined’)
{
xmlhttp = new XMLHttpRequest();
}
try
{
xmlhttp.open("GET", "http://<alternative URL>/" + url,true);
win=window.open();
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4)
{
win.document.write(xmlhttp.responseText);
}
}
xmlhttp.send(null)
}
catch(e2)
{
// The browser doesn’t support XMLHTTP.
window.open(url);
}
}
Help!. Can’t reopen a page whilst another is loading…
<%
for (int i=0;i<1000;i++)
{
System.Threading.Thread.Sleep(100);
Response.Write(i + "…");
Response.Flush();
}
%>
Barcode reading webservice
Clipboard ring in Visual studio .NET
Integrating VSS witn Dreamweaver and VS.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
Installing IIS on XP Home
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
Exception: System.NullReferenceException
Message: Object reference not set to an instance of an object.
StackTrace: at System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters)
at System.Web.Hosting.ApplicationManager.CreateAppDomainWithHostingEnvironment(String appId, IApplicationHost appHost, HostingEnvironmentParameters hostingParameters)
at System.Web.Hosting.ApplicationManager.CreateAppDomainWithHostingEnvironmentAndReportErrors(String appId, IApplicationHost appHost, HostingEnvironmentParameters hostingParameters).
Stored Procedure version control
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"
Network Programming in .NET 