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.
Sql Developer: Access Connection
-
- GoldLounger
- Posts: 2628
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Sql Developer: Access Connection
Regards,
John
John
-
- Administrator
- Posts: 78465
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Sql Developer: Access Connection
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
Hans
-
- GoldLounger
- Posts: 2628
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Re: Sql Developer: Access Connection
Hans,
Thanks for the update. Some may call this progress but then again stepping back once and a while isn't a bad idea.
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
John
-
- GoldLounger
- Posts: 2628
- Joined: 26 Jan 2010, 16:31
- Location: Southern California
Re: Sql Developer: Access Connection
Hans,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).
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
John
-
- Administrator
- Posts: 78465
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Sql Developer: Access Connection
I have no idea. Try asking this in the Oracle forums, perhaps someone there can help you.
Best wishes,
Hans
Hans
-
- Administrator
- Posts: 78465
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Sql Developer: Access Connection
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;
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;Persist Security Info=False;
Best wishes,
Hans
Hans