Friday, March 21, 2014

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

This was driving me nuts today -- trying to get Oracle SQL Developer 4 and/or a simple java code (in the style of http://stackoverflow.com/a/16626825/524504 ) to "connect" to a local Microsoft Access Database .mdb file. But I kept getting the not-very-helpful message

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

luckily, I have been able to sort out this problem with the help of

http://www.selikoff.net/2011/07/26/connecting-to-ms-access-file-via-jdbc-in-64-bit-java/

http://www.microsoft.com/en-us/download/details.aspx?id=13255

and

http://stackoverflow.com/questions/7116019/hand-install-of-64-bit-ms-access-odbc-drivers-when-32-bit-office-is-present

I have 32 bit office installed, so I didn't have the 64 bit Access Database odbc driver.
I love it when the biggest troubles in programming something are things like that.

I will change this.

Friday, March 14, 2014

Saving files is outdated

Some time ago, when disks where really slow or files where even stored on external, even slower devices (cassettes, floppy disks) it may have made sense to specify when exactly to save a file because you had to wait a considerable amount of time. However with modern harddrives and usb sticks and whatnot, this concern is out of the way. I hate it when I have to save files manually in any program, especially in text editors. First thing I do is look for an autosave plugin.

However, programs should allow as many levels of undo as possible and keep the history even after restarting a session.

vim can do this

http://stackoverflow.com/questions/6426956/can-i-get-a-versioned-recovery-from-a-vim-swap-file