Archive for March, 2012

Command to Get Exchange Server Version

Open power Shell and execute the command

C:\>Get-ExchangeServer

How to Change the Date Format for Windows 2003 or Windows 2008 from Registry.

You will usually face problem on Windows 2003 Server or Windows 2008 Server that even if you change the Date format from the regional and Language options from the control panel , the changes made do not reflect. Do not worry , you can do it from the registry .

Goto Start run and type regedit , HKEY_USERS =>.DEFAULT=>Control Panel => International and change the sShortDate to MM/dd/yyyy or the format you want . Now you need to reboot the server .


Display the Contents of MSSQL database on your website using ASP.NET

Hello ,

Here I will explain the steps to connect to a database using a Data Source Name (DSN)

1) Lets assume that you have a MSSQL database with Your data in it . Give the database user db_owner, db_datareader and db_datawriter permission.

2) Create DSN from start==>programs==>administrative tools==>data sources==>system dsn==>
add ==> Select SQL server and click finish. A wizard will be opened , put in the DSN name lets name it datasource , the sql server which you want to connect to , Click Next select the option With SQL server authentication using a login ID and password entered by the user . Click next,next and finish the DSN creation wizard .

3) The DSN will be used in our script to connect to the database . Create a ASP file under you website root folder say displaydata.asp and use the following VBscript which is the default language of ASP.NET

(adsbygoogle = window.adsbygoogle || []).push({}); //--> Feedjit Flag Counter