Skip to main content

Posts

Showing posts from September, 2008

validate email and phone number with Regular Expressions

Here is sample to validate Phone, Email, URL http://www.costudio.com/contactus.asp emailRe = /^\w+([\.-]?\w+)*@\w+([\.-]?\w+)*\.(\w{2} (comnetorgeduintmilgovarpabizaeronamecoopinfopromuseum))$/ phoneRe = /^((\+\d{1,3}(- )?\(?\d\)?(- )?\d{1,5})(\(?\d{2,6}\)?))(- )?(\d{3,4}) (-)?(\d{4})(( x ext)\d{1,5}){0,1}$/ http://javascript.about.com/library/blre.htm Jquery Validation http://bassistance.de/jquery-plugins/jquery-plugin-validation/

install sql server express 2005 to Vista 64

IIS on a 64 bit system runs by default the 64 bit version of the framework and SQL Server express is a 32 bit application so that is what is causing your problem since it needs the 32 bit framework to operate correctly. There are 2 solutions: 1. Install SQL Server 2005 x64 developer edition instead of the express edition. This version however is not free so you will need to purchase a license witch luckily for us is not as expensive as a standard or enterprise license. Or: 2. Click start > run and type: (maybe need make start.bat, and right click to run as administrator) cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1 That will force your IIS to run in 32 bit emulated mode. then again at run or a command prompt type: %SYSTEMROOT%\Microsoft.NET\Framework\v2.0.50727\aspnet_regiis.exe -i To register the 32 bit framework with IIS. After that you should be able to install the larger version (x64) capable of SQL Server Express 2005 without...

Error message when you restore or attach an msdb database or when you change the syssubsystems table in SQL Server 2005

Error message when you restore or attach an msdb database or when you change the syssubsystems table in SQL Server 2005: "Subsystem % could not be loaded" "The Snapshot subsystem failed to load" SYMPTOMS loadTOCNode(1, 'symptoms'); Consider the following scenario. You perform one of the following actions in Microsoft SQL Server 2005: • You restore an msdb backup. • You attach an msdb database. • You change the information in the syssubsystems table in the msdb database. Solution: 1. In SQL Server Management Studio, run the following script.use msdb go delete from msdb.dbo.syssubsystems exec msdb.dbo.sp_verify_subsystems 1 go 2. Stop and then restart the SQL Server Agent service.