Updating the OS of Blackberry 8900 Curve

Recently I needed to update the OS of the BlackBerry 8900 Curve device from 4.6.1.114 to 4.6.1.250.

To do this first you need to download the BlackBerry Desktop Manager Latest Version (5.0) and the OS required (4.6.1.250).

You can download the files required at,

Desktop Manager

https://www.blackberry.com/Downloads/entry.do?code=A8BAA56554F96369AB93E4F3BB068C22

and select the desktop manager software and download it.

OS

http://na.blackberry.com/eng/support/downloads/download_sites.jsp

Downloading the correct OS is bit tricky. You need find the correct version for the service provider (Dialog Sri Lanka, T-Mobile, Rogers, etc...). All the available service providers are listed in the above link.

When the download is complete you will get a file similar to 8900jEastAsia_PBr4.6.1_rel378_PL4.2.0.113_A4.6.1.250_Dialog_Sri_Lanka.exe

After completing the download, first install the Desktop Manager and then run the executable (8900jEastAsia_PBr4.6.1_rel378_PL4.2.0.113_A4.6.1.250_Dialog_Sri_Lanka.exe) of the OS. That will add the OS files to a place where desktop manager can use them to update the device.

Browse to the place where the Desktop Manager is installed (C:\Program Files\Common Files\Research In Motion\AppLoader), then delete the "Vendor.xml".

Now run the "Loader.exe" to start the application loading process. Make sure your BlackBerry is connected to the computer. In the second screen you need to select the connection which your device is using (for e.g. USB).

Then after few clicks of the next button the wizard will start installing the new OS to the device.

It will take about 25 minutes to complete the updation process. While that is happening make sure that you are not pressing any buttons on the phone and as also make sure you keep the USB connection alive.

After sometime the BlackBerry will get restarted with the new OS. Enjoy.

I you are having any problems please contact me, I may be able to help you.

Configuring DB Mail to use GMail

Have you configured SQL DB Mail to use GMail to send mails?
This post shows you how to achieve it.
1. Start the SQL Server Management Studio and login as SA.
2. Expand "Management" and right click on Database Mail and click on Configure Database Mail.

3. Select the first radio button and press Next.
If DB Mail service is not started it will prompt you to enable it.4. Put a profile name, then click on Add to configure the SMTP account.5. Click on the New Account, to create the account.
6. You need to put the account name, email address, display name, server name (smtp.gmail.com), port number (587), check the checkbox for Require secure connection (SSL) and select basic authentication as the SMTP authentication method and provide your user name and password.
When all are done press Ok.

7. Now pressing Next will bring you a screen to select the default profile. Select the newly created profile as default and click Next.
8. Using the Configure System Parameters screen you can change the parameters if required. But in this case defaults are perfect. Press Next.
9. Press the Finish button after checking the actions to create the new profile.
10. You can check whether it is properly setup by right clicking on Database Mail and Sending a Test Mail.

Bing - But It’s Not Google

Did you check out the new search engine from Microsoft?

If you used to use Live search you may have noted that now you are redirected to Bing, since Bing is replacing Live.

http://www.bing.com/

They have named it as BING and its having some few cool new things to look for.

Soon after the launch on 1st June 2009 Bing is getting bit popular at the moment in the context of search engines.

New Explorer Pane

Helps to filter the search results more or to find more related information.

Categorized Search Results

All the results will be categorized accordingly, so you will be able to find the related things easily.

Results Preview

You don't need to open the web site to view its content, Results Preview will show you a preview of the site so you can decide on it faster.

Image Search

You will be able to sort out the results fast according to things such as size, colour, layout, etc.

Video Search

One cool thing is without opening the site you can preview the video being inside of the Bing which will save lot of time.

There are much more it is better you check the rest of the features your self.

Bing

Travel

Maps
Shopping
Health
Local

Enabling Office SharePoint Server Publishing Feature

To enable publishing features you need to enable publishing in your SharePoint site.

Go to "Site Settings" by using the "Site Actions" button.

Click the "Site Features" link in the "Site Administration" category.

Clicking the Activate button of Office SharePoint Server Publishing to enable publishing.

• Some of you might get a message saying publishing is not enabled since Office SharePoint Server Publishing Infrastructure is not active.

This is because publishing is not enabled from the site collection level, what you need to do is select "Site collection features" from the "Site Collection Administration" category and activate the Office SharePoint Server Publishing Infrastructure feature for the entire site collection. Then you will be able to activate publishing by going to "Site features".

