Relevant up-front details:
Windows 7 64 bit desktop
SQL Developer 3.2.2 64 bit
SQL Developer 3.0 32 bit
MS Access Data Source
Problem Description:
Every time I attempt to set up a connection within SQL Developer to MS Access, I get the “Re: [ODBC Driver Manager] Data source name not found and no default driver” message.
I have created a System DSN with the same name as the Connection Name I am using within SQL Developer.
Currently Microsoft does not provide a 64bit MS Access ODBC driver, there is however a 32 bit ODBC driver. I did some research within MOS and found a related article. The solution in the article is to install the 32 bit version of SQL Developer and use it instead of the SQL Developer provided within the Oracle 12c distribution.
I did just that. I installed a 32 bit version of SQL Developer and tried the connection with no luck. I received the same exact error.
It looks like the driver is registered within Microsoft Windows and I can locate the associated *.dll file within the C:Windows\System32 directory.
Just as an aside, this is a new windows 7 configured box. This connection has never worked on this desktop. I was using a WndowsXP configuration prior to this and I never had any issue connecting to MS Access through SQL Developer. I would simply create the System DSN with the same name as the connection, enter the *.mdb or *.accdb file with its complete path, and SQL developer would connect every time without any issues.