Sql Developer: Access Connection

jstevens
GoldLounger
Posts: 2617
Joined: 26 Jan 2010, 16:31
Location: Southern California

Sql Developer: Access Connection

Post by jstevens »

I recently upgraded to Oracle SQL Developer version 18 from 4.0. In reviewing the JDBC connections I do not see an Access tab as in the older version. I added the older JDBC connection and still do not see the Access tab.

Your suggestions are appreciated.
Regards,
John

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Sql Developer: Access Connection

Post by HansV »

Starting with version 4.1, the JDBC-ODBC Bridge is no longer available, and as a consequence, it is not possible to connect to Access. You'll have to use version 4.0 (you can install multiple versions side by side).
Best wishes,
Hans

jstevens
GoldLounger
Posts: 2617
Joined: 26 Jan 2010, 16:31
Location: Southern California

Re: Sql Developer: Access Connection

Post by jstevens »

Hans,

Thanks for the update. Some may call this progress but then again stepping back once and a while isn't a bad idea.
Regards,
John

jstevens
GoldLounger
Posts: 2617
Joined: 26 Jan 2010, 16:31
Location: Southern California

Re: Sql Developer: Access Connection

Post by jstevens »

HansV wrote:Starting with version 4.1, the JDBC-ODBC Bridge is no longer available, and as a consequence, it is not possible to connect to Access. You'll have to use version 4.0 (you can install multiple versions side by side).
Hans,

Version 4.0 utilizes a connection to an Access MDB file. How would one account for an Access ACCDB file? I receive an error message regarding the default driver with version 4.0.

The odd thing is that I can get it to work in version 3.
Regards,
John

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Sql Developer: Access Connection

Post by HansV »

I have no idea. Try asking this in the Oracle forums, perhaps someone there can help you.
Best wishes,
Hans

User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Sql Developer: Access Connection

Post by HansV »

Perhaps you need to use an ACE.OLEDB connection string, something like

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;Persist Security Info=False;
Best wishes,
Hans