SQL Developer

There's no ODBC Bridge in Java 8 - so there will be no support for Access connections in v4.1

Well, that's sad. So I have to decide either to keep an older version of SQL*Developer to use with Access or to use Access's own version of sql worksheet, which is kind of pain.

Anyway, thank you for your response.

Yeah, your best best from our side will be to use SQL Developer 4.0 and Java 7 - OR - migrate those Access 'databases' to Oracle and then you don't have to worry about it anymore.

Hi Jeff,

can you be more specific about your statement "migrate those Access 'databases' to Oracle"? What options does Oracle provide when not using SQL developer?

I tried out the "copy to Oracle" feature in SQL developer and it works quite nice. Since connecting to an Access database doesn't work with JDK 8, will this feature be desupported in the future?

Yes, use an older version of SQL Developer that does support Access connectivity,to migrate it to Oracle.

Oh this is sweet. I am beating my head against the wall learning how to migrate an access db to apex. Upgraded from sqldeveloper 115 to 211 per the migration documentation, found no Access connection tab, and was told in these forums that 211's a pretty old version. So here I am on v 403 and getting an odbc error ["Specified driver could not be loaded due to system error 126: The specified module could not be found. (Microsoft Access Driver(*.mdb), C:\WINDOWS\system32\odbcjt32.dll)."]  -- only to find that access connectivity will be deprecated in the new sqldeveloper. I think I will just tell my employer that access migration to oracle/apex is no longer supported and we might as well look for another tool.

Do you have a better solution, Jeff?

It should work just find on v4.0.3 with Java 7. Your error doesn't have anything to do with the Java 8 deprecated ODBC Bridge.

SQLDev is telling you we can't find that driver/DLL. Go fix that, and make your boss happy.

I am nearly clueless when it comes to java/jre/jdk. My win7-64 system has:

C:\Program Files\Java\jdk1.8.0_25

C:\Program Files\Java\jre1.8.0_25

C:\Program Files (x86)\Java\j2re1.4.2_12

C:\Program Files (x86)\Java\jre6

https://www.java.com/en/download/installed8.jsp tells me Version 6 Update 31

At a C:\ windows prompt, java -version responds with:

java version "1.8.0_25"

Java(TM) SE Runtime Environment (build 1.8.0_25-b18)

Java HotSpot(TM) 64-Bit Server VM (build 25.25-b02, mixed mode)

The sqldeveloper 4 I downloaded was the 311M version that includes the v7 jdk, but where/how to use that? 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(?). There is no AppData folder in my profile, so I'm not sure where I would point sqldeveloper to another jdk.

Thanks for your help.

AppData is one of those hidden Windows folders that must be explicitly exposed.

See Explorer's  Organize > Folder and search Options > View tab > Advanced settings > Hidden files and folders > Show hidden...

Good luck!

Thanks! Just discovered that in a dialog inside sqldeveloper.