Ammars' IT Blog

Moved my blog to Wordpress

2010-12-29T15:50:00.001+09:00

Guys, i have moved my blog to http://ammarfassy.wordpress.com/

MCTS : BizTalk Server 2006

2010-12-21T02:19:00.001+09:00

Well i sat for the MCTS 70-235 (Developing Business Process and Integration Solutions using Microsoft BizTalk Server 2006) exam yesterday and glad to inform that i have passed. mmm.. with regard to the paper, most of the questions were related to BAM, BRE, deploying a BizTalk application, debugging BizTalk applications (ex: debugging orchestration, etc), some of them related to schema creation (ex: minoccurs, validating a schema, etc), role links and general BizTalk questions.

Before sitting for the exam just go through the sarvanas’ preparation diary. It helped me a lot in addition to the following Apress and Wrox eBooks :

BizTalk 2006 Recipes - A Problem-Solution Approach - Mark Beckner, Benjamin Goeltz, Brandon Gross,
Brennan O’Reilly, Stephen Roger, Mark Smith,
and Alexander West
Foundations of BizTalk Server 2006 - Daniel Woolston
Wrox Professional BizTalk® Server 2006
- Darren Jefford, Kevin B. Smith, Ewan Fairweather

hope i can use the following image. :)

Rule "Reporting Services Catalog Database File Existence" failed

2010-11-04T18:22:00.001+09:00

Due to some reason i had to reinstall the SQL Server 2008 and when setup validates the installation it prompted for following 2 errors as below :

Rule "Reporting Services Catalog Database File Existence" failed
Rule "Reporting Services Catalog Temporary Database File Existence" failed.

so what you have to do is to delete following files

ReportServer.mdf
ReportServer_log.LDF
ReportServerTempDB.mdf
ReportServerTempDB_log.LDF

from the location : C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA and re-run the setup.

Error: This row already belongs to another table

2010-07-26T16:12:00.001+09:00

I came across a situation where i had to loop through one of the DataTable and to import the same data into another datable where the data order is different. I was trying to do it but the data is not getting copied to the new DataTable. What I have found out is that you can’t just add rows from one DataTable to another. Initially the table structure must be Cloned and then the rows has to be imported. Cloning the DataTable clones the structure including all DataTable schemas and constraints.

DataTable newTable = new DataTable("Sorted");

newTable = transactionHistoryTable.Clone();
for (int j = transactionHistoryTable.Rows.Count - 1; j >= 0; j—)
{
newTable.ImportRow(transactionHistoryTable.Rows[j]);
}

_dsResponse.Tables.Add(newTable);

as a summary what i am doing is, initially the data what i have is some data in some order which was populated from AS400 API. I need the same data other way around, bottom to top (For ex: transactionHistoryTable has some data and i need to traverse it back).

Failed to connect to the SQL database 'SSODB' on SQL Server

2010-07-14T19:31:00.001+09:00

When you tried to configure BizTalk after the successful installation, if you prompted for an error like the one mentioned above, Execute the following command in Visual Studio command prompt.

explore to the following folder:

C:\Windows\Microsoft.NET\Framework64\v2.0.50727>

and run the following command :

RegAsm.exe "C:\Program Files\Common Files\Enterprise Single Sign-On\SSOSQL.dll"

Note : As i am using the Windows 2008 R2 Server, i had to explore to the Framework64 folder.

Calling AS400 RPG Programs using C#

2010-05-30T16:38:00.001+09:00

Throughout last few months i had a chance to work with AS400, Equation APIs. The purpose of these equations calls are that we have to develop WCF services on top of these API calls. These calls will be consumed by the BizTalk. Initially it was too hard as i couldn't find any resources online. When i searched in gOOgle about the errors which come across at the time of developments, it does not return anything! It was some hard times and thank for my team lead for helping out on those situations. Hope to write something about AS400, C# in coming days…

Here is the lovely interface of Equation.

As the starting point refer following links :

http://www.netsplore.com/PublicPortal/Default.aspx?tabid=246

http://www.netsplore.com/PublicPortal/Blog/tabid/284/EntryID/13/Default.aspx

Error 4201: The instance name passed was not recognized as valid by a WMI data provider

2010-04-15T15:24:00.001+09:00

I was unable to start the Windows Event Log service on Local Computer. When i tried to start the windows event log service was getting “Windows could not start the Windows Event Log service on Local Computer. Error 4201: The instance name passed was not recognized as valid by a WMI data provider.”

This happened at the time of installing MOSS 2007 in my Windows Server 2008 R2 Server machine. Totally i was gone mad coz MOSS 2007 uninstallation crashes due to some reason and was unable to find out the error due to Eventlog crash (what a hell).

Finally figured it out it was due to some permission problem and i had to apply the SYSTEM user with full control on the folder c:\windows\system32\logfiles\wmi\RTbackup. This solved my problem and the lovely event log was working fine as usual.

more details

Another alternative way is there to renaming the RTBackup file. I didnt try that method hence i have to start the machine in safe mode. It will be a headache at all. so for anyone needs to know about that solution please refer this link.

System.IO.FileNotFoundException on "SPSite = new SPSite(url/IP)"

2010-04-14T15:28:00.001+09:00

The below code snippet describes the way to insert user profile data into the SharePoint user profile store. At the time of running the code i came across the above said error. I was googling nearly for 1 1/2 days to figure out the problem. I was trying so many options to solve this problem and nothing worked fine. So finally figured it out its due to some permission problem with the application pool. The application pool identity account should be a domain administrator account which has full access (in other words it should be the same identity like the identity account of the MOSS application pool). details

that account should have following permissions:

The account should be a server farm administrator.
The account has permissions to access the content database.
The account is a site collection administrator.
The account should have permission to access the Windows SharePoint Services site or the SharePoint Server 2007 site through which the code iterates.

by the way when i was reading through some of other blogs they have mentioned its due to 32/64 bit version. i tried that solution too and it didn't work for me. you can read more about this via this link.

string strSharePointSite = @"http://NQ02WBIZWS1";
using (SPSite site = new SPSite(strSharePointSite))
{
    Microsoft.Office.Server.ServerContext context = ServerContext.GetContext(site);
    UserProfileManager profileManager = new UserProfileManager(context);
    UserProfile newUserprofile = null;
    string sAccount = @"domainname\username";
    if (!profileManager.UserExists(sAccount))
    {
        UserProfile profile = profileManager.CreateUserProfile(sAccount);
        if (null == profile)
            textBox1.Text = "Failed to Create User with account :" + sAccount.ToString();
        else
            textBox1.Text = "UserProfileHandler.CalltotheWebService ... User profile created. ...";
    }
    else
    {
        textBox1.Text = "UserProfileHandler.CalltotheWebService ... User profile already exists...";
    }
    newUserprofile = profileManager.GetUserProfile(sAccount);
    newUserprofile[PropertyConstants.Title].Value = "Mr.";
    newUserprofile[PropertyConstants.FirstName].Value = "First Name";
    newUserprofile[PropertyConstants.LastName].Value = "Last Name";
    newUserprofile[PropertyConstants.Department].Value = "IT";
    newUserprofile.Commit();
}

please refer something about access mappings because it will help in some way.

Value cannot be null. Parameter name: serverContext

2010-04-05T19:23:00.001+09:00

If you are getting the error “Value cannot be null. Parameter name: serverContext”, as the first step please make sure that you have configured your Shared Services properly and its running.

New look for MSDN

2010-04-01T14:38:00.001+09:00

Seems Microsoft has changed the MSDN look and now it looks nice and loads faster compared to the old one.

Enterprise Library 5.0 Beta1

2010-03-18T18:19:00.002+09:00

I would like to share the way to configure the logging application block with a sample web application to log the errors to the Event Listener and to a log file.

Once you have installed the Enterprise Library 5.0 Beta1 into your machine make sure to make it as strong named it by applying a key using the Visual Studio.

After that add a reference to the logging application block assembly Microsoft.Practices.EnterpriseLibrary.Logging.dll in your project.

the next step is to configure the Logging Application Block using the Enterprise Library tool located under Program Files => Microsoft patterns & practices => Enterprise Library 5.0 Beta 1 - February 2010 => Enterprise Library Configuration.

so the Configuration tool open like below :

Open your web.conf or app.conf file using the above tool as below:

by default it will list you the Application Settings and the Database settings and it does not contain anything and if you need to configure something on that feel free to add those values.

As we need to test the logging application blocks, please add the Logging Application Blocks by clicking Blocks => Add Logging Settings as below.

so it will lists you the settings as below :

Enter a name for your Event Log listener as below:

Under All Events settings make sure to add your recently created listener into the list as below:

Click the “+” sign next to the Logging Target Listeners and select Add Logging Target Listeners => Add Flat File Trace Listener.

Once you add the Flat File Listener the configuration tool will looks like below:

After that select the log file name to log the events and the Formatter as Text Formatter.

Upon making the above settings make sure to add the above listener to the All Events settings as below :

Upon following the above steps write the following code in C# and test the solution, you will find the entries written upon in the Event Log and the Log file which you did specified in the above step :

try
{
LogEntry logEntry = new LogEntry();

logEntry.Severity = System.Diagnostics.TraceEventType.Information;
logEntry.ProcessName = "Section XYZ from your project";
logEntry.Title = "Testing";
logEntry.Categories.Add("General");
logEntry.Message = string.Format("Your Message");
logEntry.TimeStamp = DateTime.Now; Logger.Write(logEntry);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}