Changing the Default Welcome Page of a Site

Do you know that we can change the default page of a site in SharePoint?

This is done by going to "Site Settings" and accessing the "Welcome page" option under "Look and Feel" category.

• If you cannot find a link named "Welcome page" that means you don't have Office SharePoint Server Publishing enabled on your site. If you need more help on how to enable Office SharePoint Server Publishing please feel free to read my next post.

Now browse or type the page that you want to set as the welcome page and click Ok.

Temporary Internet Files Location

Did you ever tried to locate the place where the temporary files of the Internet Explorer is stored?
Knowing the location is really worth if you edited a file while keeping it in the temporary folder and accidentally close the file without saving it into a proper place.
Exact same thing happen to me, even though I knew the place where it would go in a Windows version prior to Windows Vista, but surprisingly it was different in Windows Vista.
So had to struggle a bit to find it, and I was too late to recover the changes that I did to the document. But since it is here, you are not too late.
C:\Users\ArjunaC \AppData\Local\Microsoft\Windows\Temporary Internet Files\Low\Content.IE5
The trick here is the folder named 'Low' is completely hidden by Vista, even you enable, show hidden and system files and folders the folder 'Low' will not appear. But you will be able to type it and browse the contents of the folder.

Offline Email in GMail

Have you checked offline GMail in action?

GMail team had developed GMail to work even when there is no internet is available.

It is a cool thing to us because we always are not connected to internet. Adding to that it is simply great since we don't have to install anything and it will work in Microsoft Internet Explorer as well.

Check it out by enabling it by going to settings page in your GMail account, click on Labs, select the Enable radio button of Offline feature and press on Save Changes button.

Then a link named Offline will appear in the top right of the GMail page. You can initiate the mail synchronization by clicking on this. It will guide you in setting up the feature.

IE Developer Toolbar not Working

Recently I needed to install IE Developer Toolbar to get some values of some applications. But after the installation I found out that it is not displaying any information about the loaded site.

Later I got to know that IE Developer Toolbar is not working if Internet Explorer Enhanced Security Configuration is installed.

So if you are also facing the same problem go to Add / Remove Programs and open up the Windows Components wizard and uncheck Internet Explorer Enhanced Security Configuration to remove it and when the wizard is finished and after you have restarted the Internet Explorer the IE Developer Toolbar will function as usual.

Changing Execution Timeout in SharePoint

If any of the tasks that you are performing in your site takes more time than usual and if the page is timing out then one solution that you can do is to increase the execution timeout value.
To change this value you need to edit the web.config files of SharePoint and the web site.

1. Open the SharePoint web.config file located at
Drive:\Program Files\Common Files\Microsoft Shared\Web server extensions\12\TEMPLATE\LAYOUTS
(C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS)
using NotePad or Visual Studio.
2. Find the section and insert executionTimeout value there as shown below. 3. Save the site config file.4. Now you need to edit the web applications' web.config file. Normally this can be found under Drive:\Inetpub\wwwroot\wss\VirtualDirectories\VirtualDirectoryFolder(C:\Inetpub\wwwroot\wss\VirtualDirectories\82)using NotePad or Visual Studio. 5. Find the line maxRequestLength and add executionTimeout in to it as shown below. 6. Save the application config file.7. Do an IIS restart and then your change will be in effect.

Changing the IIS Connection Timeout

For many reasons you might need to increase the IIS connection timeout.

The many reasons can be many time consuming processes, large transactions, slower connections, etc.

As a result if your application is timing out, one thing you can do is to increase the connection timeout.

• To change the timeout value you need to open Internet Information Services (IIS) manager. Either type InetMgr in the Run window or click on Start -> All Programs -> Administrative Tools -> Internet Information Services (IIS) Manager.
• In the IIS Manager expand the main node and right click on the Web Sites and click on Properties.
• In the Web Sites Properties page give the appropriate value in the Connection timeout field under Connections section in Web Site tab and press Ok.
• Now to make the setting take effect restart the IIS by either typing IISReset in the Run window or right clicking on the machine name and going to All Tasks and clicking on Restart IIS... in the IIS Manager.

Configuring Large File Uploading in SharePoint

