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