Consuming a Web Reference in a class library (C#/.NET) – VS 2008

2010-03-17T20:20:00.002+09:00

when you tried to add a web reference to a Class Library in VS 2008, by default it will add a Service Reference (WCF). I have seen this option only in VS 2008 and not in VS 2005. If you need to add a Web Reference then at the time of adding a Service Reference, click the Advanced button as depicted below :

After that click the Add Web Reference as below:

after that you will be prompted with the usual add web reference dialog.

Setup says VS Integrated Shell 2010 ENU installed when uninstalled, Grrrr!!!

2010-03-14T23:01:00.002+09:00

I came across a situation where i had to remove the Team Explorer version 2010 Beta1 from my machine. I have uninstalled it via Uninstall option from the Programs and Features. When i tried to install TFS 2010 RC Team Explorer setup it says “VS Integrated Shell 2010 ENU” exists and have to remove. I did the uninstallation and restarted the machine even. Nothing happened and when i ran the installation it prompts me again saying that “VS Integrated Shell 2010 ENU” already exists. I checked the Programs and Features and it was not there. :(

I was something like this :

finally found the solution.

simply run this command :

msiexec /uninstall {874D5E2B-AACE-303A-B3EC-2563E071473E}

lets we dig little bit deeper in to the above command.

Initially you have to to do is to use msiinv.exe (thanks to Aaron Stebner’s to exposing the tool) tool to see if MSI thinks the integrated shell is installed or not. So from that tool it will lists all the installed programs and under that list you can see this ghost “VS Integrated Shell 2010 shell ENU” still exists in the list.

what you have to do is just note down the Product Code and use the same code to execute the above command.

VS2008 Professional connecting to TFS 2010 RC on Windows Server 2008

2010-03-14T22:52:00.002+09:00

Assuming that you have already installed VS 2008 professional edition (no problem eventhough you have installed the VS 2008 SP1 because anyhow you are going run it again) in your machine and in your machine TFS 2010 RC is installed and configured successfully.

Please follow the following steps as its :

You have to install Team Explorer 2008 over your VS2008 Professional SP1.
You need to reinstall VS2008SP1 to update team explorer.
After that you have to install Visual Studio Team System 2008 Service Pack 1 Forward Compatibility Update for Team Foundation Server 2010 (Installer) from this link.
When you connect from VS2008, you need to enter the full URL (ex: :/tfs">https://<MyServer>:<port>/tfs)

Team Foundation Server 2010 RC Installation

2010-03-14T22:27:00.002+09:00

After a lengthy hard work we were able to install and configure the Team Foundation Server 2010 RC on Windows 2008 R2. Eventhough the installation and the configuration is easy we had some trouble with the DNS naming of the host machine (thanks to Usman – Team Lead to identifying that issue).

kick off the installation by clicking the setup file and follow the screens just clicking the next button.

After the completion of the installation its time to configure the TFS 2010.

In this situation you have to enter a authenticated user who has the administrator rights in the domain.

from the following screen you can double check all your entries are valid or not by clicking the Verify button. Its one of the best feature in this configuration wizard rather messing up the things after the completion of the installation.

Missing Application Pools Folder in IIS - Windows Server 2003

2010-03-11T20:44:00.002+09:00

to get the application pools back to the IIS please follow the steps as mentioned below:

1. In IIS Manager, expand the local computer, right-click Web Sites, and then click Properties.
2. Click the Service tab, clear the Run WWW service in IIS 5.0 isolation mode check box, and then click OK.
3. To start the WWW service, click Yes when asked if you want to restart IIS now.

WCF and Web service

2010-03-11T15:38:00.002+09:00

Features	Web Service	WCF
Hosting	It can be hosted in IIS	It can be hosted in IIS, windows activation service, Self-hosting, Windows service
Programming	[WebService] attribute has to be added to the class	[ServiceContract] attribute has to be added to the class
Model	[WebMethod] attribute represents the method exposed to client	[OperationContract] attribute represents the method exposed to client
Operation	One-way, Request- Response are the different operations supported in web service	One-Way, Request-Response, Duplex are different type of operations supported in WCF
XML	System.Xml.serialization name space is used for serialization	System.Runtime.Serialization namespace is used for serialization
Encoding	XML 1.0, MTOM(Message Transmission Optimization Mechanism), DIME, Custom	XML 1.0, MTOM, Binary, Custom
Transports	Can be accessed through HTTP, TCP, Custom	Can be accessed through HTTP, TCP, Named pipes, MSMQ,P2P, Custom
Protocols	Security	Security, Reliable messaging, Transactions
State	state less	can manage states

Installing a SQL Server 2008 named instance – Windows Server 2008 R2

2010-03-11T14:55:00.002+09:00

Run the setup from your SQL Server 2008 CD

Click Installation tab and click New SQL Server Stand Alone installation or add features to an existing installation.

Accept the licensing terms.

Give a name to the SQL Server instance.

i am not going to install this particular instance in mixed mode hence i have selected the windows authentication mode. Setup wont allow you to go to next step unless if you didn't specify a administrator account. I have added the current user credential as one of the administrator account for the SQL Server.

http://support.microsoft.com/kb/955499

http://support.microsoft.com/kb/956173

Uninstalling SQL Server 2008 Instance

2010-03-10T22:36:00.002+09:00

please follow the steps mentioned below to uninstall a named instance of a SQL Server 2008. For the reference of others I have published the screen shots to help you guys in some way. Please make sure before uninstalling that none of the SQL services are not used by other applications.

Go to the control panel => Programs => Programs and Features

Browse to SQL Server 2008 and click the Uninstall/Change button above.

Click continue when a prompts comes and make sure that no one is logged into the server.

Click Remove and please follow the screen shots as mentioned below.

Select the SQL Server 2008 instance to uninstall.

Select the features belonging to the instance that you are going to uninstall and keep the shared features.

At the time of uninstallation process I had problem with uninstalling the reporting services and the error was:

"An error has occurred: Access to the path '<Path of perf-ReportServer-rsctr.dll>' is denied"

Please refer this link to resolve the error:

To resolve this issue, close or stop any process or application that may be using the Report Server performance counter, and then try to uninstall Report Server.

http://support.microsoft.com/kb/956173

VS 2008 SP1 ISO image

2010-03-03T15:18:00.004+09:00

when we are installing VS 2008 SP1, initially we can download a .exe from the microsoft site and upon executing that file we should have the internet connection as it fetches all the latest patches online.

if we need to apply the same SP1 to multiple machines then it will be really a headache, so rather doing like that from the following link we can download the ISO image file.

http://www.microsoft.com/downloads/details.aspx?FamilyId=27673C47-B3B5-4C67-BD99-84E525B5CE61&displaylang=en

You must use the Role Management Tool to install or configure Microsoft .NET Framework 3.5.

2010-03-03T14:19:00.007+09:00

When you are trying to install Visual Studio 2008 professional edition on a Windows 2008 R2 suddenly you will be prompted to an error saying "You must use the Role Management Tool to install or configure Microsoft .NET Framework 3.5."

In this case what you have to do is, from the Service Manager install the .NET Framework 3.5.1 Feature as Windows 2008 R2 is integrated with .NET Framework 3.5.

so before installing VS 2008 make sure that you are enabling this feature .NET Framework 3.5.1 Features via the Add Features Wizard in Server Manager.

Deploying BizTalk 2009 Applications

2010-02-24T17:35:00.002+09:00

After long time i had to refresh my knowledge about deploying a BizTalk application. I did all these things some time back and totally forgot the things what i did. Anyhow after developing a small orchestration sample in VS 2008, i tried deploying the application. It successfully deploys but i couldn't see the Application in the Biz Talk Administration Console. totally confused and was searching for the deployed Application name after restarting the service for one, two, three times. I had to make sure is that the schema, map were deployed or not. When i checked in the All Artifacts node, so i was able to find my schema, map were deployed successfully.

So after that i had to check the properties of the BizTalk project what i did developed in VS. When i checked the properties so the Application Name was empty.

In this case at the time of deploying, VS automatically deploys the application as “BizTalk Application 1” and when i checked the maps, schema folders, all my files were deployed there.

so i had to insert a name for the Application Name in VS 2008 and had to redeploy it again. At the time of deploying VS prompts you saying that the DLL is already deployed. What you have to do is remove the assembly from the GAC (C:\Windows\Assembly) and as well as the orchestration, map and schema files from the BizTalk Administrator Console. Once its done try to deploy it again and finally it was deployed successfully. :)

Nintex Context menu doesn't appear in IE8

2010-02-14T20:32:00.002+09:00

Once we have configured the Nintex workflow 2007 in our development server, I was unable to see the context menu which should appear in the Nintex workflow controls.

so the reason was when the IEs Enhanced Security Configuration (ESC) settings are turned on then have to add the about:blank to the trusted site list.

Uploading a InfoPath form which is an Administrator Approved Template for SharePoint 2007

2010-01-26T20:55:00.002+09:00

As i described in my previous post once we finished saving a InfoPath form which prompted us “Administrator must approve this form template before it can be filled out by using a browse” at the time when we followed the normal usual way to publish a InfoPath form in SharePoint library, as the next step we have to upload this template to the SharePoint via Central Administration.

Browse to the Central Administration home page and go to Application Management, Under InfoPath Form Services Click on Upload Form Template.

Find the location of the template and browse to it. (If you saved it to SharePoint you'll need to save a local copy on your computer and upload from there.)

to be continued…

An Administrator must approve this form template before it can be filled out by using a browser.

2010-01-26T20:40:00.002+09:00

Currently i was working with InfoPath forms for me to design some form templates and later which will be published in SharePoint to enable nintex workflow. Most of time we were used to develop InfoPath forms which is compatible with browser. In other words browser compatible InfoPath forms.

I came across a situation where we need to get the current IP address of the logged in user to the InfoPath form. So at that time i had to write some C# codes in InfoPath form. Upon finished with the codes when i tried to publish the form, mid of the publishing wizard it didn't allow me to publish the InfoPath template directly to the SharePoint library, instead it forced me save it in locally informing “Administrator must approve this form template before it can be filled out by using a browser”.

the reason was :

This behavior occurs because a Microsoft Visual Studio 2005 Tools for the Microsoft Office System form contains managed code by default.

Note: If a form template contains managed code, the Publishing Wizard lets you click only the Administrator-approved form template (advanced) option.

the only way in this situation is to save the InfoPath template locally and to upload the same template via the Central Administration.

Error creating package - Failed to save package file “\path” with error 0x80040154 "Class not registered"

2010-01-15T16:19:00.002+09:00

When I tried to create a new SSIS package in the BIDS, I received an error saying : “Failed to save package file “\path of the file" with error 0x80040154 "Class not registered".

It was due to MSXML6 setup package did not get installed in my machine properly or due to some reason it should have corrupted. So you have 'MSXML 6.0 Parser' in Add/Remove Programs, click Change and then Repair. If it does not exist in your Add/Remove Programs - rerun the SQL Setup, then it should install it.

Adding SQL Server Reporting Services Report Viewer Web Part - SharePoint

2010-01-13T17:31:00.002+09:00

Once i have installed the Reporting Services add in for the SharePoint by default the SQL Server Reporting Services Report Viewer web part should be enabled in SharePoint web part library. But in my case it was not added and listed in the library. So i had to add it manually.

follow the steps as below:

After adding the web part to your page just configure the same to view your report.

you can download the addin from the following link:

http://www.microsoft.com/downloads/details.aspx?familyid=1E53F882-0C16-4847-B331-132274AE8C84&displaylang=en

Biztalk Poster

2010-01-05T16:40:00.010+09:00

Biztalk poster (Silverlight enabled) -

Check this out :

http://www.microsoft.com/biztalk/capabilities/reader/ .

Scroll/Zoom + click on a section where the help and various MSDN articles come up. really helpful for us. :)

This operation has been cancelled due to restrictions in effect on this computer. Please contact your system administrator.

2009-12-07T21:59:00.002+09:00

To resolve above mentioned error while opening any of hyperlinks in Ms Excel, Outlook, etc just follow this step :

For Windows XP (Service Pack 1 and higher)

* Click Start, Control Panel, double-click Add or Remove Programs
* Click Set Program Access and Defaults
* Click Custom
* Under Choose a default Web browser, select Internet Explorer
* Click OK

For Windows Vista

* Click Start, and click Default Programs
* Click Set program access and computer defaults
* Click Custom, select Internet Explorer and click OK
* Close and re-open Microsoft Outlook

Service Unavailable and SharePoint Error: Some or all identity references could not be translated

2009-12-03T22:13:00.002+09:00

Currently i was working with some BizTalk test projects using a Virtual Machine installed with Windows 2003. I have installed BizTalk 2006 in the same machine in which i was doing some SharePoint projects. For me to install BizTalk 2006 i had to install DNS and the Active Directory. Prior to installing this BizTalk, SharePoint was working fine without giving me any headache.

After installing BizTalk it started to give me problems when i tried to access the SharePoint Central Administration. It prompted me for Service Unavailable error, Grr rrrr (at that time i was thinking if i need to redo these things again such as installing windows 2003 in a new virtual machine, after that installing DNS, installing Active Directory, installing MOSS 2009 and installing BizTalk 2009 - it will waste my time for sure).

So i know it was due to the installation of the Active Directory and i had to reset the permission in Application Pools in IIS (go to IIS, browse Application Pools and select your Application => right click and go to properties => from there select the Identity Tab and change the User Name and accordingly change the password.

Once its over when i tried to browse for SharePoint sites another error was prompting me saying “Some or all identity references could not be translated” (Hard Luck). So i was searching to resolve this problem. so Finally the utility STSADM was there to help us. You can find this tool under C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN and just execute this command by replacing the proper login with the domain name followed by the password.

"stsadm.exe -o updatefarmcredentials -userlogin domainname\username –password yourpassword "

Once you executed the above command please make sure to do iisreset –noforce

Hurray!!! now everything works fine without any hassle. Hassle free of life.

Make sure to re-run the SharePoint Products and Technologies wizard once the above said steps are finished.

guys for more information please refer this URLs:

http://www.neilrichards.net/blog/?p=73

http://coolsubhash-tech.blogspot.com/2007/05/some-or-all-identity-references-could.html

http://www.keirgordon.com/post/SharePoint-Server-Error-Some-or-all-identity-references-could-not-be-translated.aspx

Failed to add resource(s). Resource () is already in store and is either associated with another application or with another type

2009-12-03T00:29:00.002+09:00

when i was working with biztalk orchestration, there was an error prompted at the time when i did the deployment : “

Error 1 Failed to add resource(s). Resource (-Type="System.BizTalk:BizTalkAssembly" -Luid="BizTalkServerTestProjectAmmar, Version=1.0.0.0, Culture=neutral, PublicKeyToken=dda761d103beeac0") is already in store and is either associated with another application or with another type. 0 0 “

I thought we should just deploy the way that we are doing with other applications. But when researched about this if we didn't specify any value for the Application Name in the Deployment properties page, then VS used to deploy the orchestration in BizTalk Server named with BizTalk Application 1.

To overcome the above said error i had to remove the resource file located under Resources folder as below:

once its done, the orchestration was deployed in the BizTalk Server successfully. :)

To avoid this in future, set explicitly deployment target application in the Visual Studio project properties by: right click - Configuration properties - Deployment - Application Name.

Microsoft Biz Talk Server 2009

2009-11-23T21:05:00.001+09:00

Simply we can say the BizTalk is a Messaging Based Integration Tool and uses XML as the common data exchange language for eCommerce and application integration in the WWW.

In other words we can say that BizTalk is the main interface in between multiple systems and based on some definitions we can say as "BizTalk Server is Microsoft's central platform for Enterprise Application Integration (EAI) and Business Process Management (BPM) and embodies the integration and automation capabilities of XML and Web Services technologies. BizTalk Server functions as a process execution engine and as a multi-transport hub for messaging and document transformations. It is a Windows Server System product that helps customers efficiently and effectively integrate systems, employees and trading partners".

you can understand what is happening inside BizTalk by viewing the following animated jpeg file :

if you can’t view the animation please do not hesitate to click this link:http://farm3.static.flickr.com/2718/4127256189_0da73842e3_o.gif

Cannot implicitly convert type 'System.DBNull' to 'int'

2009-11-09T15:48:00.003+09:00

There will be situations where you have to set null values to an Integer field. So when you tried to assign a DBNull.Value to an integer varialbe you will prompt for the error : "Cannot implicitly convert type 'System.DBNull' to 'int' ".

to resolve this matter, let it be as its in the interface level, but at the time of passing the parameter to the Database just make it DBNull.Value.

'With your command object

1: myCmd.Parameters.Add("@myParameter",SQLDBType.INT).Value = IIf(myTextBox.Text <> "", myTextBox.Text, DBNull.Value)

another code snippet :

if (Employee.EmployeeManagerID == 0) { AddParameter("@EmployeeManagerID", DBNull.Value, DbType.Int32, null, ParameterDirection.Input); } else AddParameter("@Manager",Employee.EmployeeManagerID, DbType.Int32, null, ParameterDirection.Input);

Microsoft JScript runtime error: 'Sys' is undefined

2009-11-09T02:17:00.007+09:00

After some time back was working in a Development project and was came across an error :

Microsoft JScript runtime error: 'Sys' is undefined,

as i went on hunting for the solution for this there are so many answers i was able to find. But the error which was triggerd in my application was due to not specifying httphandlers and httpmodules handlers in web.conf file.

I will try to post the code later as for the moment i couldn't post html stuffs in blogger.

Contacts temporarily unavailable in Google Talk and GMAIL

2009-09-25T01:12:00.006+09:00

Seems Google having problem loading Contacts in both the Gmail and Google Talk. Googles' response to this problem :

Contacts temporarily unavailable

Your contact list is temporarily unavailable, which may result in a few issues:

Auto-complete may not work
The contact manager may not load
Chat may not work

We're working to fix the problem, and in the meantime, you should be able to continue to read and send mail as normal. Thank you for your patience.

SharePoint consistently prompting for user credentials

2009-04-16T22:15:00.003+09:00

When SharePoint bugs you to enter user name and password again and again at the time of login then you can solve it by following the step described below :

In IE, go to 'Tools'
Click on 'Internet Options'
Open 'Security' tab
Click on 'Custom level'
Scroll down and select 'Automatic logon with current username and password'
Click ok

Internet Explorer 8

2009-04-15T20:59:00.002+09:00

A new version of the IE was released in early March 2009. So the new features of the IE 8 are :

Accelerators
Enhanced Navigation
Increased Performance
Improved Favorites and History Management
Instant Search
Web Slices

for more details refer : http://www.microsoft.com/windows/internet-explorer/features/overview.aspx?tabid=1&catid=1

you can download the IE 8 from here : http://www.microsoft.com/windows/internet-explorer/default.aspx

refer this article also : Duplicate IE 8 Features in Firefox 3

SharePoint Designer Offered as Free

2009-04-07T22:59:00.003+09:00

Microsoft has announced informing that share point designer now available as a free tool. you can download it from here.

as well as Microsoft plans to ship the next version of SharePoint Designer with the next SharePoint release called “SharePoint 14”

Arabic Language Pack for MOSS 2007

2009-04-05T23:12:00.003+09:00

before installing the Arabic Language pack make sure that you have installed the Microsoft Office Project Server 2007. Once its done as the next step double check whether is that your Windows 2003 Arabic language support. If not follow the steps :

Install additional language files :

Click Start, point to Settings and then Control Panel, and then click Regional and Language Options.
In the Regional and Language Options dialog box, on the Languages tab, in the Supplemental Language Support section, select one or both of the following checkboxes:
- Install files for complex script and right-to-left languages
- Install files for East Asian languages
Click OK in the dialog box that alerts you that additional disk space is required for the files.
Click OK to install the additional language files.
When prompted, insert your Windows Server 2003 product disc or provide the location of your Windows Server 2003 installation files.
When prompted to restart your computer, click Yes.

you can download the Arabic Language pack for MOSS 2007 from this link :

http://www.microsoft.com/downloads/details.aspx?displaylang=ar&FamilyID=2447426b-8689-4768-bff0-cbb511599a45

for other languages you can find details from this link : http://www.microsoft.com/downloads/details.aspx?FamilyId=3A6C26FD-0BEB-40D5-8CBA-15164FAAB150&displaylang=en

you can read about the way to install the Arabic Language pack in Windows 2008 server from here : Installing Arabic Language Pack for MOSS 2007 over Windows Server 2008

http://gmail.google.com

2009-04-05T02:44:00.002+09:00

I used to check my gmails typing http://gmail.google.com, but today when i access the gmail in the same manner a strange message used to appear. it says something like this :

“We can't provide service under the Gmail name in Germany; we're called Google Mail here instead.

If you're traveling in Germany, you can access your mail at http://mail.google.com.

Oh, and we'd like to link the URL above, but we're not allowed to do that either. Bummer.

For general information about Google, please visit www.google.com or www.google.de.”

really what is it? :)

by the way i was able to access the gmail through google.

Installing Dotnetnuke 4.9.2

2009-04-02T16:01:00.002+09:00

I would like to give you a brief introduction to the way to install DotNetNuke_Community_04.09.02 in a Windows XP PC with SQL Server 2005 Enterprise Edition.

you can download all the dotnetnuke resources from http://www.dotnetnuke.com/tabid/125/default.aspx, but to access that page you have to register with dotnetnuke.

you can find following modules to be downloaded from the URL mentioned above :

DotNetNuke 4.9.2 Install : this package is used to install dotnetnuke in your machine.
DotNetNuke 4.9.2 Upgrade – is used to upgrade any dotnetnuke versions than the current version.
DotNetNuke 4.9.2 Source – full dotnetnuke code is available here.
DotNetNuke 4.9.2 Starter Kit – Dotnetnuke Started kits for developers.
DotNetNuke 4.9.2 Docs – Documents with related to everything from installation to administration, etc you can find it here.

download the DotNetNuke 4.9.2 Install file and extract it into your C: drive. Make sure to give a meaningful name to the extracted folder (ex: Dotnetnuke, DNN). Once its done you have to create a virtual directory in IIS.

right click the Dotneunuke folder and enable the web sharing and give ASPNET, NETWOK SERVICE accounts FULL CONTROL as depicted in following screen shots.

As well as from the database end i will create a empty database named Dotnetnuke in SQL Server 2005. In this situation i will use the default SQL Server 2005 admin user name and password to access the database.

else you can create totally different user logins to access the database. for that you have to follow these steps :

Creating a login for your database:

Expand the Security node of your server.
Right-click on Logins.
Select “New Login”
Enter your desired login name. You must remember this login name (dnnuser) and password as this will be used in a later stage.
Select “SQL Server Authentication” and enter a password.
Uncheck the “Enforce Password expiration/User must change password at next login”
Click “User Mapping”
Select the database that we have created at the initial stage.
make sure to select db_owner in the bottom list “Database role membership for: “
Click OK

to make sure that steps that you have followed above is correct, just expand the Security node under your database (Dotnetnuke) and you will see a newly created database user (dnnuser) listed, meaning we also created a new database user by mapping our SQL Server login to our newly created database.

Once its done you have almost completed the installation steps but there are some few steps to go ahead. Just access your dotnetnuke site by typing http://localhost/dotnetnuke in your browser. So you can see the page as depicted below :

i have used my admin credentials to login to dotnetnuke database. Else you can enter the user names and passwords that you have created above (dnnuser credentials).

creating accounts for HOST and ADMIN logins to the dotnetnuke website :

Hurrah!!! finally its done and your dotnetnuke website looks like below :

Note:

apart from the steps as described above at the time of creating the virtual directory, please make sure the anonymous access is allowed for the created virtual directory. to allow the said permission please follow the steps as described below:

Already the virtual directory is in place and have to modify its properties.

Open IIS and expand the tree to see “Default Web Site”. (You can find IIS in Start | Control Panel | Administrative Tools.)
Expand the "Default Web Site" node.
right click the virtual directory name that you have created (Dotnetnuke) and select properties.
Click on the "Documents" tab
An entry for “default.aspx” needs to be added. Add default.aspx and move it to the top of the default documents list.
Click on the "Directory Security" tab
In the “Anonymous access and authentication control” group box, click "Edit"
Make sure that “Anonymous Access” is checked as well as “Integrated Windows authentication”
Next, click on the "ASP.NET" tab and make sure that “2.0.50727” is select for the ASP.NET version
Click OK to save your changes

you can read my article in codeproject.

Flash Movie overlaps the DNN Menu

2009-03-18T18:59:00.005+09:00

When you inserted a flash movie in a Dotnetnuke Text/HTML content pane, the menu used to hidden on top of that inserted flash object. for that you have to add a parameter <param name="”wmode”" value="”transparent”" /> in code behind and insert the wmode="transparent" entry in the embed tag as below :

<p><param name="”wmode”" value="”transparent”" />
<embed menu="false" loop="true" play="true"
type="application/x-shockwave-flash" width="636"
src="/DNNSite/Portals/0/SafatImages/safat_a.swf"
wmode="transparent"
pluginspage="http://www.macromedia.com/go/getflashplayer"
style="width: 636px; height: 133px">
</embed></p>

finally the page should look like this :

Failed to retrieve data for this request Microsoft.Sqlserver.SmoEnum

2009-03-15T22:28:00.002+09:00

when i tried to expand the MSDB folder in SQL 2005 Integration Services i got the following error.

"Failed to retrieve data for this request. Microsoft.Sqlserver.SmoEnum"

without any problem Management Studio successfully connects to the Notification Services and was sure too that i have allowed remote connections via named pipes and TCP/IP. But :( when i tried to expand the MSDB folder i m getting that error. so i was thinking and trying to find a solution for this.

finally, Hurrah!

the solution is to update a configuration file with the proper servername\instancename.

you have to update the MsDtsSrvr.ini.xml located in the path : C:\Program Files\Microsoft SQL Server\90\DTS\Binn\ MsDtsSrvr.ini.xml as below :

Original file without the modification :

<?xml version="1.0" encoding="utf-8"?>
<DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<StopExecutingPackagesOnShutdown>true

</StopExecutingPackagesOnShutdown>
<TopLevelFolders>
<Folder xsi:type="SqlServerFolder">
<Name>MSDB</Name>
<ServerName>.</ServerName>
</Folder>
<Folder xsi:type="FileSystemFolder">
<Name>File System</Name>
<StorePath>..\Packages</StorePath>
</Folder>
</TopLevelFolders>
</DtsServiceConfiguration>

file with the updated values :

</StopExecutingPackagesOnShutdown>
<TopLevelFolders>
<Folder xsi:type="SqlServerFolder">
<Name>MSDB</Name> <ServerName>MACHINENAME\SQLINSTANCENAME</ServerName>
</Folder>
<Folder xsi:type="FileSystemFolder">
<Name>File System</Name>
<StorePath>..\Packages</StorePath>
</Folder>
</TopLevelFolders>
</DtsServiceConfiguration>

more details :

http://msdn.microsoft.com/en-us/library/ms137789(SQL.90).aspx

The SPPersistedObject, PolicyConfigService Name=PolicyConfigService Parent=SPFarm Name=SharePoint_Config, could not be updated because the current use

2009-03-11T17:39:00.003+09:00

when i was creating a Records Center in MOSS 2007, suddenly i had to encount for an error :

03/11/2009 10:44:59.45 w3wp.exe (0x0D44) 0x0D3C Windows SharePoint Services Topology 8dyu High The SPPersistedObject, PolicyConfigService Name=PolicyConfigService Parent=SPFarm Name=SharePoint_Config, could not be updated because the current user is not a Farm Administrator.

so the workaround for this error is :

Select you Web Site under Application Pools
Right click => select properties
Go to Identity tab and change the User Credentials to the same credentials that is being used to login to the Sharepoint Central Administration site.
Dont forget to do a iisreset.

How To Debug WebParts in VS 2008

2009-03-05T19:33:00.003+09:00

If we need to debug a WebPart which is being integrated into Sharepoint Website then have to modify the existing values in web.config as below :

<customErrors mode=“Off” />

<compilation batch=”false” debug=”true“>

Once the web.config is updated then you can directly set a breakpoint in your webpart source code and can debug in a Visual Studio environment.

1. Open your web part solution in VS 2008
2. Open Moss site or Web part page in a IE (Web Browser)
3. Place a Breakpoint in your code
4. Select Attach to Process from the DEBUG menu from the VS.
5. From the available process list select “w3wp.exe” & click on attached button.

This solution contains two assemblies with the same name, or the SharePoint server already has an assembly with the specified name.

2009-03-05T15:46:00.003+09:00

if you prompted for an error "This solution contains two assemblies with the same name, or the SharePoint server already has an assembly with the specified name." at the time of deploying a custom web part or any component in sharepoint as the solution you have to do this :

See if the feature (webpart, lists, etc) that you're trying to add still exists in the "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\FEATURES" path. if its then remove and try to deploy it again.

Configuring Microsoft CRM 4.0 in Windows 2003 Server

2009-03-03T21:20:00.002+09:00

As i have promised earlier i thought to post you the steps to install the Microsoft CRM 4.0 in Windows 2003 Server. The installation task used to kick of by running the setup file as the usual routine and follow the screen shots as depicted below to complete the installation task.

Enter the Licensing Keys in above text boxes.

Accept the Terms & Conditions.

Enter the name of the SQL Server 2005.

if you didn't select a Email router server name then the installation wizard prompts you for the following dialog box.

Successfully installed CRM in the machine and its on Live.

Configuring Windows 2003 Active Directory

2009-03-03T21:06:00.002+09:00

After completion of the steps as i have described in my previous post “Configuring the Windows 2003 DNS Server” you can run the “dcpromo” command to start installing the Active Directory in your Windows 2003 Server.

Enter the full DNS name of the new domain, for example – marketing.mycompany.com - this must be the same as the DNS zone that you have created in the previous post “Configuring the Windows 2003 DNS Server” at the time of configuring the DNS.

Configuring the Windows 2003 DNS Server

2009-03-03T20:55:00.002+09:00

i thought to share the experience of installing a DNS in Windows Server 2003. As the starting point you have to install the DNS Services from the Windows Components.

The path you have to follow is this :

Start => Settings => Control Panel => Administrative Tools => Add/Remove Programs => Add/Remove Windows Components.

After that select Networking Services and click Details. Make sure to click Domain Name System (DNS) and click OK.

Once you finished installing the DNS via the Administrative Tools you can find the DNS Manager snap in as depicted below.

1. Creating a Forward Lookup Zone (please follow the screens one by one)

2. Creating a Reverse Lookup Zone (please follow the screens one by one).

The instance name must be the same as computer name.

2009-03-02T14:13:00.002+09:00

when you changed the Computer Name when there is already a SQL Server 2005 instance running (exists) in your system, then you may have to face “The instance name must be the same as computer name” at the time of installing the Microsoft CRM 4.0 Server.

As the solution you have to make sure the exact name of the SQL Server instance running in your computer. for that execute the following command in Query Analyzer :

select @@Servername

if the above commands gives you the output as the old server name

Then execute the following command:

sp_dropserver 'old_sql_server_instance_name', 'droplogins'
GO
sp_addserver 'new_sql_server_instance_name', 'local'
GO

Successfully Installed the Microsoft CRM 4.0 Server

2009-03-02T03:39:00.002+09:00

After sometime of struggle to install DNS (Domain Name Server) and the AD (Active Directory) i was able to install the Microsoft CRM 4.0 in my machine successfully. I am planning to update you guyz with screen shots in due course.

The summary of the CRM installation is :

OS should be a Server Operating System (Win 2003/2008)
Install & Configure the Domain Name Server
Install & Configure the Active Directory
Install Microsoft Dynamics CRM 4.0

CRM in Action :

The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database.

2009-03-01T23:32:00.003+09:00

Ooops what is this error!!!

when i was configuring MS SQL Reporting Services 2005 on the way to installing Microsoft CRM Server i had to encounter for the error:

"The report server cannot decrypt the symmetric key used to access sensitive or encrypted data in a report server database. You must either restore a backup key or delete all encrypted content. Check the documentation for more information. (rsReportServerDisabled) (rsRPCError)"

the solution for that error is to delete the Encryption Key in the Reporting Services Configuration.

the step is :

Start => Programs => Microsoft SQL Server2005 => Configuration Tools => Reporting Services Configuration => Encryption Keys.

The local policy of this system does not permit you to logon interactively.

2009-02-11T17:12:00.003+09:00

I came across a problem when i was playing around the Active Directory today. I have created a new user in AD and tried to login to the machine with the newly created username and password. At the time of logging to the machine the error was “The local policy of this system does not permit you to logon interactively.”.

SOLUTION

1. Click Start, point to Programs, point to Administrative Tools, and then click Domain Controller Security Policy.

2. Double-click the Security Settings folder, double-click Local Policies, and then click User Rights Assignment.

3. Under the Policy column, double click “Allow Log on Locally”.

4. Click “Add User or Group”, and then select the user to be added.

5. Click OK, click OK, and then click OK.

Customer Relationship Management

2009-02-04T18:59:00.002+09:00

Customer Relationship Management (CRM) is about finding, acquiring, and retaining the best, most profitable customers. In other words we can define it as a methodology which is used to learn about the Customer. As a strategy CRM places the customer as the center of a business. When implemented in a proper manner, the goal is to give deep information about the customers in return which supports the areas of the marketing, product planning, sales, finance and customer service.

WE can categorize the CRM into Marketing, Sales and Customer Services.

Microsoft Dynamics CRM

2009-02-02T19:19:00.002+09:00

Microsoft Dynamics CRM is built by using Microsoft .NET–connected technologies so that it is easy to deploy, customize, and use. Microsoft Dynamics CRM can be accessed from Microsoft Office Outlook;

As well as it integrates with other business applications, and it scales as your business grows.

Microsoft Dynamics CRM consists of the following components:

Microsoft Dynamics CRM Server
Microsoft Dynamics CRM for Microsoft Office Outlook
Microsoft Dynamics CRM 4.0 E-mail Router

Microsoft Dynamics CRM 4.0 offers several editions that cover various implementations for small, to mid-level, to even very large organizations.

Editions

• Microsoft Dynamics CRM 4.0 Workgroup. This edition is limited to 5 or fewer users, and supports a single organization. Microsoft Dynamics CRM 4.0 Workgroup can be installed on a single computer running Microsoft® Windows® Small Business Server 2003 R2 Premium Edition, any of the supported Windows Server 2003 editions, or Windows Server 2008.

• Microsoft Dynamics CRM 4.0 Professional. This edition has no user limit, but is limited to a single organization. Microsoft Dynamics CRM 4.0 Professional can be installed on more than one computer within the same deployment.

• Microsoft Dynamics CRM 4.0 Enterprise. There are no user limits for this edition, and it supports multiple organizations. Microsoft Dynamics CRM 4.0 Enterprise can be installed on more than one computer in the same deployment. In addition, the Enterprise edition supports role-based service installation, which enables you to increase performance by installing component services on different computers.

Microsoft Dynamics

2009-02-01T17:45:00.007+09:00

Microsoft Dynamics consists of five products:

Microsoft Dynamics AX (Axapta)

Designed for midsize and larger companies, Microsoft Dynamics AX (formerly Microsoft Axapta) is a multi-language, multicurrency enterprise resource planning (ERP) solution. With core strengths in manufacturing and e-business, there is an additional strong functionality for the wholesale and services industries.

Microsoft Dynamics CRM

Microsoft Dynamics CRM is a sophisticated business application platform that provides the basic services required by ISVs, VARs, and even business analysts to build upon. A wide range of applications can be created with this platform. These applications may be based on Microsoft Dynamics CRM but are not limited to CRM-type applications.

Microsoft Dynamics GP (Great Plains)

Microsoft Dynamics GP is a business management solution that provides growing and midsize organizations with complete and scalable financial and operational functionality. Several development tools are available that can be used to customize and create integrations for Microsoft Dynamics GP.

Microsoft Dynamics NAV (Navision)

Microsoft Dynamics NAV is a business management solution that helps small and mid-sized organizations streamline their highly specialized business processes, rapidly adapting to the unique way they do business. Through the rapid adaptability, simplified customization, and ease of use offered by Microsoft Dynamics NAV, you can easily add functionality, custom applications, and online business capabilities that enhance the built-in industry-specific functionality that's relevant to the local needs of customers' businesses.

Microsoft Dynamics SL (Solomon)

Microsoft Dynamics SL (formerly Microsoft Solomon) is perfect for the project-driven mid-size organization needing a modularized business management solution for managing people, projects, and profitability. This solution comes in two editions and is ideal for professional services, operations, field services and construction management, and wholesale distribution businesses with multiple locations and divisions.

for more details please refer this link :
http://msdn.microsoft.com/en-us/dynamics/ax/default.aspx

Microsoft Share Point Server

2009-01-30T15:35:00.003+09:00

through out past few weeks I had a chance to explore the features of the Microsoft Share Point Server. So i m planning to keep all of you guys updated with the stuffs that i did explore in a detailed form when time permits.

Inside Dynamics AX 4.0

2009-01-21T20:35:00.005+09:00

The best technical resource for Dynamics AX 4.0 is available to download from Microsoft. :)

Discover how to:

Use MorphX designers and development tools
Work with the X++ programming language
Build managed solutions that enable enterprise application integration
Customize tables, classes, forms, and reports
Develop and customize role-based, Web-enabled application portals
Implement applications that concurrently support multiple users, languages, and locations
Query application metadata using reflection APIs
Design and implement application logic that optimizes database performance

Please download it from here .

How do I loop through a record set in a stored procedure?

2008-11-25T22:24:00.011+09:00

i came across a situation where i had to loop through a recordset, have to pick some column values and need to insert it to another table.

A sample snippet as below :

DECLARE MyCursor CURSOR READONLY FORWARD SELECT id FROM mainNav ORDER BY sort,id

OPEN MyCursor
READ NEXT FROM MyCursor INTO @id
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT id,label,url,sort,mainnavid FROM SubNav

WHERE mainNavID=@id ORDER BY sort,id
READ NEXT FROM MyCursor INTO @id
END
CLOSE MyCursor
DEALLOCATE MyCursor

attached the file script that i have used for the project.

-- ========================
-- Inserting Notifications –
-- =========================

ALTER PROCEDURE [dbo].[NotificationJob] AS
declare @TransId Int
declare @ToUserId Int
declare @RequestId Int
declare @FileId Int
declare @NoOfDays int
declare @TransType nvarchar(50)
declare @TransTypeId int
declare @NotificationType nvarchar(50)
declare @Active Int
declare @Description nVarchar (max)
declare @CreatedBy nvarchar(50)
declare @RecordCount Int

set @CreatedBy='DB_JOB'

--opening a cursor to select records from the Transaction table

DECLARE CUR_Notification
CURSOR FOR
SELECT
FileTransaction.TransId,
FileTransaction.UserId,
FileTransaction.FlowID,
FileTransaction.FileId,
FLOOR(CONVERT(real, GETDATE()) - FileTransaction.TransDate),
FileTransactionType.Name,
FileTransactionType.TransTypeId
FROM
FileTransaction
INNER JOIN
FileTransactionType
ON
FileTransaction.TransTypeId = FileTransactionType.TransTypeId
where
FLOOR(CONVERT(real, GETDATE()) - FileTransaction.TransDate) > 12
AND
FileTransactionType.TransTypeId= dbo.GetTransStatusId('Issue')
Or
FileTransactionType.TransTypeId= dbo.GetTransStatusId('Forward')
Or
FileTransactionType.TransTypeId= dbo.GetTransStatusId('AcceptReturn')

-- Opening the Cursor

OPEN CUR_Notification
FETCH NEXT FROM CUR_Notification
INTO @TransId, @ToUserId, @RequestId,@FileId, @NoOfDays, @TransType, @TransTypeId

declare @NotificationDate real

set @NotificationDate=(select CONVERT(real, GetDate()))

WHILE @@FETCH_STATUS = 0

BEGIN

SELECT @RecordCount=COUNT(*) FROM FRSNotification
WHERE
FRSNotification.TransID=@TransId
AND
FRSNotification.ToUserID=@ToUserId
AND
FRSNotification.RequestID=@RequestId

-- checking whether is there are any records exists

if @RecordCount=0
exec FRSNotification_Insert @TransId, @ToUserId,
@RequestId, @FileId, @TransTypeId, 1,
@NotificationDate, null, @TransType,
@NotificationDate, @CreatedBy

FETCH NEXT FROM CUR_Notification
INTO @TransId, @ToUserId, @RequestId,@FileId,
@NoOfDays, @TransType, @TransTypeId

END

--cleaning up operations
CLOSE CUR_Notification
DEALLOCATE CUR_Notification

SQL Doc™

2008-10-29T22:20:00.002+09:00

Document SQL Server 2000, 2005 and 2008 databases without any hassle.

Fast, simple database documentation
Document one or multiple databases, down to object level
Write, edit, and export documentation in easy-to-read HTML files or .chm files for team distribution
Includes all cross-database dependencies

download trial version :
http://www.red-gate.com/supportcenter/Product.aspx?p=SQL%20Doc

How to identify your SQL Server 2005 version and edition

2008-10-25T02:23:00.007+09:00

To determine which version of Microsoft SQL Server 2005 is running, connect to SQL Server 2005 by using SQL Server Management Studio, and then run the following Transact-SQL statement:

SELECT
SERVERPROPERTY('productversion') as productversion,
SERVERPROPERTY ('productlevel') as productlevel,
SERVERPROPERTY ('edition') as edition

The results are:

* The product version (for example, "9.00.1399.06").
* The product level (for example, "RTM").
* The edition (for example, "Enterprise Edition").

sample results :

9.00.1399.06 RTM DeveloperEdition

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

2008-10-20T14:18:00.005+09:00

One of strange error that i had to deal with is the one mentioned above. The error used to prompt more frequently when the number of records increased in table. So at the initial stage of developments you won't have this timeout error. But when the system is in operation level and when the production data increases you may haev to come across this timeout error.

There are two main Timeout property in ADO.NET.

1. Connection Timeout for Connection
2. Timeout for Data Access( Command Object or DataAdapter)

Setting Connection Timeout property for SQLConnnection object ?

You can't set timeout property in connection object because its a READ ONLY property.

The proper way to do this is to set the timeout value in connection string as mentioned below.

SqlConnection conn = new SqlConnection("server=Server;uid=sa;pwd=123456;database=myDB;Connection Timeout=120");

Setting the timeout property in DataAdapter or CommandObject.

SqlDataAdapter sqlAdapter = new SqlDataAdapter();
sqlAdapter.SelectCommand = new SqlCommand(sqlQuery, conn);
sqlAdapter.SelectCommand.CommandTimeout = 0;

Setting the timeout value to 0 will makes adapter or command to wait for indefinite time before terminating the attempt to execute a command and generating an error. The default timeout value for connection object is 15 seconds.

hope this might help you to solve the problem.

Working with System Tables in SQL 2005

2008-08-21T20:12:00.004+09:00

Find ALL tables that have columns with an identity property

SQL SERVER 2000:

select object_name(id),name from syscolumns where columnproperty(id,name,'IsIdentity')=1

SQLSERVER 2005:

select object_name(object_id),name from sys.identity_columns

Note: SQL Server 2005 stores the last value of the identity property that was generated. To query the last value execute the following query.

select name,last_value from sys.identity_columns

Find ALL columns in a table that are computed columns

SQL SERVER 2000:

select name from syscolumns where id =object_id('TableName') and iscomputed=1

SQL SERVER 2005:

select name from sys.computed_columns where object_id =object_id('TableName')

Note: The computed column in SQL Server 2005 may be persisted. To narrow down the result set, you could execute the following query:

select * from sys.computed_columns where is_persisted=0

Find ALL database names in a SQL Server instance

SQL SERVER 2000:

select name from master..sysdatabases

SQL SERVER 2005:

select name from sys.databases

Note: Many enhancements were made to the database. Query all of the columns in sys.databases to understand the new enhancements like snapshot, etc.

Find ALL Procedures in a Database

SQL SERVER 2000:

select name from sysobjects where type='P'

SQL SERVER 2005:

select name from sys.procedures

Note: You can find whether the stored procedure execution is used in replication or if the stored procedure is a startup procedure. Execute the following queries:

select name from sys.procedures where is_execution_replicated=1
select name from sys.procedures where is_auto_executed=0

Find ALL tables in a Database

SQL SERVER 2000:

select name from sysobjects where type='U'

SQL SERVER 2005:

select name from sys.tables

Note: In SQL Server 2005, you can find whether a table is replicated. Execute the following query.

select * from sys.tables  where is_replicated =1

Find ALL views in a Database

SQL SERVER 2000:

select name from sysobjects where type='V'

SQL SERVER 2005:

select name from sys.views

Note: In SQL Server 2005, you can find whether a view is replicated. Execute the following query.

select * from sys.views where is_replicated =1

Find ALL Triggers in a Database

SQL SERVER 2000:

select name from sysobjects where type='TR'

SQL SERVER 2005:

select name from sys.triggers where parent_class=1

Note: In SQL Server 2005, the triggers can be Assembly trigger (CLR) or a SQL trigger. In addition, we can find whether the trigger is an AFTER trigger or INSTEAD of trigger. Execute the following query:

select name from sys.triggers where type='TA'
select name from sys.triggers where type='TR'
select name from sys.triggers where is_instead_of_trigger=1

Find ALL SQL logins in a server

SQL SERVER 2000:

select * from master..syslogins where isntgroup=0 and isntname=0

SQL SERVER 2005:

select * from sys.sql_logins

Find ALL dependencies of the SQL Object in a Database

SQL SERVER 2000:

select * from sysdepends

SQL SERVER 2005:

select * from sys.sql_dependencies

Find ALL data types in SQL server

SQL SERVER 2000:

select * from systypes

SQL SERVER 2005:

select * from sys.systypes

Find ALL error messages in SQL server

SQL SERVER 2000:

select * from master..sysmessages

SQL SERVER 2005:

select * from sys.messages

Find ALL the database files of the current database

SQL SERVER 2000:

select name,filename from sysfiles

SQL SERVER 2005:

select name, physical_name from sys.database_files

Find the type of index

SQL SERVER 2000: We have to use indid column to determine the type of index from 0,1 or 255.

SQL SERVER 2005:

select object_name(object_id),name, type_desc  from sys.indexes where type_desc ='CLUSTERED'
select object_name(object_id),name, type_desc  from sys.indexes where type_desc ='HEAP'
select object_name(object_id),name, type_desc  from sys.indexes where type_desc ='NONCLUSTERED'
select object_name(object_id),name, type_desc  from sys.indexes where type_desc ='XML'

Google Jumps Head First Into Web Services With Google App Engine

2008-04-10T16:09:00.002+09:00

Google App Engine is designed for developers who want to run their entire application stack, soup to nuts, on Google resources. Amazon, by contrast, offers more of an a la carte offering with which developers can pick and choose what resources they want to use.

Google Product Manager Tom Stocky described the new service to me in an interview today. Developers simply upload their Python code to Google, launch the application, and can monitor usage and other metrics via a multi-platform desktop application.

More details from Google:

Today we’re announcing a preview release of Google App Engine, an application-hosting tool that developers can use to build scalable web apps on top of Google’s infrastructure. The goal is to make it easier for web developers to build and scale applications, instead of focusing on system administration and maintenance.

Leveraging Google App Engine, developers can:

Write code once and deploy. Provisioning and configuring multiple machines for web serving and data storage can be expensive and time consuming. Google App Engine makes it easier to deploy web applications by dynamically providing computing resources as they are needed. Developers write the code, and Google App Engine takes care of the rest.
Absorb spikes in traffic. When a web app surges in popularity, the sudden increase in traffic can be overwhelming for applications of all sizes, from startups to large companies that find themselves rearchitecting their databases and entire systems several times a year. With automatic replication and load balancing, Google App Engine makes it easier to scale from one user to one million by taking advantage of Bigtable and other components of Google’s scalable infrastructure.
Easily integrate with other Google services. It’s unnecessary and inefficient for developers to write components like authentication and e-mail from scratch for each new application. Developers using Google App Engine can make use of built-in components and Google’s broader library of APIs that provide plug-and-play functionality for simple but important features.

Google App Engine: The Limitations
The service is launching in beta and has a number of limitations.

First, only the first 10,000 developers to sign up for the beta will be allowed to deploy applications.

The service is completely free during the beta period, but there are ceilings on usage. Applications cannot use more than 500 MB of total storage, 200 million megacycles/day CPU time, and 10 GB bandwidth (both ways) per day. We’re told this equates to about 5M pageviews/mo for the typical web app. After the beta period, those ceilings will be removed, but developers will need to pay for any overage. Google has not yet set pricing for the service.

One current limitation is a requirement that applications be written in Python, a popular scripting language for building modern web apps (Ruby and PHP are among others widely used). Google says that Python is just the first supported language, and that the entire infrastructure is designed to be language neutral. Google’s initial focus on Python makes sense because they use Python internally as their scripting language (and they hired Python creator Guido van Rossum in 2005).
Source

Microsoft Silverlight

2008-01-14T18:33:00.003+09:00

Microsoft Silverlight is the next generation, cross browser web client, cross platform runtime. Silverlight is a lightweight subset of XAML for building rich media experiences on the web.

http://www.microsoft.com/silverlight/

Visual Studio 2008

2008-01-14T18:29:00.001+09:00

you can download the VS 2005 and SQL Server 2008 Express Edition from here :

http://www.microsoft.com/express/download/#webInstall

Open Source Web Design

2007-11-20T18:52:00.001+09:00

download free web design templates and share yours with others:

http://www.oswd.org/

10 tech skills you should develop during the next five years

2007-09-05T14:01:00.001+09:00

If you want a job where you can train in a particular skill set and then never have to learn anything new, IT isn't the field for you. But if you like to be constantly learning new things and developing new skills, you're in the right business. In the late 80s, NetWare and IPX/SPX administration were the skills to have. Today, it's all about TCP/IP and the Internet.

Let's take a look at some of the skills you should be thinking about developing to keep on top of things in the tech world in the next five years.

#1: Voice over IP

Many companies and consumers are already using VoIP for telephone services due to cost and convenience factors. According to a SearchVoIP.com article in June 2007, sales of pure IP PBX systems for the first quarter of 2007 increased 76% over the first quarter of the previous year.

More and more companies are expected to go to VoIP, to either supplement or replace their traditional phone lines. And because VoIP runs on the TCP/IP network, IT administrators will in many cases be expected to take responsibility for VoIP implementation and ongoing administration.

#2: Unified communications

Along with the growing popularity of VoIP, the concept of unified communications -- the convergence of different communications technologies, such as e-mail, voicemail, text messaging, and fax -- looks to be the wave of the future. Users will expect to have access to all their communications from a single interface, such as their Inbox, and from a variety of devices: PCs, laptops, smart phones/PDAs, traditional phones, etc.

Convergence makes networks more complex, and IT administrators will need to develop skills for managing converged networks to compete in tomorrow's job market.

#3: Hybrid networks

The day of the all-Windows or all-UNIX network is already past, and networks are likely to grow more, rather than less hybridised in the future. As new versions of Linux, such as Ubuntu, become friendlier for end users, we're likely to see some organisations deploying it on the desktop for certain users. However, it's likely that other users will continue to use Windows because of application requirements and/or personal preferences, and there may very well be Macintosh users in the mix as well, especially in graphics environments.

IT pros will no longer be able to get by with expertise in only one platform; you'll need to be able to support and troubleshoot different operating systems.

#4: Wireless technology

Wireless networking is still in its infancy in the enterprise. Companies are (often grudgingly) establishing wireless LANs for the use of employees and visitors because it's the most convenient way for portable computers to connect to the network, but many organisations are still wary of wireless (rightly so), particularly its security implications.

But wireless isn't going away, and the future promises faster and more secure wireless technologies. You'll need to know about 802.11n, a new standard now in development and estimated to be released in late 2008, which will provide for a typical throughput of 74 Mbps with a theoretical maximum data rate of 248 Mbps and a longer range than current 802.11a/b/g standards (about 70 meters, or approximately 230 feet).

#5: Remote user support

The trend is toward more employees working off-site: executives taking their laptops on the road, telecommuters working from home at least a few days per week, personnel in the field connecting back to the LAN, and so forth. The IT staff will need to be able to support these remote users while maintaining the security of the internal network.

It will be important to learn skills relating to different VPN technologies (including SSL VPN) and technologies for health monitoring and quarantining of remote clients to prevent those that don't meet minimal criteria (antivirus installed and updated, firewall enabled, etc.) from connecting to the LAN and putting the rest of the network at risk.

#6: Mobile user support

Cell phones, Blackberries, and other ultra-portable devices are becoming ubiquitous and will likely grow more sophisticated in the future. Employees will expect to get their corporate e-mail on their phones and in some cases (such as Windows Mobile devices), to use terminal services client software to connect these small devices to the company LAN.

IT staff members will need to develop a plethora of skills to support mobile users, including expertise in configuration of mail servers and knowledge of security implications of the devices.

#7: Software as a service

Web 2.0, the next generation of the Internet, is all about SaaS, or Software as a Service. SaaS involves delivering applications over the Web, rather than installing those applications on individual users' machines. Some IT pundits have warned that SaaS will do away with IT administrators' jobs entirely, but the more likely scenario is that the job description will change to one with less focus on deployment and maintenance of applications and more emphasis on broader-based planning, convergence, etc.

If SaaS takes off, the job market may also shift so that more jobs are concentrated in the application provider sector rather than in companies' in-house IT departments. In that situation, IT pros who have the skills relating to service provision and multi-tenant architecture will have a head start when it comes to getting and staying employed.

#8: Virtualisation

Virtualisation has been around for a while, but now, with Microsoft heavily investing in the technology with its Windows hypervisor (Viridian), which will run on Windows Server 2008, VMWare offering VMWare Server for free, and Red Hat and SuSE planning to include Xen hypervisor technology in the next versions of their server products, we can expect the concept of virtual machines to go to a whole new level in the next few years.

Managing a VM-based network environment is a skill that will be not just handy, but essential, as more and more companies look to virtualisation to consolidate servers and save on hardware costs.

#9: IPv6

Widespread adoption of the next generation of the Internet Protocol (IPv6) hasn't come about as quickly as originally predicted, in large part because technologies such as NAT prevented the depletion of available IP addresses from happening as soon as anticipated.

However, with the number of hosts on the Internet growing steadily, the larger address space will eventually be critical to further expansion. IPv6 also offers better security with IPsec, a part of the basic protocol suite. Perhaps the inevitability of the transition is best indicated by the fact that Windows Vista, Windows Server 2008, Mac OS X 10.3, and the latest versions of other operating systems have IPv6 enabled by default.

With an entirely different address notation, called CIDR, and addresses written in hexadecimal instead of the familiar four octets of decimal numbers used by IPv4, there will be a learning curve for IT administrators. The time to tune up your IPv6 skills is now, before the transition becomes mandatory.

#10: Security

Smart IT pros have been developing their security skills for the last several years, but the future will bring new security challenges and new security mechanisms. Technologies such as VoIP and mobile computing bring new security issues and challenges. Authentication methods are evolving from a password-based model to multifactor models, and biometrics are likely to become more important in the future.

As threats become more sophisticated, shifting from teenage hackers defacing Web sites "just for fun" to well financed corporate espionage agents and cyberterrorists bent on bringing down the country's vital infrastructure by attacking the networks that run it, security skills must keep up.

In addition to proactive measures, IT pros will need to know more about computer forensics and be able to track what is happening and has happened on their networks.

Microsoft Visual Studio 2008

2007-08-06T20:27:00.001+09:00

The next version of Visual Studio, Microsoft® Visual Studio® 2008, will provide an industry-leading developer experience for Windows Vista, the 2007 Microsoft Office system, and the Web. In addition, it will continue in the Microsoft tradition of development language innovation.

Adobe's ColdFusion warms to .Net

2007-05-30T17:44:00.001+09:00

San Francisco (InfoWorld) - Adobe's ColdFusion software for building Internet applications and Web sites is being improved with Microsoft .Net support, enabling .Net objects to be invoked from within the ColdFusion language.

A public beta of ColdFusion 8, accessible here, is to be offered on Wednesday. The general release is set for mid-year. Version 8 is the first Adobe-branded release of the former Macromedia technology.

ColdFusion is a server-side Java application; it is partnered with a markup language for writing ColdFusion applications. .Net support in the upcoming version 8 bridges the Java and Microsoft worlds.

"Customers don't need to select one technology to the exclusion of the other," Tim Buntel, Adobe senior product marketing manager, said.

Also featured in ColdFusion 8 is generation of PDF documents as well as capabilities for working with PDF forms and manipulating existing PDF documents. Support for the JBoss application server has been added, also.

For developers, Adobe is adding interactive debugging based on the Eclipse IDE. A Server Monitor capability, meanwhile, identifies bottlenecks in the server.

Adobe's Flex rich Internet application technology and AJAX (Asynchronous JavaScript and XML) components are leveraged in the new product for integration of complex environments with intuitive interfaces, Adobe said.

ColdFusion differs from Flex in that Flex is a client-side technology featuring a language and compiler to convert code to Flash content. With ColdFusion, the server-side technology can integrate with databases and Java and .Net objects while also offering text searching. However, ColdFusion also can generate an HTML interface for Web applications.

The ColdFusion upgrade puts to rest questions about Adobe's commitment to the technology after acquiring Macromedia, said analyst Ray Valdes, research director for Internet platforms and Web services at Gartner.

"People may have wondered if Adobe appreciated ColdFusion, and I think they do. I think it's part of their enterprise software strategy," Valdes said.

While Adobe recently offered the Flex software development kit to the community at large via open source, there are no plans to open-source ColdFusion. This stance gives the company the ability to make certain ColdFusion integrates with other Adobe technologies, Buntel said.

Yahoo News

"Server Error in '/application name' Application"

2007-03-09T21:55:00.001+09:00

You may receive the Error Message "Server Error in '/application name' Application" while browsing an asp.net application.

You may receive the following error message while browsing an asp.net application.

"Server Error in '/application name' Application
------------------------------------------------

Runtime Error Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine.

Details: To enable the details of this specific error message to be viewable on remote machines, please create a tag within a "web.config" configuration file located in the root directory of the current web application. This tag should then have its "mode" attribute set to "Off".

This error might occur due to two scenarios.

1. There is an error in the application's logic with the inputformat, Type etc., and you have set the Custom Error Mode in the web.config to "On" and not specified a default redirect error page.

2. The web.config file is not well formed or having invalid characters and the application is not able to pick up the settings from the same.

Solution

1. Set the custom error mode to "Off" to view the error.
After rectifying it and before deployment, change it to "On" and specify a default error page, as follows:-

such that your users will not be able to see the actual error and get your friendly error page where you can politely say "An error has occured! Contact the Application Help Support ..." .

2. If the above solution is not working (i.e. even after setting the custom error mode to On, the same "Server Error" occurs, then the likely chance is that your web.config file is not well formed and has invalid characters etc.,

To resolve, it copy paste the contents of the file to a notepad, save it as an xml file and try to browse the xml file in the browser. If the xml file is unable to be rendered by the browser and throws error, then you can find the place where the tags are not well formed or invalid character(s) exist and rectify them.

Things worth noting is Web.config is case sensitive (off, oFF,..etc) and even trailing/leading spaces can cause the above error.

you will encounter the same problem at the time of hosting a website to a remote webserver. Eventhough once you have change the web.conf you will get that above message.

solution is to check whether is to make sure that you have given appropriate/suitable permission to the folders like App_Data & to double check the .NET version.

hope all you guys can learn something about the above problem.

:-)

Visual Studio Add-Ins Every Developer Should Download Now

2007-02-19T19:46:00.001+09:00

Tools for unit testing
Tools for code and documentation management and generation
Tools for modifying the development environment
Tools for working with data

More Details

POS for .NET and OPOS

2007-02-10T16:50:00.001+09:00

OPOS is an existing implementation of UPOS for Microsoft Windows, based on Component Object Model (COM) technology. POS for .NET constitutes an improved, next-generation implementation of UPOS for Microsoft Windows, based on .NET. In comparison to OPOS, POS for .NET increases productivity of developers of both POS applications and service objects, by providing all the benefits of .NET managed code while at the same time exposing a set of easy to use interfaces and base classes.

POS for .NET is backward-compatible with OPOS version 1.8 service objects. In other words, applications using POS for .NET can simultaneously interact with .NET service objects written for POS for .NET and OPOS service objects.

POS for .NET Device Basic Classes

Each hardware device in POS for .NET is represented by both an abstract interface, such as CashDrawer class, and a “basic” class, such as CashDrawerBasic. Basic classes derive from the underlying interface and contain basic functional support for the device. POS for .NET provides generic support for opening, claiming, and enabling the device; device statistics; and management of delivery of events to the application. In addition, each basic class contains a set of inherited and protected methods that can be implemented by the service object. This topic provides summary information about basic classes that can be used by service objects that wish to derive from the device’s basic class, rather than taking advantage of the more fully implemented device base class

http://msdn2.microsoft.com/en-us/library/ms827970.aspx

New ConfigurationManager in VS 2005

2007-02-06T18:44:00.001+09:00

Using .NET Framework 1.1 i have used following code to pull a encrypted connection string from the app.conf file, I used....
System.Configuration.ConfigurationSettings.AppSettings["connstr"].ToString();

And the compiler gave me the following error.
Warning 1 'System.Configuration.ConfigurationSettings.AppSettings' is obsolete: 'This method is obsolete, it has been replaced by ConfigurationManager.AppSettings'

So I try and change my Code to the following ...
System.Configuration.ConfigurationManager.AppSettings["connstr"].ToString();

and I get a compiler error, saying the compiler can't find ConfigurationManager.

Well here's the confusion.... The Original System.Configuration.ConfigurationSettings class is found in the System.dll assembly. There is a new assembly with all the new ConfigurationManager classes as System.Configuration.dll. Before using the ConfigurationManager class, you must first set a reference to the new System.Configuration.dll.

Add a reference to System.Configuration by clicking Project -> Add Reference... and searching through the .NET components for System.Configuration

Mobiles to get portable hard drives

2007-02-02T19:56:00.001+09:00

The first portable hard drives for phones are coming onto the market, promising a "multimedia revolution".

Seagate launched its Digital Audio Video Experience (Dave) range of mobile hard drives on 30th Jan 2007, which consist of a 1cm thick credit card sized unit storing 10GB to 20GB of storage and communicating with phones via Bluetooth.

The devices have a range of around 30ft and battery life of 14 days standby or 10 hours use. No pricing details have yet been released.

"Mobile telephony is undergoing a multimedia revolution, and the Dave mobile content platform will provide even more fuel for the growth of new music and video services over mobile networks," said Patrick King, senior vice president and general manager of Seagate's consumer electronics business unit.

"Products using Dave will enable digital content for business or entertainment to be stored, moved and connected in ways never before possible."

But Seagate has been beaten to the punch on the technology by Agere Systems with a similar device, the BlueOnyx, that can communicate via Bluetooth or Wi-Fi and can store up to 40GB.
Models are also available with USB and SD card ports, and costs range from £50 to £130.
"We wanted to create a highly mobile device that solves a lot of the connectivity issues consumers have while giving them all the storage they want at an affordable price," said Ruediger Stroh, general manager of Agere's storage division.

"The capability will finally make the PC just another consumer device instead of the centre of the digital universe."

Source: vnunet

ADO.NET Connection Strings

2007-02-02T19:34:00.001+09:00

ODBC Driver for Excel

strConnection = _T("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;" bq=C:\\DatabasePath\\DBSpreadSheet.xls;
DefaultDir=c:\\databasepath;");

ODBC Driver for Text
strConnection = _T("Driver={Microsoft Text Driver (*.txt; *.csv)};" "Dbq=C:\\DatabasePath\\;Extensions=asc,csv,tab,txt;");

Refer Connectionstrings

Articles

2007-01-24T20:26:00.001+09:00

Interesting articles:

JavaScript with ASP.NET 2.0 Pages - Part 1
dotnetslackers.com

DATA POINTS
Revisiting System.Transactions
MSDN Article

SENDING EMAIL USING ASP.NET 2.0

2007-01-24T20:22:00.001+09:00

Just thought to share my code which i used to implement a simple Mail System. Hope this might help you!

Imports System.Net.Mail

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles SendEmail.Click
Dim Msg As MailMessage = New MailMessage()
Dim MailObj As New SmtpClient
Try
Msg.From = New MailAddress(UsersEmail.Text, "Andy")
Msg.To.Add(New MailAddress("ammarfassy@gmail.com", "Author"))
MailObj.Host = "192.168.16.70"
MailObj.Port = 25
Msg.IsBodyHtml = "False"
Msg.Body = Body.Text
Msg.Subject = Subject.Text
MailObj.Send(Msg)
Label1.Text = "Email Sent!"
Catch ex As Exception
Label1.Text = ex.Message
End Try
End Sub

Add your IP Address (local) in your SMTP server & under the properies add the same IP address to Relay Restrictions (Grant & deny permissions to relay email through this SMTP virutal server).

The sent email will be a spam email!

extra notes on this:

under web.config under

namespace System.Net.Mail;

string UserName = System.Configuration.ConfigurationManager.AppSettings["smtpUsername"];
string Password = System.Configuration.ConfigurationManager.AppSettings["smtpPassword"];
string Host = System.Configuration.ConfigurationManager.AppSettings["smtpServer"]; string sFrom = "me@doman.com";
string sTo;
string sSubject = "sample subject";
string sBody = "sample html body";

string toAddress = "myaddress@someotherdomin.com,myaddress2@someotherdomin.com";
string msgSubject = sSubject;
string msgBody = sBody;

SmtpClient client = new SmtpClient(Host);
MailAddress from = new MailAddress(sFrom);
MailAddress to = new MailAddress(toAddress);
MailMessage message = new MailMessage(from, to);
message.Priority = MailPriority.High;
message.IsBodyHtml = true;

System.Net.NetworkCredential NTLMAuthentication = new System.Net.NetworkCredential(UserName, Password);
message.Subject = msgSubject;
message.Body = msgBody;
client.UseDefaultCredentials = false;
client.Credentials = NTLMAuthentication;
client.Send(message);

.NET Framework 3.0 is released!

2007-01-05T21:19:00.001+09:00

The .NET Framework 3.0 has officially been released! You can download the .NET Framework 3.0 components here:

.NET Framework 3.0 Runtime Components
Windows SDK for Vista and the .NET Framework 3.0
Visual Studio 2005 Extensions for .NET Framework 3.0 (Windows Workflow Foundation)
Visual Studio 2005 Extensions for .NET Framework 3.0 (WCF & WPF), November 2006 CTP

Note, if you are using Windows Vista the .NET Framework 3.0 Runtime Components are installed by default.

MAZDA 3

2007-01-04T16:46:00.001+09:00

WELCOME 2007

2007-01-01T16:37:00.001+09:00

Life is like having a cup of tea.
You sit by the side of the window, lift the cup and take a careless sip, Only to realize, somebody forgot to put the sugar. Too lazy to go for it you somehow struggle through the sugarless cup. Until you discover un-dissolved sugar crystal sitting at the bottom...

---That's Life---

I wish you Health...

So you may enjoy each day in comfort.
I wish you the Love of friends and family...

And Peace within your heart.
I wish you the Beauty of nature...

That you may enjoy the work of God.
I wish you Wisdom to choose priorities.. .

For those things that really matter in life.
I wish you Generousity so you may share...

All good things that come to you.
I wish you Happiness and Joy...

And Blessings for the New Year.
I wish you the best of everything.. .

That you so well deserve.

Happy New Year!

Chicken Guinea

2006-12-26T21:38:00.002+09:00

What a fever is this? Chicken Gunea!

i had to stay @ Home for around 5 days because of this Fever & had to suffer a lot coz of this fever!

Chicken Guinea is a high fever accompanied wit joint stiffness & pains when bit by a mutant mosquitoes (usually with white patches over the legs & are usually seen only in the day light) symptons- high fever with joint pains & stiffness lasting for 4 days causes - 1 and only cause is by mosquito bite and is deadly in some cases if ignored.

Doctor asked only for Rest+have liquid stuffs for Hungry! Anyhow once the fever is over i cant eat anything coz the i wont feel any taste of anything! For that only liquid stuffs is good! Thanks my mama & for my family siblings to help me in this situation! I pray Almighty to not to give this fever for anyone!

An attempt to attach an auto-named database for file "C:\AAA\database.mdf" failed. A database with the same name exists, or specified file cannot be o

2006-11-16T12:52:00.001+09:00

This one of the next headache you have to solve at the time of hosting your application in any web server, and its as follows:

An attempt to attach an auto-named database for file c:\hosting\webhost4life\member\shanti23\aba\LatestABAWebsite\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

we have to add following few lines to the App.conf file as below:

just refer the link: http://dotnetforum.lk/blogs/ammar/default.aspx

alternatively you can rename the database at the time of deploying the web application if any further exception bugged you! hopes this will help you all!

Exception Details: System.Data.SqlClient.SqlException: Failed to update database.

2006-11-16T12:31:00.002+09:00

i would like to share my experience with you all because when you started working with SQL Server Express 2005 you have to encounter probelms like one of which am i going to explain you in this blog entry: hopes it will helps you to not to search it for the same problem throughout days or months, as i have to search it for the solution for many days!

Exception Details: System.Data.SqlClient.SqlException: Failed to update database "c:\hosting\webhost4life\member\abc23\aba\LatestABAWebsite\App_Data\aspnetdb.mdf" because the database is read-only.

This will happen mainly coz of the folder permission that we have to apply for the App_data folder: so to rectify this problem you have to follow these steps:

After selecting the 'properties' on the "App_Data" directory,

1. Select the security tab
2. CLick on Add... under "Group or User names:" table
3. On the next window, select Advanced, another window appears and on this, select or rather click on "find now" and a list of Groups and Users should appear on the bottom table.
4. Click on ASPNET followed by OK, and the same on the next 2 windows.

if you need to enable the security tab in Windows XP Professional you have to uncheck the setting for "Use simple file sharing (recommended)" under the View tab in the Folder Options control panel applet to enable the Security tab to be displayed. after that you can be able to view the security tab when you viewed any folder properties.

App_Offline.htm

2006-11-16T12:18:00.001+09:00

If you place a file with this name in the root of a web application directory, ASP.NET 2.0 will shuts-down the current web application, unloads the web application from the domain server, and stops processing any new incoming requests for that application.

ASP.NET will also then responds to all requests for dynamic pages in the application by sending back the content of the app_offline.htm file.

For example: you might want to have a “Site is under construction” or “the current website is down for maintenance” or "Uploading Changes" message.

This is one of the convenient & easy way to take down your application while you are making big changes or copying lots of new page functionality (at the same time you can avoid the annoying problem of people hitting and activating your site in the middle of a content update). It can also be a useful way to immediately unlock and unload a SQL Express 2005 database whose .mdf data files are residing in the /app_data directory. This will be applicable for the Access (*.mdb) files too!

Once you have removed the app_offline.htm file from the root, the very next request into the web application will cause ASP.NET to load the application and application domain again, and life will continue along as normal.

AFTER A LONG TIME BACK RESTARTED BLOGGING

2006-11-02T13:56:00.001+09:00

hii,

restarted blogging! i was so busy for last few months as i have joined with a new company here in colombo!

hope to see you all soon.

Ammar.

The Haditha Massacre

2006-07-11T19:36:00.001+09:00

Genocide In Iraq

http://www.prisoners.com/hadithai.html

http://www.albasrah.net/en_articles_2006/0406/GI%20Special%204D12%20The%20Haditha%20Massacre_120406.htm

What is a Packet Sniffer?

2006-06-27T18:50:00.002+09:00

A packet sniffer is a device or program that allows eavesdropping on traffic traveling between networked computers. The packet sniffer will capture data that is addressed to other machines, saving it for later analysis.

All information that travels across a network is sent in "packets." For example, when an email is sent from one computer to another, it is first broken up into smaller segments. Each segment has the destination address attached, the source address, and other information such as the number of packets and reassembly order. Once they arrive at the destination, the packet's headers and footers are stripped away, and the packets reconstituted.

In the example of the simplest network where computers share an Ethernet wire, all packets that travel between the various computers are "seen" by every computer on the network. A hub broadcasts every packet to every machine or node on the network, then a filter in each computer discards packets not addressed to it. A packet sniffer disables this filter to capture and analyze some or all packets traveling through the ethernet wire, depending on the sniffer's configuration. This is referred to as "promiscuous mode." Hence, if Ms. Wise on Computer A sends an email to Mr. Geek on Computer B, a packet sniffer set up on Computer D could passively capture their communication packets without either Ms. Wise or Mr. Geek knowing. This type of packet sniffer is very hard to detect because it generates no traffic of its own.

A slightly safer environment is a switched Ethernet network. Rather than a central hub that broadcasts all traffic on the network to all machines, the switch acts like a central switchboard. It receives packets directly from the originating computer, and sends them directly to the machine to which they are addressed. In this scenario, if Computer A sends an email to Computer B, and Computer D is in promiscuous mode, it still won't see the packets. Therefore, some people mistakenly assume a packet sniffer cannot be used on a switched network.

But there are ways to hack the switch protocol. A procedure called ARP poisoning basically fools the switch to substituting the machine with the packet sniffer for the destination machine. After capturing the data, the packets can be sent to the real destination. The other technique is to flood the switch with MAC (network) addresses so that the switch defaults into "failopen" mode. In this mode it starts behaving like a hub, transmitting all packets to all machines to make sure traffic gets through. Both ARP poisoning and MAC flooding generate traffic signatures that can be detected by packet sniffer detection programs.

A packet sniffer can also be used on the Internet to capture data traveling between computers. Internet packets often have very long distances to travel, passing through several routers that act like intermediate post offices. A packet sniffer might be installed at any point along the way. It could also be clandestinely installed on a server that acts as a gateway or collects vital personal information.

A packet sniffer is not just a hacker's tool. It can be used for network troubleshooting and other useful purposes. However, in the wrong hands, a packet sniffer can capture sensitive personal information that can lead to invasion of privacy, identity theft, and other serious eventualities.
The best defense against a packet sniffer is a good offense: encryption. When strong encryption is used, all packets are unreadable to any but the destination address, making packet sniffers useless. They can still capture packets, but the contents will be undecipherable. This illustrates why it is so important to use secure sites to send and receive personal information, such as name, address, passwords, and certainly any credit card information or other sensitive data. A website that uses encryption starts with https. Email can be made secure by encrypting with a program like PGP (Pretty Good Privacy), which comes with seamless plug-ins for all major email programs.

What is SSL (Secure Sockets Layer)?

2006-06-27T18:42:00.002+09:00

SSL or Secure Sockets Layer is a security protocol created by Netscape that has become an international standard on the Internet for exchanging sensitive information between a website and the computer communicating with it, referred to as the client.

SSL technology is embedded in all popular browsers and engages automatically when the user connects to a web server that is SSL-enabled. It's easy to tell when a server is using SSL security because the address in the URL window of your browser will start with https. The "s" indicates a secure connection.

When your browser connects to an SSL server, it automatically asks the server for a digital Certificate of Authority (CA). This digital certificate positively authenticates the server's identity to ensure you will not be sending sensitive data to a hacker or imposter site. The browser also makes sure the domain name matches the name on the CA, and that the CA has been generated by a trusted authority and bears a valid digital signature. If all goes well you will not even be aware this handshake has taken place.

However, if there is a glitch with the CA, even if it is simply out of date, your browser will pop up a window to inform you of the exact problem it encountered, allowing you to end the session or continue at your own risk.

Once the handshake is completed, your browser will automatically encrypt all information that you send to the site, before it leaves your computer. Encrypted information is unreadable en route. Once the information arrives at the secure server, it is decrypted using a secret key. If the server sends information back to you, that information is also encrypted at the server's end before being sent. Your browser will decrypt it for you automatically upon arrival, then display it as it normally does.
For those running a secure server it is also possible to authenticate the client connecting to the server to ensure, for example, that the person is not pretending to be someone who has been granted restricted access. Another feature of SSL technology is the ability to authenticate data so that an interceder cannot substitute another transmission for the actual transmission without being detected.

Though SSL makes exchanging sensitive information online secure, it cannot guarantee that the information will continue to be kept secure once it arrives safely at the server. For assurance that sensitive information is handled properly once it has been received, you must read the site's privacy policy. It does little good to trust your personal data to SSL, if the people who ultimately have it will be sharing it with third parties, or keeping it on servers that are not bound by restricted access and other security protocols. Therefore it is always wise to read any site's privacy policy, which includes security measures, before volunteering your personal information online.

What are Computer Cookies?

2006-06-27T18:35:00.001+09:00

A computer cookie is a small text file which contains a unique ID tag, placed on your computer by a website. The website saves a complimentary file with a matching ID tag. In this file various information can be stored, from pages visited on the site, to information voluntarily given to the site. When you revisit the site days or weeks later, the site can recognize you by matching the cookie on your computer with the counterpart in its database.

There are two types of cookies: temporary and permanent.

Temporary cookies, also called session cookies, are stored temporarily in your browser's memory and are deleted as soon as you end the session by closing the browser.

Permanent cookies, also called persistent cookies, are stored permanently on your computer's hard drive and, if deleted, will be recreated the next time you visit the sites that placed them there.

Cookie technology addressed the need to keep track of information entered at a site so that if you submitted a registration form for example, the site could associate that information with you as you traveled through the site's pages. Otherwise, every time you clicked on a different page in the site, establishing a new connection, the site would lose the information in reference to you, and would have to ask you for it again.

A temporary cookie solved this problem in the short term by setting aside a little bit of your browser's memory to make a "folder" to save information for you. But temporary cookies were lost as soon as you closed your browser. You were not recognized on subsequent visits.

Persistent cookies solved this problem. They allowed a site to recognize you permanently by transferring a text file to your computer with a unique ID tag, matching a complimentary file on the server. Now cookies could persist for years.

Both temporary and permanent cookies can be used for many helpful purposes. Automatic registration log-on, preserving website preferences, and saving items to a shopping cart are all examples of cookies put to good use.

But permanent cookies resulted in unanticipated uses as well.

Many websites began keeping track of when an individual visited, what pages were viewed, and how long the visitor stayed. This information was stored in the visitor's cookie. When he returned, the log of previous visits to the site was immediately known, and the new visit was added to his log. If the visitor ever offered personal information at the site, his real identity, address and other personal information was associated with the anonymous ID tag. Website profiling was born.

Marketers had an even more unique advantage. A given marketer may have advertising rights on several hundred or even many thousands of the most popular websites. In this way the marketer can pass cookies to surfers on countless sites, then recognize a surfer's unique ID tag whenever he or she visits one of their affiliated sites. In this way the marketer can track someone across the web, from site to site, logging a comprehensive profile of the individual's surfing habits over a period of months and even years. Sophisticated profiling programs then sort the data provided by the cookie to categorize the target in several different areas, based on statistical data. Gender, race, income level, political leanings, religious affiliation and even sexual orientation can all be determined with various degrees of accuracy through cookie profiling. Much depends on how much a person surfs, and where they choose to go online.

As a result of public outcry in response to surreptitious profiling, cookie controls were placed in post 3.x browsers to allow users to turn cookies off -- options that were not available in 1995 when permanent cookie technology was first embedded into browsers without public awareness or knowledge of how they could be used. Third-party cookies often have their own controls, as they are normally cookies placed by marketers that are used for profiling.

Cookie controls also allow user-created lists for exceptions, so that one can turn cookies off, for example, but exempt sites where cookies are put to a useful purpose.

The name "cookie" comes from fortune cookie, because of the hidden information inside.

What is RSS (Really Simple Syndication)?

2006-06-27T18:31:00.001+09:00

RSS or Really Simple Syndication is a useful tool for keeping updated on your favorite websites. RSS makes use of an XML code that constantly scans the content of a website for updates and then broadcasts those updates to all subscribers through a feed.

RSS feeds are typically used with news sites or blogs, although any website can use them to disseminate information. When an update is sent out, it includes a headline and a small amount of text, either a summary or the lead-in to the larger story. You will need to click a link to read more.

In order to receive RSS feeds, you must have an aggregator, a feed reader. There are a number of aggregators online, many of them free, so with a little bit of searching, you should be able to find an interface that appeals to you. In addition to being available on your computer, RSS feeds can also be read on PDAs and cell phones.

When you come across a website you would like to add to your aggregator, you can do so in one of two ways. Most sites that offer an RSS feed have an "RSS" or "XML" button on their homepage that you can click on and it will instantly add that feed to your aggregator. Depending on your aggregator, you may instead need to copy and paste the URL of the feed into the program.

By either method, the feed will be available as soon as you've added it, and your next update could arrive in seconds. If you ever decide that you don't want to receive updates anymore, you simply delete the feed or URL from your aggregator.

Perhaps you already receive information on website updates through some sort of e-mail newsletter. RSS feeds are preferable to newsletter updates because they are instantaneous; you don't have to wait until a designated day of the week to receive your summary. They will also never be held up by a spam filter.

RSS feeds are used daily by the people who realize the convenience of up-to-the-minute news and reports and the time they can save reading only those updates interested for them rather digging into older stuff again and again, and they look to become even more popular in the future.

101 Simple ways to Brighten Some Ones Day

2006-06-27T12:57:00.001+09:00

Call an old friend, just to say hi.
Hold a door open for a stranger.
Invite someone to lunch.
Compliment someone on his or her appearance.
Ask a coworker for their opinion on a project.
Bring cookies to work.
Let someone cut in during rush hour traffic.
Leave a waitress or waiter a big tip.
Tell a cashier to have a nice day.
Call your parents.
Let someone know you miss them.
Treat someone to a movie.
Let a person know you really appreciate them.
Visit a retirement center.
Take a child to the zoo.
Fill up your spouse's car with gas.
Surprise someone with a small gift.
Leave a thank-you note for the cleaning staff at work.
Write a letter to a distant relative.
Tell someone you thought about them the other day.
Put a dime in a stranger's parking meter before the time expires.
Bake a cake for a neighbor.
Send someone flowers to where they work.
Invite a friend to tea.
Recommend a good book to someone.
Donate clothing to a charity.
Offer an elderly person a ride to where they need to go.
Bag your own groceries at the checkout counter.
Give blood.
Offer free baby-sitting to a friend who's really busy or just needs a break.
Help your neighbor rake leaves or shovel snow.
Offer your seat to someone when there aren't any left.
Help someone with a heavy load.
Ask to see a store's manager and comment on the great service.
Give your place in line at the grocery store to someone who has only a few items.
Hug someone in your family for no reason.
Wave to a child in the car next to you.
Send a thank-you note to your doctor.
Repeat something nice you heard about someone else.
Leave a joke on someone's answering machine.
Be a mentor or coach to someone.
Forgive a loan.
Fill up the copier machine with paper after you're done using it.
Tell someone you believe in them.
Share your umbrella on a rainy day.
Welcome new neighbors with flowers or a plant.
Offer to watch a friend's home while they're away.
Ask someone if they need you to pick up anything while you're out shopping.
Ask a child to play a board game, and let them win.
Ask an elderly person to tell you about the good old days.
During bad weather, plan an indoor picnic with the family.
Buy someone a goldfish and bowl.
Compliment someone on their cooking and politely ask for a second helping.
Dance with someone who hasn't been asked.
Tell someone you mentioned them in your prayers.
Give children's clothes to another family when your kids outgrow them.
Deliver extra vegetables from your garden to the whole neighborhood.
Call your spouse just to say, I love you.
Call someone's attention to a rainbow or beautiful sunset.
Invite someone to go bowling.
Figure out someone's half-birthday by adding 182 days, and surprise them with a cake.
Ask someone about their children.
Tell someone which quality you like most about them.
Brush the snow off of the car next to yours.
Return your shopping cart to the front of the store.
Encourage someone's dream, no matter how big or small it is.
Pay for a stranger's cup of coffee without them knowing it.
Leave a love letter where your partner will find it.
Ask an older person for their advice.
Offer to take care of someone's pet while they're away.
Tell a child you're proud of them.
Visit a sick person, or send them a care package.
Join a Big Brother or Sister program.
Leave a piece of candy on a coworker's desk.
Bring your child to work with you for the afternoon.
Give someone a recording of their favorite music.
Email a friend some information about a topic they are especially interested in.
Give someone a homemade gift.
Write a poem for someone.
Bake some cookies for your local fire or police department.
Organize a neighborhood cleanup and have a barbecue afterwards.
Help a child build a birdhouse or similar project.
Check in on an old person, just to see if they're okay.
Ask for the recipe after you eat over at someone's house.
Personally welcome a new employee at work and offer to take them out for lunch.
While in a car, ask everyone to buckle up because they are important to you.
Let someone else eat the last slice of cake or pizza.
Stop and buy a drink from a kid's lemonade stand.
Forgive someone when they apologize.
Wave to someone looking for a parking space when you're about to leave a shopping center.
Send a copy of an old photograph to a childhood friend.
Leave a pint of your spouse's favorite flavor of ice cream in the freezer with a bow on it.
Do a household chore that is usually done by someone else in the family.
Be especially happy for someone when they tell you their good news.
Compliment a coworker on their role in a successful project.
Give your spouse a spontaneous back rub at the end of the day.
Serve someone in your family breakfast in bed.
Ask someone if they've lost weight.
Make a donation to a charity in someone's honor.
Take a child to a ballgame.And last, but not least...
WITH LOVE...ammar

Restarted Blogging

2006-06-23T14:26:00.001+09:00

mmmm..........restared to blogging on blogspot! coz of busy schedule i was unable to blog too! :0

What is managed code?

2006-04-22T15:13:00.001+09:00

Recently I have been working on pulling together some background information just to improve my knowledge bit further and I thought I'd share it here.

What is managed code?

Managed code is code that has its execution managed by the .NET Framework Common Language Runtime. It refers to a contract of cooperation between natively executing code and the runtime. This contract specifies that at any point of execution, the runtime may stop an executing CPU and retrieve information specific to the current CPU instruction address. Information that must be query-able generally pertains to runtime state, such as register or stack memory contents.

The necessary information is encoded in an Intermediate Language (IL) and associated metadata, or symbolic information that describes all of the entry points and the constructs exposed in the IL (e.g., methods, properties) and their characteristics. The Common Language Infrastructure (CLI) Standard (which the CLR is the primary commercial implementation) describes how the information is to be encoded, and programming languages that target the runtime emit the correct encoding. All a developer has to know is that any of the languages that target the runtime produce managed code emitted as PE files that contain IL and metadata. And there are many such languages to choose from, since there are nearly 20 different languages provided by third parties – everything from COBOL to Camel – in addition to C#, J#, VB .Net, Jscript .Net, and C++ from Microsoft.

Before the code is run, the IL is compiled into native executable code. And, since this compilation happens by the managed execution environment (or, more correctly, by a runtime-aware compiler that knows how to target the managed execution environment), the managed execution environment can make guarantees about what the code is going to do. It can insert traps and appropriate garbage collection hooks, exception handling, type safety, array bounds and index checking, and so forth. For example, such a compiler makes sure to lay out stack frames and everything just right so that the garbage collector can run in the background on a separate thread, constantly walking the active call stack, finding all the roots, chasing down all the live objects. In addition because the IL has a notion of type safety the execution engine will maintain the guarantee of type safety eliminating a whole class of programming mistakes that often lead to security holes.

Contrast this to the unmanaged world: Unmanaged executable files are basically a binary image, x86 code, loaded into memory. The program counter gets put there and that’s the last the OS knows. There are protections in place around memory management and port I/O and so forth, but the system doesn’t actually know what the application is doing. Therefore, it can’t make any guarantees about what happens when the application runs

Managed code is code executed by a .NET virtual machine, such as Microsoft's .NET Framework Common Language Runtime, The Mono Project, or DotGNU Project.

In a Microsoft Windows environment, all other code has come to be known as unmanaged code. In non-Windows and mixed environments, managed code is sometimes used more generally to refer to any interpreted programming language.

Managed refers to a method of exchanging information between the program and the runtime environment. It is specified that at any point of execution, the runtime may stop an executing CPU and retrieve information specific to the current CPU instruction address. Information that must be accessible generally pertains to runtime state, such as processor register or stack memory contents.

The necessary information is then encoded in Common Intermediate Language (formerly known as Microsoft Intermediate Language) and associated metadata.

Before the code is run, the Intermediate Language is compiled into native machine code. Since this compilation happens by the managed execution environment's own runtime-aware compiler, the managed execution environment can guarantee what the code is going to do. It can insert garbage collection hooks, exception handling, type safety, array bounds, index checking, etc.

This is traditionally referred to as Just-in-time compilation. However, unlike most traditional just in time compilers, the file that holds the pseudo machine code that the virtual machine compiles into native machine code can also contain pre-compiled binaries for different native machines (eg x86 and PowerPC). This is similar in concept to the Apple Universal binary format.

My DNA Test

2006-03-17T13:22:00.003+09:00

Do this test and get You PersonalDNA. This nice test from http://personaldna.comAnd this my result. How about you

How to recruit the right person for the job?

2006-03-17T12:28:00.002+09:00

Put about 100 bricks in some
particular order in a closed
room with an
open window.

Then send 2 or 3 candidates in
the room and close the door.
Leave them alone and come back
after 6 hours and then analyze
the situation.

If they are counting the
bricks.
Put them in the accounts
department.

If they are recounting them..
Put them in auditing.

If they have messed up the
whole place with the bricks.
Put them in engineering.

If they are arranging the
bricks in some strange order.
Put them in planning.

If they are throwing the
bricks at each other.
Put them in operations.

If they are sleeping.
Put them in security.

If they have broken the bricksinto pieces.
Put them in information
technology.

If they are sitting idle.
Put them in human resources.

If they say they have tried
different combinations, yet
not a brick has
been moved.
Put them in sales.

If they have already left for
the day.
Put them in marketing.

If they are staring out of the
window.
Put them on strategic
planning.

And then last but not least.
If they are talking to each
other and not a single brick
has been
moved.
Congratulate them and put them
in top management.

Office "12"

2006-03-13T15:18:00.001+09:00

The 2007 Microsoft Office release, available by the end of 2006, is an integrated system of programs, servers, and services that will help you meet your business and personal needs. Work more efficiently, stay organized, and more easily collaborate and share information using the security-enhanced 2007 Microsoft Office system.

Register to get the latest news about the 2007 Microsoft Office release, formerly code-named Office "12", including notification when Beta 2 is available.

By default, documents created in the next release of Microsoft Office products will be based on new, XML-based file formats. Distinct from the binary-based file format that has been a mainstay of past Microsoft Office releases, the new Office XML Formats are compact, robust file formats that enable better data integration between documents and back-end systems. An open, royalty-free file format specification maximizes interoperability in a heterogeneous environment, and enables any technology provider to integrate Microsoft Office documents into their solutions.

The new Office XML Formats introduce a number of benefits not only for developers and the solutions they build, but also for individual users and organizations of all sizes.

http://www.microsoft.com/office/preview/suites.mspx

World's Fastest, Most Expensive Car Hits the Market

2006-03-10T12:16:00.001+09:00

Bugatti Veyron Costs More Than $1 Million, Can Hit 62 Mph In 2.5 Seconds

When your car costs more than $1.2 million, travels over 230 mph, and hits 62 mph in 2.5 seconds, you do not sit in a passenger cabin — you sit in a "survival cell."
The "survival cell" is the heart of the Bugatti Veyron, billed as the world's fastest, most expensive and most exclusive factory-built car. It will arrive in the United States beginning early next year.

Baby

2006-03-01T11:58:00.001+09:00

Nice Baby

Assemblies

2006-02-28T14:25:00.001+09:00

Assemblies

The assembly is the building block of a VB.NET application. Basically, an assembly is a collection of the types and resources that are built together to provide functionality to an application.

· Assemblies look like dynamic link libraries (.dll) or executable programs (.exe).
· Differ from .exe and .dll files in that they contain the information found in a type library plus the information about everything else needed to use an application or component.
· Includes a mix of Microsoft Intermediate Language (IL) and machine code.
· Invokes the CLR by machine code found in the first several bytes of an assembly file.
· Contains one or more files.
· An application can be composed of one or more assemblies.
· An assembly can be a single portable executable (PE) file (like an .exe or .dll) or multiple PE files and other external resource files such as bitmap files.

Assemblies store metadata (data about the application) and include:

§ Information for each public class or type used in the assembly – information includes class or type names, the classes from which an individual class is derived, etc.
§ Information on all public methods in each class – includes the method name and any return values.
§ Information on every public parameter for each method – includes the parameter name and type.
§ Information on public enumerations including names and values.
§ Information on the assembly version (each assembly has a specific version number).
§ Intermediate language code to execute.
§ Required resources such as pictures, assembly metadata – also called the assembly manifest (the assembly title, description, version information, etc).

Multiple versions of an assembly can run simultaneously on the same client computer. This aids with compatibility with previous versions.

Assemblies shared by multiple applications on a client computer can be installed into the global assembly cache of Windows – this enhances security because only users with Administrator privileges on the machine can delete from the global assembly cache.

Strong-Named Assemblies

The strong-named assembly concept is used to guarantee the uniqueness of an assembly name – unique names are generated with the use of public and private key pairs when an assembly is compiled.

Applications can generally only run with the assembly version with which they are originally compiled. In order to update a component (such as a DLL for a control you've created), a publisher policy file is used to redirect an assembly binding request to a new version.

The .NET framework checks the integrity of strong-named assemblies to ensure they have not been modified since they were last built. This prevents unauthorized modification before loading.

The .NET framework creates a strong-named assembly by combining the assembly identify (name, version, and culture information) with a public key and digital signature.

As the programmer, you must generate the strong name key file (.snk filename extension) that contains the public-private key pair by using the Strong Name (Sn.Exe) utility or Visual Basic.NET IDE (this latter choice is usually the approach taken – simply involves clicking the right block during the building of an assembly). In fact, a project's property page has a Strong Name section to automatically generate a strong name key file to add to a project. The public key is inserted into an assembly at compile time. The private key is used to sign the assembly.

Versioning Strong-Named Assemblies

This shows an example publisher policy file written in XML. This file would be compiled for shipment with a new component version using the Assembly Generation tool (Al.Exe). This signs the assembly with the strong name used originally with the first version in order to confirm that the new component is from a valid source.

(configuration)
(runtime)
(assemblyBinding)
(dependentAssembly)
(assemblyIdentity name = "myassembly"
publicKeyTokey="ba76ce45677f9cd6"
culture="en-us"/)
(bindingRedirect
oldVersion="1.0.0.0"
newVersion="2.0.0.0"/)
(codeBase version="2.0.0.0"
href=http://www.fh.ora2003.edu/Test.dll/)
(/dependentAssembly)
(/assemblyBinding)
(/runtime)
(/configuration)

Ooops :-( i was unable to write less than sign and greater than sign in this blog so i had to use
( - less than sign
) - greater than sign.

The publicKeyTokey attribute is a hexadecimal value that identifies the strong name of the assembly.