Friday, August 19, 2005

Blogger for Word

Posting a blog entry has gotten even easier.  Now you could post an entry just from your Microsoft Word.  Download this Word add-in and start to blog from your word http://buzz.blogger.com/bloggerforword.html

Tuesday, August 16, 2005

Video on your iPod?

I was awaiting for the new 5G iPod series to arrive but just figured out that I don't need one. Just visit cnet.com setp-by-step instructions for video on iPod setup http://reviews.cnet.com/4520-10163_7-6279061-1.html?tag=bnav, its pretty cool.

Thursday, August 04, 2005

Accessing CSV file as a Database using ODBC-JDBC

Microsoft provides a ODBC driver for CSV/TXT files so that they can be accessed/manipulated from applications using ODBC. The same can be accessed in the Java world using the JDBC type 1 driver, which essentially is a JDBC-ODBC Bridge. There is a detailed tutorial here:

http://www.devarticles.com/c/a/Java/Using-CSV-Files-as-Databases-and-Interacting-with-Them-Using-Java/

However there is a bug with Microsoft ODBC Text Setup utility. The Text driver creates a file called System.ini which stores the column names with the corresponding datatype and length, header details etc. But the utility (atleast the one provided with Windows XP) doesnt write the datatype and length to the file. This however can be manually changed and System.ini is usually present in the directory in which you specify the CSV file.

For the example in the tutorial the change for System.ini will be:

[statebirds.txt]
ColNameHeader=True
Format=CSVDelimited
MaxScanRows=1
CharacterSet=OEM
Col1=STATE Text Width 255
Col2=STATEBIRD Text Width 255

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcjetschema_ini_file.asp

Wednesday, August 03, 2005

Yahoo Mail doesnt work with IE 7.0 beta 1

If you install IE 7.0 Beta and try opening Y! Mail it would complain please upgrade to IE 6.0!

Tuesday, August 02, 2005

Yahoo releases Shopping Web Services

Yahoo released Shopping Web Services API thus enabling users to build applications easily. The API provides access to productSearch, catalogLisiting and merchantSearch services. The services are very primitive while comparing to eBay's API.

Disqus for techtalk