As you have noted the maximum file size that is supported by SharePoint by default is 50MB. What if you want to upload larger files?
Luckily we can change this limit to support larger files by increasing the default upload size in SharePoint Central Administration.
1. Go to SharePoint Central Administration by clicking on Start -> All Programs -> Administrative Tools -> SharePoint x.x Central Administration.
2. Click on Shared Services Administration link on the administration home page. 3. Click on SharedServices1 (Administration site host) link in Manage this Farm's Shared Services page to open the Web Application General Settings page. 4. Find the Maximum Upload Size property and change it to the maximum upload file size you want. Note that you can put file sizes up to 2GB (2047MB). Now you will be able to upload larger files than 50MB.

But to support uploading large files you also may need to increase the default timeout value.

I will be posting the next post of mine on how to increase the timeout value.

Windows 7

Next version of Microsoft Windows is here.
It is still in beta, but in Microsoft site you can preview it and even download a beta version.
Have a look at it.
http://www.microsoft.com/windows/windows-7

Exception from HRESULT: 0x80040E14

Recently in SharePoint server I got an error when trying to do almost any action.
The error was Exception from HRESULT: 0x80040E14.
After sometime I did find out, that my C drive has gone out of disk space, and that caused SQL transaction log creation failure which resulted this error.
So freeing up more space on C drive solved my problem.
You will be able to get more details of the error by checking SharePoint log files.

Planning to Buy a Vehicle?

Thought to share some expensive and valuable information that might help you if you are planning to buy a vehicle. Lookout for two main things.
1. Quality of the Vehicle
2. Legal Side of the Vehicle

Although most of the things I mention in this are specific to Sri Lanka I definitely know there are similar things to check in other countries as well.

1. Quality of the Car
If you are buying a brand new vehicle this is not required because the company will give you the details technical overview and will also give you a warranty.
But if you are going for a used vehicle then you have to check for its quality. Anyway I am not that good in the technical side so you have to rely on the knowledge that you have or someone who knows better.

2. Legal Side of the Vehicle
This is one area most people are not paying that much interest. But this is the most important side, imagine a vehicle that you buy having problems with its documents, If that happens you wont be able to transfer it to your name with ease. Sometimes you even might need to go to courts. If that happens you face the difficulty when selling as well because no one would buy a vehicle from you that you don't own. Further more I advice you to check the vehicle documents because if you buy a technically unfit vehicle you can go to a mechanic and get the vehicle repaired after spending some time and money. But if documents are not good then it will be a big issue.
So what are these documents that you have to look for?

1. Certificate of Registration (CR)
This certificate will have all the details of the vehicle such as Make, Model, Year of Manufacture, Registration Number, Chassis Number, Engine Number, Present Owner, Absolute Owner, Previous Owners, Etc.
All of these are important to check, but for a successful legal transfer of ownership to you present and absolute owners are important. Always it is better to buy a vehicle from the person mentioned in the present owner field. Because the vehicle is owned by him. There are cases which people will keep vehicles with open papers.
Open Papers means that the owner will not get the vehicle transferred to his name, but he will get a set of forms filled from the seller and keep with him.
For example if Mr. ABC is buying a vehicle from Mr. STUV (Mr. STUV is the current owner in the CR). Mr. ABC will keep the transfer documents signed by Mr. STUV after doing the payments to Mr. STUV, but he will not fill them or submit them to the Department of Motor Vehicles for registration.
One advantage of open papers is the number of owners will be lesser.
One disadvantage of this is, if buyer needs to transfer the vehicle to his name he will not be guaranteed that the transfer will happen smoothly since his transferee will be an unknown person. For example in the above case if Mr. ABC is going to sell the vehicle to Mr. XYZ and if Mr. XYZ is needing to get the vehicle transferred to his name the legal transferee will be Mr. STUV who is unknown by Mr. XYZ. In which case while the transfer process is happening problems might arise.
Absolute owner - In normal case this field should be empty. If this is filled with some name that means the vehicle is on a finance or lease. In this case you cannot buy directly from the current owner. That is because when the absolute owner is superior to the current owner. So you will be needing a no objection letter from the absolute owner.
Also note in either case a company is printed under Current Owner or Absolute Owner you will be needing a no objection letter from the company in a company letter head, with the emboss seal and signed by a rightful director of the company.

2. Vehicle Identity Card (VID)
All the English number registered (HE, KA, KC, ...) vehicles will have a VID. you will be requiring this VID to carry out any legal things on the vehicle (Transferring the vehicle to you).
This is only applicable to English numbered vehicles since it is issued new.

If you follow these I think you would be able to buy a vehicle and live peacefully.

Visual Studio not Showing Errors

