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.

1 comment:

  1. A lots of Thanks! That's the problem.

    ReplyDelete