The latest SQL Developer 4.1 requires Java JDK 1.8 which no longer includes the ODBC bridge. Using 4.0.3 with Java JDK 1.7 should work if you use a 32-bit version of the JDK to match your Access install. You can read through a prior discussion for some additional information: 4.1 EA1 - Connections to Access-DB
I do have Sql Developer 4.0 and jdk 1.7, but I cannot create a connection based on MS access.
I read the discussion (thank you for the link), but didn't get exactly what to do. I updated my SQL Developer.conf file, but the problem persists.
Do I need to configure something else?
/* updates on config file */
/* added jdk 32bits */
C:\Program Files (x86)\Java\jdk1.7.0_79\bin
/* error */
Error "[Microsoft] [ODBC Driver Manager] data source name not found and no default driver specified".
i think it requires you have Office installed so that you have the drivers
I do have access installed, but 32bit. With Sql Developer 64bit. That seams to be the issue
SetJavaHome C:\Program Files (x86)\Java\jdk1.7.0_79
(32bit jdk driver)
Glad you found out how. The link I provided in my prior post did not give explicit instructions on how to SetJavaHome for the 4.0.3, it only gives this hint...
And I read your blog where you say that v4.0 saves a config file in the roaming profile, but the example seems to be 32-bit system(?)
I misinterpreted "sql developer config file" as sqldevelper.conf.
It was my mistake, just later realized ()remembered) that the jdk configuration was in that user folder