tag:blogger.com,1999:blog-40897036359508889342024-03-19T17:37:07.547+05:30Otiose BanterAll the times I have gone to Google to find the light ..... well now its paybackVikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.comBlogger26125tag:blogger.com,1999:blog-4089703635950888934.post-15184694897935586532014-02-19T23:42:00.000+05:302014-02-19T23:44:28.878+05:30Onedrive puzzle answer<div dir="ltr" style="text-align: left;" trbidi="on">
The solution lies in replacing the letters in the folder as per the wheel mapping. Translated it roughly reads as follows.<br />
<br />
<br />
"The first hundred thousand users to log into onedrive.com at 11:11 AM PST today (February 19, 2014) will win 100 GB of extra storage."<br />
<br />
All the best !</div>
Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com0tag:blogger.com,1999:blog-4089703635950888934.post-50502052737200329522011-10-09T21:36:00.007+05:302011-10-09T22:17:27.524+05:30android wifi proxy in windows office domainI am sure there are a lot of people who have tried to connect their android devices through their office network in order to save the mobile bandwidth costs.<br /><br />While some phones like samsung have built in proxy settings most of them do not. The issue with connecting to office networks is that most proxy use NTLM domain authentication that is not widely know and most stock solutions do not provide capability to connect and authenticate to these types of proxies.<br /><br />Recently ProxyDroid available in the marketplace allowed for these types of connection for rooted devices.<br /><br />After installing start the application. It will request for SupoerUser Permission. Grant the application the requested permission.<br /><br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYgApXESXdPgjOFJEMmGvWYE1-z2oKXBX-V0IV_a_iLBfKshitp98tuooSRplcI2zYO1ANW9uqp_JsarjZy8OPKxs-CFGu4NFc2YMNdRvnUIVvmW2aL9NIA5UVQ35xZxLG9W4WSCBYbJs/s1600/proxy1.jpg"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 267px; height: 400px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjYgApXESXdPgjOFJEMmGvWYE1-z2oKXBX-V0IV_a_iLBfKshitp98tuooSRplcI2zYO1ANW9uqp_JsarjZy8OPKxs-CFGu4NFc2YMNdRvnUIVvmW2aL9NIA5UVQ35xZxLG9W4WSCBYbJs/s400/proxy1.jpg" alt="" id="BLOGGER_PHOTO_ID_5661529890811886578" border="0" /></a><br /><br />Select New profile<br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3RKQGmLlo-c8GP-U-BXN4krdbeAHPMn3Ll2kzUr6zjiokH1-BFNX4AqkCLlcKK6tB3akH7CqqH0UKy3pUVPNwstiRnpt40CH7ms85hFt_gGsBxck_149gXgOqNFJsrnSXbxOCDOAOEcI/s1600/proxy2.jpg"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 267px; height: 400px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi3RKQGmLlo-c8GP-U-BXN4krdbeAHPMn3Ll2kzUr6zjiokH1-BFNX4AqkCLlcKK6tB3akH7CqqH0UKy3pUVPNwstiRnpt40CH7ms85hFt_gGsBxck_149gXgOqNFJsrnSXbxOCDOAOEcI/s400/proxy2.jpg" alt="" id="BLOGGER_PHOTO_ID_5661531312079067346" border="0" /></a><br />Then select each of the parameters and fill it up<br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgx50y7-jZdKiAPf_V7haWeSQBi3vU2R6-Vw0jLrjVubJlRWJsUrL7mwrX0fKXT6lUqFj9FPwzGZvCO70Z6SA59J1RHRw3Bg4WpWpDHkhpF6sjU6ejpL4YaQfnwf41Croz5o8JhdSL5Qs/s1600/proxy3.jpg"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 267px; height: 400px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjgx50y7-jZdKiAPf_V7haWeSQBi3vU2R6-Vw0jLrjVubJlRWJsUrL7mwrX0fKXT6lUqFj9FPwzGZvCO70Z6SA59J1RHRw3Bg4WpWpDHkhpF6sjU6ejpL4YaQfnwf41Croz5o8JhdSL5Qs/s400/proxy3.jpg" alt="" id="BLOGGER_PHOTO_ID_5661532146661138994" border="0" /></a>In Host put the address of the proxy server<br /><br />In port, fill up the proxy server port<br /><br />Proxy type select HTTP<br /><br />Scroll down and check the Enable Authentication tab<br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXKlqZ9s6jgsFtfIHnxtm3MUrhZMpwroSwv2F028QO4xNaCXQfnvhZbT9j38OBH2jjUE7uhbsr1S4uwE4DjCYFkCX6b4A1e9nc_rFJNGC93c3SpGcrOzLfelUDyqU7FYOU5zI_s7BD2Jo/s1600/proxy4.jpg"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 267px; height: 400px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXKlqZ9s6jgsFtfIHnxtm3MUrhZMpwroSwv2F028QO4xNaCXQfnvhZbT9j38OBH2jjUE7uhbsr1S4uwE4DjCYFkCX6b4A1e9nc_rFJNGC93c3SpGcrOzLfelUDyqU7FYOU5zI_s7BD2Jo/s400/proxy4.jpg" alt="" id="BLOGGER_PHOTO_ID_5661533295768623730" border="0" /></a><br />Enter the username , enter the password and enable NTLM Authentication (important)<br /><br />Finally select the Domain option and enter the Domain name of the connection. Now you should be good to go !Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com0tag:blogger.com,1999:blog-4089703635950888934.post-84166637513786488062011-08-06T23:52:00.007+05:302012-03-31T22:30:35.484+05:30Android Screen Control Without RootThe ability to control the screen of my Android phone has been a major pain since I moved from Windows Mobile to Android quite some time ago.<br /><br />The only solutions required root permissions. However there are scenarios where that is not an option such as in a corporate environment / providing remote support for a device that is not your own.<br /><br />Android 2.1 onwards ( as far as I know) supports a API called MonkeyRunner that is to be used for application testing. Using this along with java sources provided by "The Android Open Source Project" I have put together a small application that will capture the screen and allow passing of click and key press events to the device.<br /><br />It is highly limited to the extent that it allows only for touch events and keystrokes. It currently does not support drag events and typing of special characters but something is better than nothing :)<br /><br /><br />Download the zip file from here<br /><br /><a href="http://www.mediafire.com/file/a8870ynh151vm9d/ScreenControl.zip">http://www.mediafire.com/file/a8870ynh151vm9d/ScreenControl.zip</a><br /><br />In order to run the files, you need to ensure that the device is connected via USB cable only and debugging has been enabled on the device.<br /><br />Once this is done, Fire up the screen.bat and it should load up the window. The screen.bat is a single line command calling java.exe along with all the required class and jar files required to make this work.<br /><br />I have also included adb.exe which is required, you could replace with your own, however mine will probably be more stable.<br /><br /><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRgYS3Ex2gna2uMMZYcEvz-xYRMZId1aikpAZYJ6gd-lhbs2tyK6_8NYxqVdfSHzx2mZr-_YL2GWvBoDNBLDOKqlX1A0BDwOkmCZMqQfItY4PKtRKCoQgF7LFne0z00TKTtuU5HFo8MXU/s1600/ScreenControl.JPG"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 285px; height: 400px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjRgYS3Ex2gna2uMMZYcEvz-xYRMZId1aikpAZYJ6gd-lhbs2tyK6_8NYxqVdfSHzx2mZr-_YL2GWvBoDNBLDOKqlX1A0BDwOkmCZMqQfItY4PKtRKCoQgF7LFne0z00TKTtuU5HFo8MXU/s400/ScreenControl.JPG" alt="" id="BLOGGER_PHOTO_ID_5637818685677906802" border="0" /></a><br /><br />Again, Consider this only if your device is not rooted. If you have rooted your device I would recommend you use the either of the following better softwares<br /><br />Android Screencast<br /><a href="http://code.google.com/p/androidscreencast/">http://code.google.com/p/androidscreencast/</a><br /><br />This works with the USB connection<br /><br />Droid VNC Server by <span class="" id=":1r" title="José Luis Pereira">José Luis Pereira<br /><a href="http://www.onaips.com/wordpress/?page_id=60">http://www.onaips.com/wordpress/?page_id=60</a><br /><br />This works with Wifi<br /><br /><br /><br />I hope this has been helpful for some of you all. Am sure there are more brilliant people out there who can modify the sources to add drag functionality as well. Do let me know !<br /><br /><br />UPDATE<br />F.J. Wechselberger has integrated this functionality into MyPhoneExplorer through </span>native TCP-Calls. Its not possible for him to implement Java-Library into the PC-Program but he was able to translate the source of MonkeyRunner<span class="" id=":1r" title="José Luis Pereira">. I Would recommend you download this if you are looking for a simple solution for controlling the screen.<br /><br /></span><cite><a href="http://www.fjsoft.at">www.fjsoft.at</a><br /><br /></cite><span class="" id=":1r" title="José Luis Pereira"><br />Cheers,<br />Vikram Sridharan.<br /><br /></span>Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com26tag:blogger.com,1999:blog-4089703635950888934.post-63886209364387540802010-09-15T00:47:00.005+05:302010-09-15T01:26:11.168+05:30Compress large files on windows server 2008This started out as something else. We had a large database of about 100 GB that we wanted shift to our DR location. Due to bandwidth restrictions we started out to explore options on how we could reduce the overhead of transferring such a large file.<br /><br />Now compressing a 100 GB file is not a joke. After some looking up I came across an interesting article by Chris over at solo-technology talking about <a href="http://www.solo-technology.com/blog/2007/12/14/7-zip-compression-vs-speed/">Compression v/s Speed</a>. It talked about a related issue but the same capability could be used for handling large files.<br /><br />The best tool for doing this is 7Zip. It is an awesome freeware by <small>Igor Pavlov </small>handling a large number of compression formats. Check it out over here.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6_xs1BohZPOKs5AT_BE3Ea3spDemMbu_acWM7l9mSIkXaJ-ymQMG1Fb32wy1l1DvNXJmIX9FAfwOW3_zH_NUNOQzgoTN7zOA8RR9BA4yJ-mN_Bu2-lVHqn-UZozY2tb_X771I7RjLyQU/s1600/7zip.png"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 234px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg6_xs1BohZPOKs5AT_BE3Ea3spDemMbu_acWM7l9mSIkXaJ-ymQMG1Fb32wy1l1DvNXJmIX9FAfwOW3_zH_NUNOQzgoTN7zOA8RR9BA4yJ-mN_Bu2-lVHqn-UZozY2tb_X771I7RjLyQU/s400/7zip.png" alt="" id="BLOGGER_PHOTO_ID_5516859291364438066" border="0" /></a><br /><br /><a href="http://www.7-zip.org/">http://www.7-zip.org/</a><br /><br /><br />That aside, by using the command line version of this you could zip you file. When we started the zip file took 5 hours to finish just 30 % of compression. On check the task manager, I found that the whole process was just running at 100 % on a single thread of the 24 cores available on the server.<br /><br />By using the following options,<br /> <span style="font-weight: bold;"><br />I was able to compress the 100 GB SQL Server 2008 database backup file to just 16 GB ! in just 1 Hour !!!</span><br /><br />This was way beyond my expectations :) Here is that technical syntax to use this<br /><br /><br />7z a -tbzip2 -mx=9 -mmt=on backup.zip backup.bak<br /><br /><br />"7z" is the program to initiate<br />"a" is to append the file<br />"-tbzip2" is to use the bzip2 format, this is important as only this format allows for multithreading for both the compression as well as the decompression<br />"-mx=9" is the number of passes, this is optional, I didn't use it, the system defaults this to 5<br />"-mmt=on" is to turn on the multithread capability, again this works only for the bzip2 format<br />"backup.zip" is the file that will get created<br />"backup.bak" is the file that needs to get backed up.<br /><br />You could read through the technical literature available with 7zip to get a better hang of the application. This were just the specific options that are required to manage this requirement.<br /><br />One other note, I did read the the bzip2 format has a restriction that it can include only 1 file at a time. I didn't try for multiple files.<br /><br />Hope this helps in saving you precious bandwidth !!!Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com1tag:blogger.com,1999:blog-4089703635950888934.post-60004827900192755652010-04-02T19:17:00.009+05:302010-04-03T01:06:25.830+05:30Microsoft Association Rules / Data mining in SQL Server 2008Since the release of SQL Server 2005 Microsoft has dabbled quite a bit with Data mining models. While I have read that Data mining capability has been available with one of the later releases of SQL Server 2000, I haven't been able to come across too much material on the same.<br /><br /><br />First up I would like say the best place to start if you are serious about learning about Data mining is to go get yourself this really good book on the topic. Its extremely easy to read and the examples used are quite practical.<br /><br />The book is<br /><br /><a href="http://blogs.msdn.com/jamiemac/archive/2008/10/02/data-mining-with-sql-server-2008.aspx">Data Mining with SQL Server® 2008<br /><br />by<br />Jamie MacLennan<br />ZhaoHui Tang<br />Bogdan Crivat</a><br /><br /><br />Back to original reason of the post, being a techno functional individual, I was keen to see how we could effectively cross sell products to stores since we had their complete sales history. Ensuring that our consumers never left the store without the products they wanted goes a long way in ensuring consumer loyalty and company performance.<br /><br />Having most of the data already available in SQL Server 2008 I was keen to see what we could use to help identify these gaps. In SQL Server 2008 Microsoft has the following Data Mining Models<br /><br />Microsoft Naıve Bayes<br />Decision Trees Algorithm<br />Time Series Algorithm<br />Microsoft Clustering<br />Sequence Clustering<br />Association Rules<br />Neural Network and Logistic Regression<br /><br />The best fit for the requirement I had was the Microsoft Association Rules. It allowed me to build the model utilizing the classification of outlets that we already had.<br /><br />I built the model using three classifications we had for our outlets along with products that the outlet already sold. In order to do this I needed to create a nested table for the products as one outlet could sell multiple products. Also important to note that the data types for Data mining objects are slightly different from the data types that are used by standard SQL queries. The DMX I used is below.<br /><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9k_wNPVCaNMIFnvWK02kBSRletdf6PEO5iabOX7Woz9rl0t2rPFEbdQQixQdUF1D_9hp-UpOBgq9sJTWzLFoWOTh0zHywCmd9dweWFLDIvNnV8fiQmqqSivvJJrGM1y_iN1Da8-2JbYY/s1600/datamining1.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 382px; height: 170px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj9k_wNPVCaNMIFnvWK02kBSRletdf6PEO5iabOX7Woz9rl0t2rPFEbdQQixQdUF1D_9hp-UpOBgq9sJTWzLFoWOTh0zHywCmd9dweWFLDIvNnV8fiQmqqSivvJJrGM1y_iN1Da8-2JbYY/s400/datamining1.JPG" alt="" id="BLOGGER_PHOTO_ID_5455625764544572930" border="0" /></a><br /><br />Post creating the structure , I applied the Microsoft Association Rules Algorithm requested the prediction of the product utilizing the standard support and probability the model is generally used with.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwzF8eaOjvkFcf5kZ589DPWUa-M6rPbVyuKIMmrjMzxxmZ3j1kpN4MrSiIlE99ECbOoAC1YGvYjwV7DYB8jo4Z7mUw6J89t-22kqbNj1A7h-6oIsACPpno7kHmwf2g6jmM6Cz2SxlT2A8/s1600/datamining2.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 167px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhwzF8eaOjvkFcf5kZ589DPWUa-M6rPbVyuKIMmrjMzxxmZ3j1kpN4MrSiIlE99ECbOoAC1YGvYjwV7DYB8jo4Z7mUw6J89t-22kqbNj1A7h-6oIsACPpno7kHmwf2g6jmM6Cz2SxlT2A8/s400/datamining2.JPG" alt="" id="BLOGGER_PHOTO_ID_5455625769489286370" border="0" /></a><br /><br />The next step was to feed in data into the model to let it build the association rules. This was done using the following syntax. Am important point to note here is that the key data needs to be sorted. Sometimes in spite of sorting it still gives errors saying the data most probably is not sorted. The solution for this is to ensure that the key that is used is specifically a nvarchar source data type. I faced a problem when my key happened to have numeric data as well as string data. Needed to convert everything before I could successfully load the data into the mining structure.<br /><br /><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1rEtIcMexlxNrDi75MqpSdP_mUgp2Z1YmNIOeNXFHIF13xOzHaiesF7u6GZQ6WubXfU1U1zP0YoG_kjnVU3JaaHOO-LqZEhbJlLVMaqOJtTrtdyw5X-6Urgh3Gcs_4oDSSSj5-O-2GK4/s1600/datamining3.jpg"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 251px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh1rEtIcMexlxNrDi75MqpSdP_mUgp2Z1YmNIOeNXFHIF13xOzHaiesF7u6GZQ6WubXfU1U1zP0YoG_kjnVU3JaaHOO-LqZEhbJlLVMaqOJtTrtdyw5X-6Urgh3Gcs_4oDSSSj5-O-2GK4/s400/datamining3.jpg" alt="" id="BLOGGER_PHOTO_ID_5455625774644182290" border="0" /></a><br />Once the data is loaded into the model, the last step is to retrieve out the recommendations that the model would generate. I have done this for the store ABC by passing the store along with the products that the store purchased into the model and asking it to return 5 recommendations based on the model as well as the classification of the store and the products that the store sells.<br />This is done through the following DMX statement.<br /><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkgYwY5cteovpaPu9krss2PYeG4AnywuDDyKhl7E9Mcepy5zbHTlD9Ai-P8OajxXQsDiSSKInJ7PyiFbfkDayEJqfrig0yWccOUHIWursFMmPAHmLuiNXyuQjlNjWtTdx7wRgRmraFSO8/s1600/datamining4.jpg"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 416px; height: 267px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjkgYwY5cteovpaPu9krss2PYeG4AnywuDDyKhl7E9Mcepy5zbHTlD9Ai-P8OajxXQsDiSSKInJ7PyiFbfkDayEJqfrig0yWccOUHIWursFMmPAHmLuiNXyuQjlNjWtTdx7wRgRmraFSO8/s400/datamining4.jpg" alt="" id="BLOGGER_PHOTO_ID_5455625779644009314" border="0" /></a><br /><br />In case you want this data in the standard query windows you could always create a Linked server to OLAP where the Data Mining model exists.<br /><br />Do let me know if you have any comments !Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com0tag:blogger.com,1999:blog-4089703635950888934.post-82849379848877044062010-03-21T14:17:00.002+05:302010-03-21T14:22:36.551+05:30Acer eMachine E725 XP DriversSince this laptop is bundled with Linux, you need to have all the drivers in place before you can install XP on this E725 Laptop.<br /><br />Acer has the drivers as part of the E720 release and you could get all of them on the below ftp site of acer itself<br /><br /><a href="ftp://ftp.work.acer-euro.com/notebook/.em/E720/XP%20SP2/">ftp://ftp.work.acer-euro.com/notebook/.em/E720/XP%20SP2/</a><br /><br /><br />Incase you want to do Vista on the Acer eMachine E725 instead , go to this location<br /><a href="ftp://ftp.work.acer-euro.com/notebook/.em/E720/Vista%20SP1/"><br />ftp://ftp.work.acer-euro.com/notebook/.em/E720/Vista%20SP1/</a><br /><br />Hope that helps, do leave a comment !!Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com0tag:blogger.com,1999:blog-4089703635950888934.post-29771868058978875572010-02-06T14:15:00.003+05:302010-02-06T14:24:01.018+05:30Nokia 5230 Free Navigation / MapsRecently Nokia made Navigation free atleast in India. However if you now tried to connect for free navigation it still asks for you go to the store. The reason for this is that Nokia has allowed free Navigation using Ovi Maps only on the new version of the software.<br /><br />So if you have bought your phone couple of weeks ago there is a very good chance you are on the old version. What you need to do is go to the Nokia site and upgrade your version of Ovi maps to the latest version.<br /><br />There are two ways of getting this done, one is to download the software on your computer and then Sync with your phone which would then automatically upgrade the version of Ovi Maps that is present on your phone.<br /><br />The second option is to directly download the software to your phone and run it from there. However this would require a data connection from your service provider.<br /><br />The link for downloading the software is <a href="http://maps.nokia.com/ovi-services-and-apps/ovi-maps/downloads?lid=nav_navq1_link_downloadovimapswithfreenavigation_other_na&ca=navq1&t=nav&intc=nokiacommaps-fw-ilc-na-acq-na-europenokia-g0-19-downloadovimapswithfreenavigation_101#/default/">here</a><br /><br />If you want to get the map data stored directly on your computer you should go through this post.<br /><a href="http://piglings.blogspot.com/2010/01/nokia-5230-maps.html"><br />http://piglings.blogspot.com/2010/01/nokia-5230-maps.html</a>Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com0tag:blogger.com,1999:blog-4089703635950888934.post-80418568219699214542010-01-09T23:28:00.005+05:302010-02-06T14:25:00.522+05:30Nokia 5230 MapsMy dad just got his Nokia 5230, nice phone that comes with Ovi Maps 3 installed however there were no map data available. Since he didn't have GPRS enabled on his phone I decided to do some digging around to make use of the GPS device bundled into the Nokia 5230.<br /><br />Credit to symbian underground for helping me get this to work.<br /><br /><br />The first step is to have you your external card ready. Run Nokia Maps on your phone once before you add any maps or voices. This will create the required folder structure on your memory card. Quit the application after that.<br /><br />On my Nokia the folder structure is cities with a subfolder called diskcache, filled with 16 subfolders called 0 to 9 and a to f, and each of these folders have another 16 subfolders 0 to 9 and a to f.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-vGGpGcCqzDPTyn0Br58fdpKf7UotDDuDGVQ95nGV2gCSqpqSASiXxZwrOqnUid4MS2WtL2VQSKeAzSYknrhrGldgqf139zlzbj1dYi1IAprIW7uIMOMGHiNWcA1f_Q8rWyKH12V7Uck/s1600-h/nokiamaps.jpg"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 200px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg-vGGpGcCqzDPTyn0Br58fdpKf7UotDDuDGVQ95nGV2gCSqpqSASiXxZwrOqnUid4MS2WtL2VQSKeAzSYknrhrGldgqf139zlzbj1dYi1IAprIW7uIMOMGHiNWcA1f_Q8rWyKH12V7Uck/s400/nokiamaps.jpg" alt="" id="BLOGGER_PHOTO_ID_5424803255619565970" border="0" /></a><br />For India, download the following file from Nokia itself<br /><a href="http://static.s2g.gate5.de/map5/maploaderzip-00.01.18/3415.zip"><br />India Maps</a><br /><br />Extract the zip file into your local computer, once done copy drop the 16 folders called 0-9 and a-f into the diskcache folder of the Nokia 5230. You can do this by connecting your device as a external hard drive via the Micro USB port.<br /><br />Thats it, maps should now work. You should now disconnect the connection to the computer and only then run maps again.<br /><br />If you want voice as well download the following files<br /><br /><a href="http://static.s2g.gate5.de/maploadervoice/english.zip">English</a> or <a href="http://static.s2g.gate5.de/maploadervoice/hindi.zip">Hindi</a><br /><br />Extract all the files into the cities folder. That is it.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjM5OR4P2Wk-9QrBQwm5MqBeg7_rAvI5wgR8gWrkf6ded5gqrdINp_zH6FVbZuBoasGXAw_L3cwTxg21SaQXzXKI7Ony_NvCMfhg4RH_PyIPyEM0-Pe3uRf_gcExEWw20FXLkvkjuB8DUY/s1600-h/nokiamapsvoice.jpg"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 209px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjM5OR4P2Wk-9QrBQwm5MqBeg7_rAvI5wgR8gWrkf6ded5gqrdINp_zH6FVbZuBoasGXAw_L3cwTxg21SaQXzXKI7Ony_NvCMfhg4RH_PyIPyEM0-Pe3uRf_gcExEWw20FXLkvkjuB8DUY/s400/nokiamapsvoice.jpg" alt="" id="BLOGGER_PHOTO_ID_5424806102520641890" border="0" /></a><br /><br /><br />For other countries check the maps links here<a href="http://diabo.freehostia.com/symbian/indexmaps.htm"><br />http://diabo.freehostia.com/symbian/indexmaps.htm</a><br /><br />The voice links of other languages are here<br /><a href="http://diabo.freehostia.com/symbian/nokiamaps/voices001.html">http://diabo.freehostia.com/symbian/nokiamaps/voices001.html</a><br /><br />If you want to enable free Navigation, do read this post<br /><a href="http://piglings.blogspot.com/2010/02/nokia-5230-free-navigation-maps.html">http://piglings.blogspot.com/2010/02/nokia-5230-free-navigation-maps.html</a><br /><br />Hope it helps, do leave me a comments. No files are hosted on this site !Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com6tag:blogger.com,1999:blog-4089703635950888934.post-61736902362833340792009-10-02T20:20:00.004+05:302009-10-03T01:11:54.851+05:30SQL Server 2008 Memory Leak / windows server 2008 high memory utilizationHaving working with Cubes on SQL Server 2000, I had grown used to the fact that SQL will use and release memory depending on its need and I would be able to track the about of memory each program is utlizing through the task manager tab.<br /><br />However its important to note the following. With windows server 2008 and SQL Server 2008 ( probably SQL Server 2005) the above mentioned assumptions are completely wrong. SQL Server 2008 will utilize as much memory that is available on the box, in my case 64 GB if any job works with high volumes of data but will NEVER EVER release this RAM back to the system once the job completes.<br /><br />In short, the memory get reserved for SQL Server 2008 till the service / Server gets restarted. In case SQL needs to run some other job that requires data to be loaded, it internally will flush out the older data and load what it needs and yes even then nothing gets released back to the server.<br /><br />Also to be noted is that in the task manager, none of this memory is ever shown against any of the processes that are running. Even if you use process explorer (sysinternals) this memory does not show up against SQL Server 2008 there as well.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCo4g00CcizoGHOj9ig3SRAVGmA_pvQg-VskXH9F7nx8uSOmKTnSwAoUt5woA3v8Rw7mj0T1vt0GHM_onPSAbu-jsJM2UE0Qwrxni1QCIYKUmk_sLSQLHj8WSOj0wkjz4XxG6Z_2L_W9k/s1600-h/sql+server+memory+leak.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 250px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCo4g00CcizoGHOj9ig3SRAVGmA_pvQg-VskXH9F7nx8uSOmKTnSwAoUt5woA3v8Rw7mj0T1vt0GHM_onPSAbu-jsJM2UE0Qwrxni1QCIYKUmk_sLSQLHj8WSOj0wkjz4XxG6Z_2L_W9k/s400/sql+server+memory+leak.JPG" alt="" id="BLOGGER_PHOTO_ID_5388023672437472482" border="0" /></a><br /><br />Sadly this leads people ( including me) to come to the conclusion that there is a memory leak in SQL Server 2008. To convince yourself, just limit the amount of memory SQL Server can use and then check out the memory utilization in task manager. It will be that amount plus whatever is required to run your server.<br /><br />There is article that describes this much more technical detail here ...<br /><a href="http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/08/24/troubleshooting-the-sql-server-memory-leak-or-understanding-sql-server-memory-usage.aspx"><br />http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/08/24/troubleshooting-the-sql-server-memory-leak-or-understanding-sql-server-memory-usage.aspx</a><br /><br />Its a good idea to prevent SQL from utilizing the entire memory else the server can become unstable.<br /><br />P.S. There is no memory leak :)Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com4tag:blogger.com,1999:blog-4089703635950888934.post-680164679823809432009-08-22T15:50:00.004+05:302009-08-22T16:35:43.783+05:30Excel 2007 OLAP Writeback SSAS 2008We wanted to build an application based on the Writeback capability of Microsoft. The dream was to have a cube with multiple dimension allowing our users to analyze data by slicing / dicing this cube and based on their analysis make changes to the numbers at various levels.<br /><br />Once they were happy with the data post changes we were to flow this data to a downstream system. It was to be a highly interactive system for a reasonably competent user to plan target setting by carrying out what if analysis on the existing data.<br /><br />The front end for the user was Excel 2007 as the navigation / user interface was phenomenon and all our users in our company were fairly competent in Excel.<br /><br />The path we started down was to have SQL Server Analysis Services 2005 as the backend sitting on a Hexacore 4 processor Windows Server 2008 box. We then enabled the cube for Writeback. The way this works according to me at a high level is that whatever numbers you choose to writeback, it does not make the change directly to your cube, what it does however is to create a writeback partitition that stores the net off data so that you could see the required number on your front end.<br /><br />Let me explain that a little more with an example, lets say for one depot for one product the value initially was 100. As part of the writeback lets say you want it to be 70. What actually happens is that an entry takes place in the writeback partition for that depot and that product as -30. Based on a join of these two the number dispayed is 70.<br /><br />While this works perfectly for small sets of data, it fails miserably for larger sets. The solution becomes impractical and very sluggish if the writeback is at an aggregate level and affecting large number of leafs / touples. Post engaging with Microsoft Consulting we confirmed that this was not going to work out for the application we had in mind.<br /><br />OLAP Writeback sucks, period !!! and even Microsoft didn't have a response :) Now just because the writeback using the writeback partitition is hopeless it does not mean that its the only way to writeback user inputs into the cube.<br /><br />The path we finally deployed our solution was a combination of the following.<br />VBA ( Macro coding) / Web services / SQL Server 2008 Integration services and SQL Server 2008 Analysis Services.<br /><br />The excel that was shared with the users had a custom built macro code that essentially looped through the page / row / column fields to gather the user selections. Care had to taken to be able to loop through both the dimension member as well as the attributes. ( This is feature of SQL Server 2005 + , do read up if you are unaware) Also note it gets more complicated in Pivot 12 as there is extended capability in terms of Value and Label filters, both of which needs to be captured as well incase someone has applied them.<br /><br />Once all the filters are looped and the details captured, the macro uses this data to frame a create sub cube query that gets passed to the server using a web service. This sub cube that gets created on the fly contains the entire data from the main cube that needs to undergo the writeback / change.<br /><br />The next step is to strip this newly created sub cube to retrieve the underlying rowset of data that makes up the cube. Once we have that into a table, we have the option of applying pretty much any rule on this data, disaggregation / static values / percentage of existing value / percentage of another value.<br /><br />Post applying the rule, the data gets updated into the base cube data and an incremental process is carried out and voila you have implemented your writeback.<br /><br />Just to share some of the numbers, we were able to carry out a writeback affecting 3 Lakh records ( Thats three hundred thousand records :) in India) in a little over 2 minutes with the majority of the time in the incremental processing. This ofcourse will depend on the size and complexity of your own cube.<br /><br />If your curious about the rest of the design, well since we had the changes in the table we could build an SSIS package to incrementally flow this information down stream into a DB2 environment using OLE/DB2 providers which ofcourse has its own problems in life :)Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com5tag:blogger.com,1999:blog-4089703635950888934.post-54646224161759240942009-06-21T22:40:00.002+05:302009-06-21T22:48:18.926+05:30Motorola RAZR V3 - Charge via USB on PCThere are other articles that explain this but finding the files for this can sometimes be a problem. Basically the usb does not work directly, software drivers need to be installed on the machine that you want to use to charge.<br /><br />These drivers can be downloaded here ...<br /><br /><a href="http://ofg.osnn.net/razr/">http://ofg.osnn.net/razr/</a><br /><br /><br />The detailed article for the same can be found here<br /><a href="http://www.somelifeblog.com/2007/02/motorla-razr-v3-charge-via-usb-on-pc.html"><br />http://www.somelifeblog.com/2007/02/motorla-razr-v3-charge-via-usb-on-pc.html</a>Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com0tag:blogger.com,1999:blog-4089703635950888934.post-60510670230330729382009-05-12T00:32:00.009+05:302009-05-12T01:07:30.485+05:30IBM OLE DB provider for DB2 sql server 2008 / DB2 Administration Client Windows Server 2008While setting up our production environment we ended up wasting a day as we couldn't create a linked server using IBM OLE DB provider for DB2 as it wasn't showing up in the options. We apparently were trying to install the 32 bit client of the server while we needed the x64 version. After figuring that out we began a hunt to download the required file which in reality was quite painful as it wasn't clearly mentioned anywhere.<br /><br /><br />In order to save others the trouble, the driver comes along with the installation of the "DB2 Administration Client " as part of the 8.2 versions and as "IBM Data Server Client " in the 9.5 versions. The links in the document are valid for Windows Server 2008 utilizing x64 architecture. If your on 32 bit , you can navigate to the right download from the given pages itself.<br /><br />The page for the current version of DB2 v9.5 is as follows, make sure you download the "IBM Data Server Client" file. It is part of the fix pack 3b which is latest at the time of this article<br /><br /><a href="http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21288113">http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21288113</a><br /><br />The direct file<br /><a href="ftp://ftp.software.ibm.com/ps/products/db2/fixes2/english-us/db2winX64v95/fixpack/FP3b_WR21447/v9.5fp3b_ntx64_client.exe"><br />ftp://ftp.software.ibm.com/ps/products/db2/fixes2/english-us/db2winX64v95/fixpack/FP3b_WR21447/v9.5fp3b_ntx64_client.exe</a><br /><br />In case you are using / want the DB2 v8.2 client, make sure you download the "DB2 Administration Client" file. It is part of the fix pack 17a which is latest at the time of this article<br /><br /><a href="http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21256105">http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21256105</a><br /><br /><br />The direct file<a href="ftp://ftp.software.ibm.com/ps/products/db2/fixes2/english-us/db2winAMD64v8/fixpak/FP17a_WR21442/FP17a_WR21442_ADMCL.exe"><br /><br />ftp://ftp.software.ibm.com/ps/products/db2/fixes2/english-us/db2winAMD64v8/fixpak/FP17a_WR21442/FP17a_WR21442_ADMCL.exe</a><br /><br />Please note that there are different versions for different architectures x32 / x64 / IA64. Download the right file for yourself.<br /><br />Additionally if you are looking for the Microsoft OLEDB Provider for DB2, it is available as part of the Microsoft SQL Server 2008 Feature Pack, October 2008 located here<br /><a href="http://www.microsoft.com/downloads/details.aspx?FamilyId=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en"><br />http://www.microsoft.com/downloads/details.aspx?FamilyId=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en</a><br /><br />Do let me know if this has been helpful. Cheers !Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com1tag:blogger.com,1999:blog-4089703635950888934.post-26010450616747596952009-04-09T00:42:00.008+05:302011-08-17T01:17:50.454+05:30Google Chrome not working / Google Chrome stopped workingI had this really weird issue where google chrome stopped working on my laptop, did some search and I finally found this obscure post on google's own site asking the user to try something to make it work. Interestingly it did, the version for which the solution was written for was different but essentially the method is what is important.
<br />
<br />The issue was that on clicking the chrome icon nothing happens, the browser does not load up, and the task manager does not show the process to be running. Not sure what triggered this though.
<br />
<br />
<br />The solution is to go to the following path in your command prompt
<br />
<br />C:\Documents and Settings\(user name)<account>\Local Settings\Application Data\Google\Chrome\Application\<version>(version number)\Installer
<br />
<br />Run the following statement
<br />
<br /><span>setup.exe --rename-chrome-exe
<br /></span>
<br />
<br />quit the command prompt with an exit. Chrome started working for me after that, hope it works for you as well. The link of the google page from where I got this from is below
<br /><a href="http://www.google.com/support/forum/p/Chrome/thread?tid=2680b41d121dc73a&hl=en">
<br />http://www.google.com/support/forum/p/Chrome/thread?tid=2680b41d121dc73a&hl=en</a>
<br />
<br />Do let me know if this has helped you, if your feeling generous you could donate a dollar via paypal :)</version></account>Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com16tag:blogger.com,1999:blog-4089703635950888934.post-21244030286275836272009-03-28T14:34:00.005+05:302011-08-17T01:17:29.066+05:30Airtel blocking Websites partiallyI had this unique problem on my parents laptop, certain sites such as facebook, yahoo groups, hotmail would be able to log in but thats about it, nothing else would work after that with the page just timing out when you click on anything.
<br />
<br />Mail on the POP3 would download but SMTP mail send would fail occasionally by timing out.
<br />
<br />Wondering why my ISP was preventing this from happening. The Airtel Beetel Modem is connected to a Netgear Router for wireless access.
<br />
<br />It turns out that the issue was a combination of my ISP along with the wireless Router. There exists a setting on the wireless routers called MTU size in bytes. This typically is found on the WAN tab of your router and is set to 1500 bytes. The type of connection between the modem and the wireless router is a PPPoE type of connection. For this sort of connection the ideal value for this parameter is 1492. The technical details of this can be found on the following link.
<br /><a href="http://www.dslreports.com/faq/695">
<br />http://www.dslreports.com/faq/695</a>
<br />
<br />By changing this parameters all the problems just disappeared ! Further read up has shown that this could cause problems to other services as well such as telnet / ftp / https / VPN like securepoint etc.
<br />
<br />In order to change this setting, log into your wireless router and navigate to the WAN setup link. Make the change and click apply.
<br />
<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjktAsNZI_UzMFAvtPXSwXEK1gUXtlyMxYR6aanG4BA_ju8bx6eSJacOxpqiuNJEoY3Q43uEQWlt1KGoGGpOe4Niq8MXYxhOPSC2PYjJ87FO2JgwYZRtpWpqeyr8ETPOIXCBqc95rLMgE4/s1600-h/wan.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 238px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjktAsNZI_UzMFAvtPXSwXEK1gUXtlyMxYR6aanG4BA_ju8bx6eSJacOxpqiuNJEoY3Q43uEQWlt1KGoGGpOe4Niq8MXYxhOPSC2PYjJ87FO2JgwYZRtpWpqeyr8ETPOIXCBqc95rLMgE4/s400/wan.JPG" alt="" id="BLOGGER_PHOTO_ID_5318167183260923714" border="0" /></a>
<br />Do let me know if this has been helpful by dropping me a comment.
<br />Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com2tag:blogger.com,1999:blog-4089703635950888934.post-63184001609274378732009-01-12T17:35:00.004+05:302011-08-17T01:17:03.878+05:30Blog Language TranslationReading up that the majority of users the world over search for information in languages other than english it obviously makes sense to provide the option to translate my blog into different languages.
<br />
<br />Unfortunately it wasn't as easy as I thought it would be as the widgets offered by Blogspot didn't seem to have it directly available.
<br />
<br />I finally managed to find the translation engine provided by google itself as a widget. Go to the translate.google.com site
<br />
<br />Select the tools tab and you will get the code for added to your widget in your site.
<br />
<br />The code is as follows
<br />
<br /><$source src="http://www.gmodules.com/ig/ifr?url=http://www.google.com/ig/modules/translatemypage.xml&up_source_language=en&w=160&h=60&title=&border=&output=js"><$/script>
<br />
<br />Make sure you remove the $ between < and script in the start of the code and in the end between < and /script. I needed to add that to make this blog treat it as text and not html code :)
<br />
<br />
<br />Additionally there was this good resource I found with additional information about language translation I found over here
<br />
<br />http://labnol.blogspot.com/2005/11/add-language-translation-to-website.html
<br />
<br />Hope you found this useful. Do drop me a line would love to hear from you.Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com0tag:blogger.com,1999:blog-4089703635950888934.post-32285677476408421712008-12-30T23:40:00.007+05:302011-08-17T01:12:14.688+05:30Automailer Batch Script using BlatQuite sometime back we needed a simple way to inform our customers the status of their order, the system was able to generate a text file with the code of the customer but we still needed to figure out how to get it to them.
<br />
<br />
<br />Instead of coding a complicated solution we decided to use a small batch script that did this job. We basically get all these files into a single folder and get the script to run every fifteen minutes to send across a mail to these customers with the file attached.
<br />
<br />To enable this we use a small freeware program called blat. Its a command line mailer, a program that allows you to send a mail from the dos prompt.
<br />
<br />Its available here
<br />
<br /><a href="http://www.blat.net/">www.blat.net</a>
<br />
<br />The script works with a list that has the customer code in one line and the email addresses that the file needs to be sent to on the next line comma separated without any spaces. If a new customer is added, the code and email address would need to be added to the file
<br />
<br />For this example the file is called customer.txt and the contents are in the following format
<br />
<br />1234
<br />abc@abc.com,def@def.com
<br />5678
<br />abc@abc.com,def@def.com,xyz@xyz.com
<br />
<br />The script loops through all the files in the folder and picks up the email addresses it needs to send the email too and send it across. It then moves the file into the respective folder of the customer code.
<br />
<br />To understand how it works, its important to understand how blat works. Blat needs to first be configured with the smtp server before the script works.
<br />
<br />The usage is blat -savesettings
<br />
<br />The normal usage is shown below and can be brought up by blat/?
<br />
<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0bIrS7-C-32DZijuJ66HnDiqp2GlhT_NOoXtN6qNmNzSoiqrak1aIgsSs6GvLvQvY0vWTkdNyoi7oe-JijjxKMvr8owAaJj_j1rka3OBd6LBhkPHmdBz9pegR6h9R6S3iUgrHN6JIrNU/s1600-h/automailer.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 203px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg0bIrS7-C-32DZijuJ66HnDiqp2GlhT_NOoXtN6qNmNzSoiqrak1aIgsSs6GvLvQvY0vWTkdNyoi7oe-JijjxKMvr8owAaJj_j1rka3OBd6LBhkPHmdBz9pegR6h9R6S3iUgrHN6JIrNU/s400/automailer.JPG" alt="" id="BLOGGER_PHOTO_ID_5285664848040289042" border="0" /></a>
<br />The script is below
<br />
<br />
<br />:start
<br />echo off
<br />
<br />rem This allows for the variable to work within a for loop
<br />SETLOCAL ENABLEDELAYEDEXPANSION
<br />
<br />rem This resets the variables used
<br />set a=1
<br />set rs=none
<br />
<br />rem This is the loop that goes through for each file in the current folder and sets the
<br />rem every line of the customer.txt to variable i
<br />rem The variables a and b are used to alternate between the customer code and addresses
<br />rem The rs variable is used to store the customer code on every alternative line of the txt file
<br />
<br />for /f "tokens=*" %%i in (customer.txt) do (
<br />
<br /> if "!a!"=="1" set rs=%%i
<br /> if "!a!"=="1" set b=2
<br /> if "!a!"=="2" if exist *!rs!*.txt blat -t %%i -body "Order details" -s "Order report - !rs!" -attach *!rs!*.txt
<br /> if "!a!"=="2" if exist *!rs!*.txt move *!rs!*.txt !rs!
<br /> if "!a!"=="2" set b=1
<br /> if "!a!"=="2" set a=1
<br /> if "!b!"=="2" set a=2)
<br />echo on
<br />
<br />Hope you can get this script to work for you the way you want to. Do drop me a comment would love to hear from you.
<br />
<br /><span style="font-style: italic;"></span>Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com0tag:blogger.com,1999:blog-4089703635950888934.post-77692222484408279242008-11-14T20:24:00.006+05:302011-08-17T01:16:30.710+05:30Excel 2007 Macro Security ProblemI had written certain Macro on an Excel 2003 Workbook to be distributed hence the Sheet was protected as well the the Macro. It used to work perfectly, it even used to work in Excel 2007 after opening up in Compatibility Mode.
<br />
<br />Recently after finding the need to work with larger sets of data I decided to save the file as a Macro Enabled Worksheet. Unfortunately my woes just began. On opening the newly created page I received the Security Warning that macro have been disabled as shown below.
<br />
<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiaNu3WGnpE4z3UVe7XtBCW7xQcZ_dJeHGbzI9z-U0ajKWFJ9WAzpG4RrOQJ11OPy3UFRJ9B03Ro5fSCv93-40iUOiVNWMGBOcI1uVAn3G_yrf-JNZF6ScQCitgPcdbUUWGmJ7NXB68gaQ/s1600-h/excel2007macro.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 289px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiaNu3WGnpE4z3UVe7XtBCW7xQcZ_dJeHGbzI9z-U0ajKWFJ9WAzpG4RrOQJ11OPy3UFRJ9B03Ro5fSCv93-40iUOiVNWMGBOcI1uVAn3G_yrf-JNZF6ScQCitgPcdbUUWGmJ7NXB68gaQ/s400/excel2007macro.JPG" alt="" id="BLOGGER_PHOTO_ID_5268528689325743218" border="0" /></a>
<br />On selecting options there was no longer an option to enable this content. Adding the location to the trusted location etc etc did not have any affect. After reading up a bit I came to know that there exist a registry hack to disable Excel 2007 from mandating that the Macro needs to be scanned by the Antivirus.
<br />
<br />You can either save the below code into a .reg file and execute it or go into your registry to the location mentioned. Add the DWORD and set it to 1
<br />
<br />Windows Registry Editor Version 5.00
<br />
<br />[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security]
<br />"ExcelBypassEncryptedMacroScan"=dword:00000001
<br />
<br />
<br />Post the registry correction you have the option to enable this content as shown in the image below.
<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdl2ia0OjoudU9PPFSTLrxnayLYxVJsTyE3qnZfBzx6S3nbm3wegGx54vR-ofZgdEOTIJDq8DYITa_4QCXAiyt4RCU2c8Gq_DJlu8OQ611f5JHnD1E6r9cr95qNukYXMshE4USl0b20nw/s1600-h/excel2007macrofixed.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer; width: 400px; height: 287px;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgdl2ia0OjoudU9PPFSTLrxnayLYxVJsTyE3qnZfBzx6S3nbm3wegGx54vR-ofZgdEOTIJDq8DYITa_4QCXAiyt4RCU2c8Gq_DJlu8OQ611f5JHnD1E6r9cr95qNukYXMshE4USl0b20nw/s400/excel2007macrofixed.JPG" alt="" id="BLOGGER_PHOTO_ID_5268528690986459394" border="0" /></a>
<br />
<br />
<br />The helpful resource that helped me solve this problem was
<br />
<br />http://www.rondebruin.nl/password2007.htm
<br />
<br />
<br />Another useful site that I have come across to help users move into Excel 2007 is
<br />
<br />http://office.microsoft.com/assistance/asstvid.aspx?assetid=XT101493291033&vwidth=1044&vheight=788&type=flash&CTT=11&Origin=HA101491511033
<br />
<br />
<br />It allows you to quickly find out where each of the option of Excel 2003 are found in Excel 2007. Hope you found this useful, do drop me a comment if possible.
<br />Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com4tag:blogger.com,1999:blog-4089703635950888934.post-80262083355295032402008-10-19T21:02:00.007+05:302008-10-19T21:56:12.406+05:30Port Forwarding Airtel Beetel Modem / Netgear WRG614Would recommend reading of my previous post as it talks about how the setup exists between the modem and wifi router.<br /><br />http://piglings.blogspot.com/2008/09/airtel-beetel-modem-netgear-wgr614-wifi.html<br /><br />The Wifi router is setup as an access point so the Beetel Modem acts as the DHCP and the port forwarding needs to be done on the Beetel itself.<br /><br /><br />Okay, port forwarding needs to done to enable certain application / games to interact across the internet. It provides the capability to forward traffic from the ip that currently terminates at the Modem to the computer that needs to receive it.<br /><br />Step 1<br /><br />Access your Beetel Modem on the following address<br /><br />http://192.168.1.1/main.html<br /><br />Username: admin<br />Password: admin<br /><br />Step 2<br /><br />Select Advanced Setup ---> NAT ---> Virtual Servers<br /><br /><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQUzOsv1QFHPmozw99nhXTUoPO9_FeIEchXw1XQN-DEySiu9Eca1HhdmF9hojci1hOZwf9Cewm4XbT2wlu7n9XJm_ekZzcSFvAqqAcXXba5dc63yBxqLZkNZl17godsZOiA8Vl7t85vJg/s1600-h/Port+forwarding.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQUzOsv1QFHPmozw99nhXTUoPO9_FeIEchXw1XQN-DEySiu9Eca1HhdmF9hojci1hOZwf9Cewm4XbT2wlu7n9XJm_ekZzcSFvAqqAcXXba5dc63yBxqLZkNZl17godsZOiA8Vl7t85vJg/s400/Port+forwarding.JPG" alt="" id="BLOGGER_PHOTO_ID_5258893984418017634" border="0" /></a><br />Step 3<br /><br />Click Add, check if the application you need to port forward exists, if so please select and in the Server IP address put in the address of the computer you need to forward to 192.168.1.10.<br /><br />Make sure that the IP of this machine is made static, refer my above blog entry to figure out how to do that else, this will not work if your computer keeps getting different IP addresses.<br /><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGLSdfoMVY6HysWRuXb4cwRNfLqif4wBwx2w4ENvV6AxDp_UsU0YuFnG3mSFL-lX-dnaEF7TQhdUVyn0t9ZujCja2dRHMUbtzZAp2Q2btJWeoBfk5FK9fzpoif5kLx-W1ewxitrgWlpKs/s1600-h/Port+forwarding+selection.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGLSdfoMVY6HysWRuXb4cwRNfLqif4wBwx2w4ENvV6AxDp_UsU0YuFnG3mSFL-lX-dnaEF7TQhdUVyn0t9ZujCja2dRHMUbtzZAp2Q2btJWeoBfk5FK9fzpoif5kLx-W1ewxitrgWlpKs/s400/Port+forwarding+selection.JPG" alt="" id="BLOGGER_PHOTO_ID_5258894785001324818" border="0" /></a><br />Click the save apply.<br /><br />Step 4<br /><br />This step is to be used if the application you need to do port forwarding for does not exist in the list that has been provided in the DSL Modem.<br /><br />Select Custom Service, put a name for example I have put VNC.<br /><br />Put the start port number and the end port number, the internal port numbers will automatically fill up.<br /><br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOaGQL0EhyphenhyphenAsF_MCAsZpixd73n2OrmbvNv0PQO0q4jtk_txdMwsqOmJMR55PWgL9LUBeEF2qteQyTqBhXDhEUUlChBf7cettchFu24m9ycQpcD9jrn3RaV5WwK5EBkfDKxorCzJNH5EzM/s1600-h/Port+forwarding+vnc.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOaGQL0EhyphenhyphenAsF_MCAsZpixd73n2OrmbvNv0PQO0q4jtk_txdMwsqOmJMR55PWgL9LUBeEF2qteQyTqBhXDhEUUlChBf7cettchFu24m9ycQpcD9jrn3RaV5WwK5EBkfDKxorCzJNH5EzM/s400/Port+forwarding+vnc.JPG" alt="" id="BLOGGER_PHOTO_ID_5258898588678487298" border="0" /></a><br />If the Service requires multiple ranges, you can enter in each of the ranges on the next lines.<br /><br />If your not sure of whether the service requires a TCP or a UDP would suggest you select the option of TCP / UDP in the Protocol drop down.<br /><br />Step 5<br /><br />After saving you need to reboot the system for it to take place. Best way to is to power off and power on the setup.<br /><br />The best way to check if your setup is working is to go to a site that lets you check for example<br /><br />http://www.canyouseeme.org/<br /><br />Keep in mind the IP of your computer you need to forward to is static. If this works do drop me a line, would love to hear. If your feeling generous click an ad :)Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com5tag:blogger.com,1999:blog-4089703635950888934.post-76111645762960250532008-10-14T23:36:00.008+05:302009-09-17T00:38:36.193+05:30Asus Mobile Phone Service Center BangaloreI recently had a problem with my Asus P320 mobile phone, looked up on the net and couldn't find details of the service center for Bangalore, apparently it recently shifted last month. Thought I post the details here to help out others. The service center services all ASUS products, not just mobile phones.<br /><br /><img src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiJ1ZDkAJR5zD3ofrfMZi0sAC5uKNGcXHMvwIph8c7bg9jlseHheOfLVBihIs2KXTbS4FPTiqx64mKvjBXKU7qCfdXfTaPEjDuVi8iRN2AIz_KSO-2inPsNWvE2eYx4v1MQZiHH1J5EhCw/s400/images.jpg" style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer;" alt="" id="BLOGGER_PHOTO_ID_5258801727572779538" border="0" />The ASUS Service Center or Asus Royal Club as it is called is located at<br /><br />Number 1105, 3rd Floor, Kambi complex,<br />Near Corporation circle,<br />Bangalore 560002.<br /><br />In terms of Landmark it is behind the LIC building adjacent to Adigas restaurant.<br /><br />The phone number is (080)22112942. Prior to this I came across an All India toll free number but I couldn't get anyone to pick it up, the number was 1800 2090 365.<br /><br />The timing are 10 am to 8 pm on weekend days and 10 am to 5 pm on Saturday. You will need your bill as proof for warranty.<br /><br />I have put together a blog for this phone over here<br /><br /><a href="http://p320.blogspot.com/">http://p320.blogspot.com/</a><br /><br />If you have found this useful, do drop me a comment, if your feeling generous click an ad :)<br /><br />There is a lot more information available on the Asus P320 at the following site<br /><a href="http://p320.blogspot.com/"><br />http://p320.blogspot.com</a>Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com32tag:blogger.com,1999:blog-4089703635950888934.post-29076571649248947972008-09-27T14:53:00.020+05:302009-12-13T01:25:46.223+05:30Airtel Beetel Modem + Netgear WGR614 Wifi RouterThere are a couple of articles available on the internet explaining how to set this up but I after playing around a lot I realized that there are much easier ways of setting up a connection such as Airtel / BSNL / Tata with your own Wifi router such as Netgear / Buffalo / Linksys.<br /><br />The most widely published explanations involves converting your ADSL Modem / Router (Beetel) into Bridge mode thereby only making it work as a modem and making the Wifi Router (Netgear) do all the work.<br /><br />While this works fine it involves changes to be made to the configuration of the ADSL Modem in terms of setup as well the requirement of the username and password to entered into the Wifi Router setup. Also once you do this setup you will lose access to your Modem, requiring you to unplug the wifi router to access it.<br /><br />Will be descibing a method below on an easier approach to getting your wifi online without needing to know your password or change any other settings on the ADSL modem.<br /><br />Step 1<br /><br />Plug in the network cable coming out of the ADSL modem /router ( Beetel) into the network port of your computer / laptop.<br /><br />The computer should automatically get assigned a ip address of the following series<br /><br />192.168.1.2<br /><br /><br />This means that the ADSL modem address would be 192.168.1.1. Type in the following address to access the page of the ADSL modem.<br /><br />http://192.168.1.1/main.html<br /><br />It is will pop up a username and password<br /><br />username : admin<br />password : password<br /><br />Other standard is admin / admin<br /><br />Step 2<br /><br />Click on Advanced Setup --> LAN, you should see the following page , or something very similar. This is fine , no need to change anything, though you may want to change your password for security reasons as this page can be access from the internet as well.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_HjkqjZLvZwbVxTRAVvPqScrfVZHbbwvZfWSqF9zJpIkX1VkmDgo4g3zSkO2sfZ111gS4rXy-y3cBdFmtJz4KnsAbXdTAN8TFl-aA1PiYYarrIMEfSXoCvdhcYREgd6JjVm1cU0ZVT4o/s1600-h/router.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_HjkqjZLvZwbVxTRAVvPqScrfVZHbbwvZfWSqF9zJpIkX1VkmDgo4g3zSkO2sfZ111gS4rXy-y3cBdFmtJz4KnsAbXdTAN8TFl-aA1PiYYarrIMEfSXoCvdhcYREgd6JjVm1cU0ZVT4o/s400/router.JPG" alt="" id="BLOGGER_PHOTO_ID_5250630932257265538" border="0" /></a><br />From the device Info ---> Summary Screen write down the Primary DNS Server address and the Secondary DNS Server address.<br /><br />Step 3<br /><br />Disconnect from the ADSL modem, switch on your wireless router, if you have a system with wireless, switch on your laptop wireless, it should connect to the wireless on the router. Otherwise plug in the network cable into one of the LAN ports of the router with the other end into your computer.<br /><br />Let the router assign you an IP. It typically would be of the series 192.168.0.2 ..<br /><br />Type the following address to access the main page<br /><br />http://192.168.0.1<br /><br />It is will pop up a username and password<br /><br />username : admin<br />password : password<br /><br />Other standard is admin / admin<br /><br /><br />Step 4<br /><br />You should see the following page<br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-8jlXnMzUJqDK_ueC7qp9g1bFPuy3TIs_8WGZdgrxZtRjT5PGoyAxtFxoVdnxzW4sFqpjD7OS8s-L8rpP2okFBoVAex6Xd5WLqeZteFfgPApv5ZwIpXxqa7WKBbAa5lsaypuT2VegqNs/s1600-h/double1.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-8jlXnMzUJqDK_ueC7qp9g1bFPuy3TIs_8WGZdgrxZtRjT5PGoyAxtFxoVdnxzW4sFqpjD7OS8s-L8rpP2okFBoVAex6Xd5WLqeZteFfgPApv5ZwIpXxqa7WKBbAa5lsaypuT2VegqNs/s400/double1.JPG" alt="" id="BLOGGER_PHOTO_ID_5250630663255259218" border="0" /></a><br />Make the following entries<br /><br />Does your Internet connection require a logn ---> No<br /><br />Account Name ---> Blank<br />Domain Name ---> Blank<br /><br />Internet Connection<br /><br />Check the box that says use Static IP Address<br />Enter the address as 192.168.1.x where x is a larger number larger than the number of system you ever plan to connect, in my case 20 so that it never gets assigned by the ADSL router.<br /><br />The 192.168.1 needs to be the same that you used for accessing your ADSL router.(192.168.1.1). Basically now this router is part of the ADSL addressing system.<br /><br />Check the box that says use the following DNS server<br />Put in the DNS address you have copied in the previous step<br /><br />Step 5<br /><br />In the advanced menu, click LAN IP Setup, you should see the screen below.<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirdms12y70Jixvi5xCeylpdZtUiU6dg6V2Pvm7TlaUqOuNtL1ZE1l1Ono7n1EzXaZ2LLD5bMo7qpBne2WFOuxbNKw_9BOK2vxNZn24cd29SyNY9i5tMlNAZz7cPBzykA5eO0hYAesNEZY/s1600-h/ap.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEirdms12y70Jixvi5xCeylpdZtUiU6dg6V2Pvm7TlaUqOuNtL1ZE1l1Ono7n1EzXaZ2LLD5bMo7qpBne2WFOuxbNKw_9BOK2vxNZn24cd29SyNY9i5tMlNAZz7cPBzykA5eO0hYAesNEZY/s400/ap.JPG" alt="" id="BLOGGER_PHOTO_ID_5250630343336231778" border="0" /></a><br />In the LAP IP Setup, enter the IP Address, the same as entered in the previous screen, 192.168.1.x, in my case 192.168.1.20<br /><br />Enter the subnet as 255.255.255.0<br /><br />Leave the other options as is.<br /><br />Make sure the Use Router as DHCP option is Unchecked !<br /><br /><br /><br />Step 6<br /><br />Click on the Wireless setting tab , you should see the screen below<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihdJ1jYIzrMVMt6KFm_nOXQt8GqBZSniMFK2Wk7nuZ6_DocNkgFV9qug5O5elPp3xd9KAT-CPDALBzEjuDZeCnWNqlP7hrgxM9yeWhkrBSDV_dn2sKKG80evD-WRSrvmUoo3W1Hxp9BxM/s1600-h/security.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEihdJ1jYIzrMVMt6KFm_nOXQt8GqBZSniMFK2Wk7nuZ6_DocNkgFV9qug5O5elPp3xd9KAT-CPDALBzEjuDZeCnWNqlP7hrgxM9yeWhkrBSDV_dn2sKKG80evD-WRSrvmUoo3W1Hxp9BxM/s400/security.JPG" alt="" id="BLOGGER_PHOTO_ID_5250631105851087282" border="0" /></a><br />assign any name you want for your wireless connection. You can choose to have no protection but its unsafe. Its very important to password protect your internet connection. There are typically two types WEP and WPA. Make sure you write down the password you are setting because you will need this to connect wirelessly. The password in the above case is for WEP connection, it is the hexadecimal code.<br /><br />Below is the option for WPA. You need to remember the passcode you have entered here. WPA is much more secure, WEP can be hacked, I've done it :)<br /><br /><a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjp41LQu1vCHt_hjPUXLoVfrJ7Jej0mE7IwwtSm7Hbs8ICPNsvr8OoXK_EPA11-Ae8097xmV4A6Zbc0-VuQy2vh82SwWctP7HSWNrSPJ2BVhNFm72P36VEauns-eAaQ9tgh9xSSwKrFnvM/s1600-h/security2.JPG"><img style="margin: 0px auto 10px; display: block; text-align: center; cursor: pointer;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjp41LQu1vCHt_hjPUXLoVfrJ7Jej0mE7IwwtSm7Hbs8ICPNsvr8OoXK_EPA11-Ae8097xmV4A6Zbc0-VuQy2vh82SwWctP7HSWNrSPJ2BVhNFm72P36VEauns-eAaQ9tgh9xSSwKrFnvM/s400/security2.JPG" alt="" id="BLOGGER_PHOTO_ID_5250631271026388818" border="0" /></a><br /><br />Step 7<br /><br />You are almost done , but pay attention. Power off both the ADSL modem / router and wifi router. Take the network cable and plug it into the available LAN socket on the ADSL Modem. The other end on the LAN cable need to be plugged in any of the Wifi Router's LAN sockets. Be very careful not to plug it into the WAN socket, this is a single socket, typically the Netgear Router will have 1 WAN and 4 LAN sockets. So I say again, the LAN socket only, if your still confused, just plug it into the middle socket. :)<br /><br />You Wifi router is now working as an Access point and all the computers that connect to it will be assigned IP from the ADSL Modem / Router in the 192.168.1.2 , 192.168.1.3 series once you enter the password based on the protection you have choosen.<br /><br />You are now up and running :)<br /><br />Points to note<br /><br />1. You can still access your ADSL router page with 192.168.1.1/main.html<br />2. You can access your Netgear Wifi router with the new address of 192.168.1.20<br /><br />Do drop me a comment if you have found this useful. If your feeling generous you could donate a dollar via paypal :)<br /><br />Will link in port forwarding separately. Ok have done the port forwarding part, its available here<br /><br /><a href="http://piglings.blogspot.com/2008/10/port-forwarding-airtel-beetel-modem.html">http://piglings.blogspot.com/2008/10/port-forwarding-airtel-beetel-modem.html</a><br /><br />Incase of errors in connecting to certain sites / VPN / mail etc do check out the following page<br /><br /><a href="http://piglings.blogspot.com/2009/03/airtel-blocking-websites-partially.html">http://piglings.blogspot.com/2009/03/airtel-blocking-websites-partially.html</a>Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com46tag:blogger.com,1999:blog-4089703635950888934.post-9943402491640021832008-09-21T16:07:00.009+05:302011-08-17T01:15:47.298+05:30Dot .Net 3.5 SP1 Installation ErrorThe other day for one of our projects we needed to upgrade to SQL Server 2008. Part of the pre requisites was to have .Net framework 3.5 installed on the machine. The DVD had the install for the framework but it just wouldn't install.
<br />
<br />The setup would unarchive all the required files, and fire the setup program. The progress bar would increase all the way upto 95 - 98 % and just hang. I am talking about the full package and not the boot strapper. Tried after a couple of re boots but exactly the same problem on a couple of my machines, all running XP Pro SP2.
<br />
<br />Did some readups and a few people have had some install problems. The solution for this kind of problem is to disable all your network adapter. Go to the Network Connection menu, right click the connections and say disable. Once this is done, run the install for the full package, it should go through rather quickly with the Microsoft EULA popping up as soon the setup progress finishes.
<br />
<br />Don't know why this happens, am assuming that the package still tries to verify if all parts are available for install and wants to connect to the net but is unable to do so through our proxy servers.
<br />
<br />Either way, this workround works well. You would need to install the framework for SQL Server 2008, Visual Studio 2008 and going forward probably a lot more applications that get developed on the microsoft platform.
<br />
<br />The microsoft page is here
<br /><a href="http://www.microsoft.com/downloads/details.aspx?familyid=AB99342F-5D1A-413D-8319-81DA479AB0D7&displaylang=en">http://www.microsoft.com/downloads/details.aspx?familyid=AB99342F-5D1A-413D-8319-81DA479AB0D7&displaylang=en</a>
<br />
<br />The full package install is here
<br /><a href="http://download.microsoft.com/download/2/0/e/20e90413-712f-438c-988e-fdaa79a8ac3d/dotnetfx35.exe">http://download.microsoft.com/download/2/0/e/20e90413-712f-438c-988e-fdaa79a8ac3d/dotnetfx35.exe</a>
<br />
<br />Hope this helps, do drop me a comment would love to know.
<br />Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com6tag:blogger.com,1999:blog-4089703635950888934.post-11095973476910305492008-09-08T21:36:00.007+05:302011-08-17T01:15:20.650+05:30TCPView<a onblur="try {parent.deselectBloggerImageGracefully();} catch(e) {}" href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7Lh2GH88xcbEzqN4EdJPRgbprv9_SwjZ7pmDg7y5_mU3BRUuuUysX4v7X05eGea992U4oruzIUDXxb4RBAUk_5O6JWXd3LB4GbVhEhkoOuAeJ8p6OJikXtEe5jQej5xiyqAZ4VUmuoxQ/s1600-h/tcpview.JPG"><img style="display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh7Lh2GH88xcbEzqN4EdJPRgbprv9_SwjZ7pmDg7y5_mU3BRUuuUysX4v7X05eGea992U4oruzIUDXxb4RBAUk_5O6JWXd3LB4GbVhEhkoOuAeJ8p6OJikXtEe5jQej5xiyqAZ4VUmuoxQ/s400/tcpview.JPG" alt="" id="BLOGGER_PHOTO_ID_5243697802314053538" border="0" /></a>
<br />We sometimes need to figure out whats running on our computers that have created connections for the outside world. The needs could be for check if you have any ad ware / trojans. The other reason is when we ourselves want to know if a certain program is running properly or what port it is listening too or figure out which system has connected into your machine.<div>
<br /></div><div>There is this built in program in Dos called netstat but its very very basic and works only in the dos prompt. As always there is a lovely little stand alone program that is part of the sysinternal suite called tcpview. t doesn't need to be installed and has a zero footprint.</div><div>
<br /></div><div>It shows all the application on your PC / Server that have open connection / established conections and the ports that are getting used. It also has a setting whereby you set the refresh time to update the current connections. </div><div>
<br /></div><div>
<br /></div><div>
<br /></div><div>Sysinternals got bought over by Microsoft and now is hosted at microsoft</div><div>
<br /></div><div><a href="http://technet.microsoft.com/hi-in/sysinternals/bb897437%28en-us%29.aspx">http://technet.microsoft.com/hi-in/sysinternals/bb897437(en-us).aspx</a>
<br /></div><div>
<br /></div><div>
<br /></div><div>Hope this has helped you out. Do drop me a line !
<br /></div><div>
<br /></div>Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com0tag:blogger.com,1999:blog-4089703635950888934.post-16367378402812536012008-08-31T15:55:00.006+05:302011-08-17T01:14:57.336+05:30Network Bridge Wired and Wireless Connections not workingIf you have issues in getting to work after trying <skip> to the bottom
<br />
<br />The Basics ....
<br />
<br />The first question to be answered is why would someone want to bridge a wired with a wireless connection. Well the situation in my case was that I have a small network with a router connecting 4 machines. I also have a netgear wireless router serving a couple of laptops elsewhere close by. Now the idea in my mind is that why can't I have internet access for the this small network for basic stuff such as Email, Antivirus etc
<br />
<br />So I get myself a USB wireless card which plugs into the USB port of one of the laptops. Now this allows this computer to be part of the LAN as well as part of the wireless network with the laptops but this does not allow the remaining computers to have access to the internet or to the other computers part of the wireless network.
<br />
<br />Fortunately Windows XP has an solution for the problems and its called a network bridge. It allows you to create a network bridge on the computer that has access to both networks and allows for cross traffic across both. The concept is well documented in many sites and if you want to set it up would recommend a google search for a more detailed explanation with screen shots. I will briefly explain here.
<br />
<br />Assume that the router acts a DHCP Server and is setup to allocate IPs in the range of 196.168.0.x so the systems on that network would have IPs such as 192.168.0.2 / 192.168.0.3 etc The desktop connected through the USB wireless will also have an TCP/IP automatically setup with an IP as 192.168.0.5.
<br />
<br />Do a ipconfig in DOS or properties of the connection and note down the DNS settings of this connection.
<br />
<br />Now the other network (wired) since its a router you have to physically set up the TCP/IPs. On each of the systems setup the IP as 192.168.0.101 / 192.168.0.102 etc with the subnet as 255.255.255.0 and the gateway as 192.168.0.1 Now the system which has the USB connection as well as the lan connection will be having two networks connected with two IPs say 192.168.0.105 and 192.168.0.5
<br />
<br />In the network connections page select the two networks right click and select network bridge. You will be required to enter the details of the bridged network. Use the same setting of the LAN TCP/IP settings for IP , subnet and gateway.
<br />
<br />Additionally now the DNS settings need to be setup since the connection has been manually setup. Use the DNS settings you have captured earlier and plug it in here as well as all the other computers that are part of the wired LAN.
<br />
<br />
<br />
<br />
<br /><stop>
<br />
<br />Ideally doing all the above should work but unfortunately it didn't after lots of search I came across this setting to force a certain mode on the computer
<br />
<br />In DOS type in the following commands
<br />
<br />netsh bridge show adapter
<br />
<br />-------------------------
<br />ID AdapterFriendlyName ForceCompatibilityMode
<br />---------------------------
<br />1 Wireless Local Connection disabled
<br />2 Local Area Connection disabled
<br />---------------------------
<br />
<br />if you get the above output then type the two statements below ...
<br />
<br />netsh bridge set adapter 1 forcecompatmode=enable
<br />netsh bridge set adapter 2 forcecompatmode=enable
<br />
<br />
<br />The "</stop></skip>netsh bridge show adapter" <skip><stop>command nows shows the following
<br />
<br /></stop></skip>-------------------------
<br />ID AdapterFriendlyName ForceCompatibilityMode
<br />---------------------------
<br />1 Wireless Local Connection enabled
<br />2 Local Area Connection enabled
<br />---------------------------
<br /><skip><stop>
<br />
<br />This finally got my bridged network working :)
<br />
<br />If you found this useful, do drop me a line.
<br /></stop></skip>Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com0tag:blogger.com,1999:blog-4089703635950888934.post-79495679795768140142008-08-21T23:59:00.006+05:302011-08-17T01:14:36.286+05:30Member Hierarchy with Multiple Parents / Many to Many Dimensional ModelingOver the course of one of my projects this unique issue posed itself that needed to be solved. I needed to build a reporting analysis tool that allowed me to analyze data across various dimensions such as Time / Geography / Product etc. One of the parameters on which analysis was need was on Type. Now Type unfortunately wasn't a one is to one mapping or a many to one mapping.
<br />
<br />For example a single store could be Hair Focus outlet , it could also be a Skin focus outlet, a Food focus etc. Also possible that the it could just be one of the above.
<br />
<br />Now if we go ahead and build a normal hierarchy with this kind of mapping of outlets to their respective types as defined below it runs into various problems of incorrect totaling.
<br />
<br />Outlet Type
<br />1 Skin Focus
<br />1 Food Focus
<br />2 Skin Focus
<br />2 Hair Focus
<br />3 Hair Focus
<br />..
<br />..
<br />..
<br />
<br />
<br />The problem being if we try and report say sale based on Type it will double count outlets 1 and outlet 2 and the resulting total would be incorrect.
<br />
<br />Another typical example of this based on my reading is when in a bank individual have single accounts as well as joint accounts and the same needs to modeled ensuring that we don't end up double / triple counting the same record while reporting balance or any other parameter.
<br />
<br />I came across this fantastic white paper, that describes this problem and more importantly the solution to the same.
<br />
<br />http://www.sqlbi.eu/Projects/Manytomanydimensionalmodeling/tabid/80/language/en-US/Default.aspx
<br />
<br />The issue is treated as a many to many dimension modeling and has a very straight forward solution using SQL Server 2005 and something known as a factless dimension. More importantly it gives insight into how one may be able to model the same and the fundamental principle could be attempted to be used in other schemas as well.
<br />
<br />The capability solved my problem of allowing me to create a dimension on the type which allows for navigational / selection and ensuring that no double counting takes place at the total levels.
<br />
<br />If you have found this page useful, do drop me a comment.
<br />Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com2tag:blogger.com,1999:blog-4089703635950888934.post-5134195657577557162008-08-20T23:32:00.002+05:302009-12-13T01:27:18.361+05:30Multiple Remote Desktop Connections (RDC) XP not workingIf you have tweaked around with Windows XP you probably know that its possible to connect to another system across a network, intranet / internet as a remote user with the same interface as sitting on the system.<br /><br />The capability is bundled with XP pro and I'm sure that you will find enough and more blogs / tutorial about how it works with screenshots and all. The issue is that its not available in XP Home and in XP Pro it allows only one user to work on the computer.<br /><br />Based on my searches I believe its also possible to hack XP Home to support RDC, though I haven't tried it myself the following link does have all the details that you could possibly need to try this out.<br /><br />http://www.geekport.com/2007/08/15/enabling-remote-desktop-in-xp-home/<br /><br />http://www.mydigitallife.info/2008/06/14/install-and-enable-remote-desktop-in-windows-xp-home-edition/<br /><br />Now to the problem in XP pro , as mentioned earlier , the licencing agreement of MS allows only one user to access the computer so if you RDC to a computer the existing user gets logged out (not desirable). There is a way of overcoming this issue with some registry changes and a changed Terminal Service Dynamic Link Library (termserv.dll).<br /><br />There are detailed article on the procedure available below<br /><br />http://sig9.com/articles/concurrent-remote-desktop<br /><br />http://www.mydigitallife.info/2008/06/13/enable-multiple-concurrent-remote-desktop-connections-or-sessions-in-windows-xp/<br /><br />Additional some good soul has also written a program that neatly makes all these changes and also patches the termserv.dll the link for that is<br /><br />http://www.kood.org/terminal-server-patch/<br /><br />For most of the people in the world doing all this worked just fine and if you have tried and are successful good for you .... but then again there are those who are not so fortunate in life such as me who after trying out each and everything on all the links that I have posted including the application got nothing to work. The main user still got logged out each time I tried to RDC to the system.<br /><br />After more googling I came across this obscure little package called<br />TermSrvNoRestrPatch-1-3<br /><br />The location of the file is as following<br /><br />http://ice-club.com.ua/antiwpa/Other/TermSrvNoRestrPatch-1-3/<br /><br />which was also a real pain to find a valid link for it. It worked like a charm, it step by step patched all the file which the other application also did but this one got it to work ! It also patched the capability to RDC to a local host, yes there are a few reason why someone would want to do something like this :) such as running multiple instances of a single program.<br /><br />A word of caution, since the code edits few of the windows' files, some antivirus programs through it up as a virus. You may need to run this in safemode if your antivirus prevents its from executing and more importantly if your convinced that it isn't a virus.<br /><br />Hope this has helped all the hapless people out there trying to get this to work. As always do drop me a comment if you found this useful, if your feeling generous you could donate a dollar via paypal :)Vikram Sridharanhttp://www.blogger.com/profile/09177813942376516345noreply@blogger.com14