Is your Visual Studio showing error line numbers and respective pages while you develop?
If not read on, recently I came up to a machine which was having Visual Studio error. Visual Studio was showing errors when a project is compiled but the error details (error code line number, error file) which we can use to identify the error are not displayed.
After trying out several things found the cause of it and thought to share it.
The problem was not with the project but with the path the project was kept.
In the machine the failing project was stored under a folder which was having parenthesis or brackets "(".
For example the solution path was like C:\ProjectsA(V1)\MyProj\.
The (V1) part was confusing Visual Studio making it stop displaying the error details.
If you also have the same problem simply remove the brackets by renaming the folder and reload your project to Visual Studio from the new path. The error details will be shown correctly.

Regular Expressions

In the resent past I had to write some simple regular expressions.
So thought of sharing them with you.

An EMail Address Validator

^([a-zA-Z0-9_\-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)(([a-zA-Z0-9\-]+\.)+))([a-zA-Z]{2,4}[0-9]{1,3})(\]?)$
This will validate the entered EMail address.

A Password Validator

(?=.{6,})[a-zA-Z]+[^a-zA-Z]+[^a-zA-Z]+[a-zA-Z]+
This will validate the password to have at least 1 alphabetic character and 1 numeric digit, and altogether the password will be more than 6 characters long.

A Telephone Number Valdator

\d{4}\s\d{3}\s\d{6}
This will expect the telephone number to be in international format. For example (0094 777 123456).

A Simple Length Validator

[\s\S]{1,200}
This will allow only only 200 or lesser characters for input.

A Length Validator Which Works With Linefeed (Return, Enter)

^(.\n){0,500}$
This will validate and allow only 500 input even in a multi line field when linefeed (enter) is used in between.

A Date Validator

(0[1-9]1[012])[- /.](0[1-9][12][0-9]3[01])[- /.](1920)\d\d

This will check for the date validness. The date format should be mm/dd/yyyy to correctly validate by this.

If the date format is required as yyyy/mm/dd then use the following.

(1920)\d\d[- /.](0[1-9]1[012])[- /.](0[1-9][12][0-9]3[01])

Following are some good sites that you can refer for regular expression help.

http://www.visibone.com/regular-expressions/

http://books.google.lk/books?hl=en&id=NYEX-Q9evKoC&dq=Regular+expressions&printsec=frontcover&source=web&ots=qok1lUQubw&sig=XVd8_Z3hM_CWqk5r9dupyAWIllk&sa=X&oi=book_result&resnum=6&ct=result#PPP1,M1

http://regexlib.com/CheatSheet.aspx

Installing HyperV Integration Services

I think at least some of you might have started using Hyper V.

Did you feel how difficult to move from your Host Operating System (OS) to Guest OS (You have to click some keyboard combinations to move in and out).

To make our life easier you can install HyperV Integration Services to the guest OS.

To install, after starting your virtual machine click on the Action menu and click Insert Integration Services Setup Disk. This will start the installation process. After this finishes you no need to click key sequences to go back and forth among the OSs.

This will also install the required components so that the virtual machine will be able to communicate with local area networks and internet.

Please note that you need to install the Integration Services in each and every virtual machine separately.

Google Video Chat

Check out the new Google Video chat.
Now you can video chat using GMail.

http://mail.google.com/videochat

Hyper-V

Hyper-V is the name for the next generation hypervisor-based server virtualization technology from Microsoft.
This is included in Windows Server 2008 as a role and enables you to create and manage virtual servers or machines.
A free version of this also available which is named as Microsoft Hyper-V Server 2008. This is a Windows core having only the Hyper-V functionality enabled.
If interested better visit the following sites.
http://en.wikipedia.org/wiki/Hyper-V
http://www.microsoft.com/windowsserver2008/en/us/hyperv-overview.aspx
http://www.microsoft.com/windowsserver2008/en/us/hyperv-faq.aspx

Enabling Forms Authentication in SharePoint

Recently I needed to change the authentication of one of the application that I did using SharePoint to forms. I needed to authenticate users using Active Directory (AD). Even there are many sources explaining how to do it I found most of them are not full. So thought to put an article my self.

The default authentication method of SharePoint is Windows. It will use a window to get the user information while logging in.

To change the authentication first you need to login to the Administrator site.

Now select Application Management and click on the link Authentication Providers under Application Security.

In the Authentication Providers screen first make sure the correct web application is selected. If not, select the correct application using the drop down in the top left corner of the page.

