Sunday, June 21, 2009

Motorola RAZR V3 - Charge via USB on PC

There 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.

These drivers can be downloaded here ...

http://ofg.osnn.net/razr/


The detailed article for the same can be found here

http://www.somelifeblog.com/2007/02/motorla-razr-v3-charge-via-usb-on-pc.html

Tuesday, May 12, 2009

IBM OLE DB provider for DB2 sql server 2008 / DB2 Administration Client Windows Server 2008

While 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.


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.

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

http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21288113

The direct file

ftp://ftp.software.ibm.com/ps/products/db2/fixes2/english-us/db2winX64v95/fixpack/FP3b_WR21447/v9.5fp3b_ntx64_client.exe


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

http://www-01.ibm.com/support/docview.wss?rs=71&uid=swg21256105


The direct file

ftp://ftp.software.ibm.com/ps/products/db2/fixes2/english-us/db2winAMD64v8/fixpak/FP17a_WR21442/FP17a_WR21442_ADMCL.exe


Please note that there are different versions for different architectures x32 / x64 / IA64. Download the right file for yourself.

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

http://www.microsoft.com/downloads/details.aspx?FamilyId=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en


Do let me know if this has been helpful. Cheers !

Thursday, April 9, 2009

Google Chrome not working / Google Chrome stopped working

I 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.

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.


The solution is to go to the following path in your command prompt

C:\Documents and Settings\(user name)\Local Settings\Application Data\Google\Chrome\Application\(version number)\Installer

Run the following statement

setup.exe --rename-chrome-exe


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

http://www.google.com/support/forum/p/Chrome/thread?tid=2680b41d121dc73a&hl=en


Do let me know if this has helped you, if your feeling generous you could donate a dollar via paypal :)

Saturday, March 28, 2009

Airtel blocking Websites partially

I 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.

Mail on the POP3 would download but SMTP mail send would fail occasionally by timing out.

Wondering why my ISP was preventing this from happening. The Airtel Beetel Modem is connected to a Netgear Router for wireless access.

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.

http://www.dslreports.com/faq/695


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.

In order to change this setting, log into your wireless router and navigate to the WAN setup link. Make the change and click apply.


Do let me know if this has been helpful by dropping me a comment.

Monday, January 12, 2009

Blog Language Translation

Reading 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.

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.

I finally managed to find the translation engine provided by google itself as a widget. Go to the translate.google.com site

Select the tools tab and you will get the code for added to your widget in your site.

The code is as follows

<$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>

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 :)


Additionally there was this good resource I found with additional information about language translation I found over here

http://labnol.blogspot.com/2005/11/add-language-translation-to-website.html

Hope you found this useful. Do drop me a line would love to hear from you.

Tuesday, December 30, 2008

Automailer Batch Script using Blat

Quite 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.


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.

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.

Its available here

www.blat.net

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

For this example the file is called customer.txt and the contents are in the following format

1234
abc@abc.com,def@def.com
5678
abc@abc.com,def@def.com,xyz@xyz.com

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.

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.

The usage is blat -savesettings

The normal usage is shown below and can be brought up by blat/?


The script is below


:start
echo off

rem This allows for the variable to work within a for loop
SETLOCAL ENABLEDELAYEDEXPANSION

rem This resets the variables used
set a=1
set rs=none

rem This is the loop that goes through for each file in the current folder and sets the
rem every line of the customer.txt to variable i
rem The variables a and b are used to alternate between the customer code and addresses
rem The rs variable is used to store the customer code on every alternative line of the txt file

for /f "tokens=*" %%i in (customer.txt) do (

if "!a!"=="1" set rs=%%i
if "!a!"=="1" set b=2
if "!a!"=="2" if exist *!rs!*.txt blat -t %%i -body "Order details" -s "Order report - !rs!" -attach *!rs!*.txt
if "!a!"=="2" if exist *!rs!*.txt move *!rs!*.txt !rs!
if "!a!"=="2" set b=1
if "!a!"=="2" set a=1
if "!b!"=="2" set a=2)
echo on

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.

Friday, November 14, 2008

Excel 2007 Macro Security Problem

I 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.

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.


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.

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

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Security]
"ExcelBypassEncryptedMacroScan"=dword:00000001


Post the registry correction you have the option to enable this content as shown in the image below.



The helpful resource that helped me solve this problem was

http://www.rondebruin.nl/password2007.htm


Another useful site that I have come across to help users move into Excel 2007 is

http://office.microsoft.com/assistance/asstvid.aspx?assetid=XT101493291033&vwidth=1044&vheight=788&type=flash&CTT=11&Origin=HA101491511033


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.