Grab the RSS feed

T.H.E.M - Tottaly Hidden Extreme Magic

I am fan of Cyril long after watching his videos on YouTube. They were Japanese made, however you were able to understand and impress by Cyril magic tricks and wonders.

Recently I saw some episodes of Cyril: Simply Magic which are been broadcasted on AXN.

After checking on YouTube and found out that Cyril were part of other magic shows too. One of them is T.H.E.M. After watching I am impressed. I thought better share it on my blog too.

Error 0xc0204016: DTS.Pipeline - SQL Server

It was just another week back. I've been asked to transfer data from SQL server to MS Access and Excel. It is been little longer time that I have used SQL Server. So I thought it as a challenge! I know there were tools to do the needful. However, the best tool was Data Transformation Services (DTS) which came with SQL Server 2000 in the old days. Now it is more improved and it bundles with SQL Server 2005 and the tool named SQL Server Integrated Services (SSIS).

Now for SQL Server 2005 Express edition you have to download this and install it separately.

Download the Microsoft SQL Server 2005 Express Edition Toolkit (223.9 MB)

And later you can run it

Run "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe"

I thought work is going to be easy until I found the error messages I have received. I searched through the Net to find the solution. There were, however they were not simple as I thought.

Some were explaining to change the destination source file, such as to change the table column to memo. It is little confusing, since the tables are yet to be created.

I tried few SQL scripts too and nothing went well.

The reason this error message prompted was that one of the column field size is more than accepted at the destination file (in my case it is MS Access).

After reading this article ( only I have realised that I did not try to change the source file column data type as required. By changing the particular table column data type longtext(8000) to varchar(max) allowed me to transfer the SQL server data to MS Access.

It was not easy. However I was able to end it.

Endhiran a phenomenon

Date: 2 OCT 2010.

Long awaited director Shankar's & super star Rajni Kanth's movie Endhiran previewed from 30th of September 2010 world wide! It is a rush.. In Sri Lanka premier ticket shows were been sold at higher prices than ever. I am a super star fan since my childhood and I love shankar's movies. I am so enthusiast about watching the movie at first as a premier show. Somehow, I was able to secure the tickets for 9.30pm show on 30th September 2010. I am not a guy who visits theater often and staying on que to watch a movie. Most of the time invited for premier tickets. Last time was Aadhavan and that is last year.

I read some review on websites before going to the movie. They were damn good. . Even though the ticket price were high, the premier shows were packed all over.

Well about the movie. The storyline is, Vasigaran the scientist (Super star) invents a Robo (Chitti) spending last 10 years which is going to be dedicated to the army to use it in the battle. As a hardwork of 10 years he sends Chitti in a real environment to test its ability and accordingly correct/upgrade/fix it.

However, Professor/Guru of Vasigaran dislikes his own student's invention as a result he disapproves the Robo as a useless machine. Since Chitti doesn't have any feelings and can't distinguish between the commands given. Even few of the events disapproves it is a useless machine.

As a result Vasi plans to fix the problem by adding feelings to Chitti and teaching him about them. However, Chitti who with the feelings now falls in love with Sana (Aishwarya Rai) who is Vasi's girlfriend. Thereafter whether Chitti able to continue his feelings of love with Sana or not is the storyline.

First part of the movie is hilarious and thrilling. As the time pasts it is more thrilling and action packed.

It is just a brief overview of the Endhiran movie by myself. :D

I did not hack Twitter

Just browsing along my Twitter account for few minutes. Suddenly I couldn't see my followers and who am I following. They were empty. Not my account alone. Others too. They restored it like within 5 mins time. Well this is not my first time to see weird thing happening at Twitter.

Here are the screen shots from my account.

Google Instant

Google Instant is a fastest way to browse the search results while you type. Yes it is fast. However, my question is, is this not a more process than older one at Google end??? Think about it. It is going query more than actual results. In other hand same for Google search image results. It is going to consume more bandwidth though. Maybe for Google it does not matter. Since they own their own backbone for Internet speed.

In addition, you should have the latest browsers to use the Google Instant.

Coldfusion & SQL Server 2005 - java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]No more data available to read

I just started installing the new ColdFusion on my PC. I am looking at ColdFusion after 2 years. It is been a long rest without ColdFusion.

If you are dealing with Vista which is not user friendly like the old XP! So lot of workaround. Since Vista build in with lot of security functionality. Even the normal Home Edition!

It is been frustrating after installing and still I am unable to connect with MS SQL Server 2005 due to an error message.

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]No more data available to read.
The root cause was that: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver]No more data available to read.

I spend like more than 6 hours and still no results. I was searching on the web to get the solution.

Even ColdFusion logs are not helpful. Suddenly I thought better check out my event logs.


The error message was "Encryption is required to connect to this server but the client library does not support encryption; the connection has been closed. Please upgrade your client library. [CLIENT:]"

Yes, I was testing with CF Datasources to find out whether any issues with SQL server authentication. However, results were null.

So, yes I understood the problem. I just flew to the SQL Server Configuration Manager and Collapsed the menu "SQL Server 2005 Network Configuration" and chose the "Protocols for your SQL server name" and right click on it and selected properties and change the setting "Force Encryption" to NO and just restarted SQL server.

Now it is working like a baby! It took little more time to find out, however, it is worth though!

I can't assure the same solution will work for your problem. Always try to check the Event Logs for any clue about the error messages.

The Karate Kid - Movie Clips

As "The Karate Kid" movie been launched, here are few movie clips from "The Karate Kid". Enjoy!

Doodle 4 Google

Today I saw there were some text in Google's home page, it is to cast vote for Doodles which are done by school children from Grade K - Grade 12. It was interesting and inspiring to see the artworks.

Casting vote is available for everyone from 18 May 2010 - 25 May 2010.

Please follow the link to cast the vote and check out the cool artworks.

Gmail to be smart

Just try to send an email. When I pressed send, there is an alert saying "You wrote "see an attachment" in your message, but there are no files attached. Send anyway?" .

Well this is the first time I see this message. Most of the time we forgot to attach the document required. I think this will help Gmail users in a good way.

Good Work!