After selecting the correct application click on the Default zone (Please note that here I am going to change the default zones' authentication. If you are to change in another zone simply select the required zone).

In the Edit Authentication page select Forms as the Authentication Type then in Membership Provider Name type AD, which we are to setup later. Then click the Save button.

As of the result of changing the authentication providers the Web.Config file will be changed accordingly automatically. But this is not enough we need to enter the membership provider details ther in site Web.Config file and Administrator site Web.Config files.
To do the necessary changes open both Web.Config files. Both files needed to be updated with the same information.

1. In the connection strings section add the following line.

This specifies the connection string to the AD. (Please note that my full computer name is 'ironone-ms-t01.MS.TEST' and my domain is 'MS.TEST'. You definitely need to change them according to your domain details.

2. Inside System.Web add a membership provider by entering the following text.

You should change the details of the connection according your settings but make sure you do not change the name from 'AD' to anything else, otherwise it will not work.

Application Web.Config

SharePoint Administration Site Web.Config

Save both Web.Configs and do an IIS reset.

Go back again to the administration site and select Application Management. Now select Policy for Web application under Application Security.

After making sure that the correct web application is selected, click on Add Users.

Select the Default as the zone and click next.

When choosing users type the full user name preceding AD:. For example to add administrator type AD:Administrator. Under the permission section select the Full Control - Has full control check box and click Finish.

As the final step you have to change the site collection administrators. For this click on Site Collection Administrators under SharePoint Site Management in Application Management.

After verifying the selected application enter Primary Site Collection Administrator as AD:Administrator. If you want you can fill in Secondary Site Collection Administrator as well. After finishing click Ok.
Now go back to the site and try to login, you will see that the traditional windows login page is replaced with a simple login web page. Since this login page is too simple I did some improvements to the login page and created my own one as you can see below.

Correcting the error at User Control

Recently I got an error in an user control which I used to create users in Active Directory. This user control started to fail in SharePoint after deploying it in to a different server. It threw the following error,

• Exception has been thrown by the target of an invocation.

The Inner Exception was

• Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

After a bit of a struggle I found that the error was due to inappropriate setting in Web.Config file.

To correct it set identity impersonate to false.

<identity impersonate="false" />

Creating an Excel Sheet using .Net

In this entry I will show how you can create a Microsoft Excel file using .Net.

// Create the Excel Application object.
ApplicationClass ExcelApp = new ApplicationClass();
// Set the visibility of the application.
ExcelApp.Visible = true;
// Create a new Excel Workbook.
Workbook ExcelWorkbook = ExcelApp.Workbooks.Add(Type.Missing);
// Create a new Excel Sheet.
Worksheet ExcelSheet = (Worksheet)ExcelWorkbook.Sheets.Add(ExcelWorkbook.Sheets.get_Item(1), Type.Missing, 1, XlSheetType.xlWorksheet);
try
{
// Loop for 10 rows.
for (int rwCount = 1; rwCount <= 10; rwCount++)

{

// Loop for 3 columns.

for (int clmCount = 1; clmCount <= 3; clmCount++)

{

ExcelSheet.Cells[rwCount, clmCount] = "This is Row - " + rwCount + " Column - " + clmCount;

}

}

// Save the Excel sheet.

// The @ symbol makes the string to contain any special characters inside the string without breaking the string.

ExcelApp.Save(@"C:\Projects\Ex.xls");

}

Accessing Data in an Excel File using .Net

In this article I will show how you can open Microsoft Excel files using .Net.
You can use OLE objects to access data in Excel files as of you are accessing SQL Server data using SQL objects.

// Create an OLEDBConnection to connect to the Excel file.
// I'm getting the required file by using a file dialog.
// The @ symbol makes the string to contain any special characters inside the string without breaking the string.
OleDbConnection dbConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + openFileDialog1.FileName.ToString()+ @";Extended Properties=""Excel 8.0;HDR=Yes;""");
// Open the connection.
dbConnection.Open();
// Create a command object to work on the data.
// Note that I have given the sheet name as [Sheet1$] to retrieve data from that named sheet in the particular Excel file.
OleDbCommand dbCommand = new OleDbCommand("SELECT * FROM [Sheet1$]", dbConnection);
// Creating a data reader to read data.
OleDbDataReader dbReader = dbCommand.ExecuteReader();
// Get the position of the column Desc 1.
int SearchingItem = dbReader.GetOrdinal("Desc 1");
// Read through the data.
while (dbReader.Read())
{
// Traverse through all the data columns.
for (int i = 0; i <>
{
ExcelSheet.Cells[CurrentRowCount, i + 1] = dbReader.GetValue(i).ToString();
}
}