Access Jdbc Driver For Mac

  1. List Of Jdbc Drivers
  2. Access Jdbc Driver For Mac Matlab
  3. Ms Access Jdbc Driver Download
  4. Ms Access Jdbc Driver
Active1 year, 2 months ago

I want connect my MS access file with Java GUI program,but I have problem with connection....

MySQL JDBC for macOS. This tutorial shows how to set up a data source and connect to a MySQL ® database using the Database Explorer app or the command line. This tutorial uses the MySQL Connector/J 5.1.46 driver to connect to a MySQL Version 5.5.16 database. The easiest way to connect to MS SQL Server from Mac is with a JDBC (Java Database Connectivity) driver. There are two options for JDBC driver. Once is the open source jTDS driver. Is there a free easy to implement Access driver for mac's. If not is there another database format that drivers are standard for which uses the single file format that ms access uses. I answered a similar question enter link description here a while back. Basically at that time: You could connect to Ms-Access from 32 bit java through the JDBC-ODBC bridge; You could not connect to a 32 bit Odbc driver through the JDBC-ODBC from 64 bit java. It is an open source Java JDBC Driver implementation which allows Java developers and jdbc client programs (e.g., DBeaver, NetBeans, SQLeo, Open Office Base, Libre Office Base, Squirrell) to read/write Microsoft Access database.

I have Windows 7 64b, and ms office 2007.When I opened the ODBC driver manager in the control panel I havent found any driver for Microsoft Access (maybe when I started the ODBC is started running the 64bit ODBC, now I think is running the 32bit ODBC. I read this and I make it : 'jdbc-odbc connection for window 7 64 bit machine.. 1 . Right click Data source (ODBC)..go to properties change the folloing thing

target [ %SystemRoot%SysWOW64odbcad32.exe ] start in : [ %SystemRoot%System32 ]

press enter and continue as admin source: source link' ) Now when I start in conctrol pannel the ODBC I can see the driver screenshoot

My program code(I tried two ways but I have same error):

error

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

rjdkolb
5,5207 gold badges51 silver badges66 bronze badges
artinyartiny

9 Answers

Use UCanAccess JDBC Driver :

So for your example it will be Connection conn=DriverManager.getConnection('jdbc:ucanaccess://'+path)

Anthony O.Anthony O.
10.6k8 gold badges69 silver badges123 bronze badges

If you are using Windows 64-bit you probably need to go to this path

C:/Windows/SysWOW64/odbcad32.exe

Then I noticed that you are using the direct path instead creating new System DSN, your direct path is correct till the path to the access file you must give the full path like this :

jdbc:odbc:Driver= Microsoft Access Driver (*.mdb, *.accdb);DBQ=path/to/Invertory.mdb'

To get the path you probably need to use java.io.File that have a method returns the abslute path to the file see the example :

AzadAzad

I answered a similar question enter link description here a while back.

Basically at that time:

  1. You could connect to Ms-Access from 32 bit java through the JDBC-ODBC bridge
  2. You could not connect to a 32 bit Odbc driver through the JDBC-ODBC from 64 bit java. There was a message telling you that you can only connect from a 32 bit programs
  3. While Microsoft does provide a 64 bit Ms-Access driver, it did not work with Java's 64 bit JDBC-ODBC driver.

Since then there seems to be a new open-source Ms-Access JDBC Driver Ms-Access JDBC driver. I have no Idea how good it is.

Community
Bruce MartinBruce Martin
8,6071 gold badge18 silver badges32 bronze badges

You just missing something in your code right here :

You need to add {} between Driver= and )=; . Like this Below

Jorn
12.1k9 gold badges61 silver badges93 bronze badges
KaJasBKaJasB
AccessKarthikeyan Vaithilingam
4,9457 gold badges33 silver badges52 bronze badges
Avijit DasAvijit Das

The problem is that you should run on Java 32 bit try to install latest JDK and it will work

I run it using JDK version 'jdk-7u67-windows-i586.exe'

Ahmed SalemAhmed Salem

On a 64 bit system, you should:

  1. run as admin accessdatabaseengine_64.exe
  2. run java - 7-64 bit - jre.
thesecretmaster
1,5131 gold badge21 silver badges34 bronze badges
jrjayswaljrjayswal

if you are working in NETBEANS then after unzipping ucanacess.zip file add all jar file in the classpath using property window of project click on compile tab and add jar file then compile and test app.

Manoj PandeyManoj Pandey

JDBC-ODBC MS-ACCESS CONNECTION STOPPED WORKING IN JDK8. I solved the issue by installing JDK7 along with JDK8 in the same PC, once installed JDK7 I assigned it as the JDK version to use in my project as follows in Netbeans:

1.RIGHT CLICK THE PROJECT IN THE LIST > CLICK PROPERTIES

2.CLICK LIBRARIES ON THE LEFT NAVIGATION TREE

3.CLICK BUTTON MANAGE PLATFORMS > CLICK BUTTON ADD PLATFORM...

4.FOLLOW WIZARD, DESPITE IT SHOWS JAVA STANDARD EDITION CLICK NEXT

5.NAVIGATE TO C:Program Files (x86)Java AND SELECT THE FOLDER OF JDK7 > CLICK NEXT

List Of Jdbc Drivers

6.THE FIELD AUTOFILL WITH THE RIGHT INFO... > THEN CLICK FINISH

7.SELECT THE JDK PLATFORM FROM THE LIST > CLICK CLOSE > OK

Access Jdbc Driver For Mac Matlab

8.JDK7 SHOULD SHOW IN LIBRARIES PACKAGE.

JDK7 in Libraries PackageClick Back in Browser to return here after looking at the image...

From here on everything must run smoothly.

Hope it solves your problem.

Thanks.

marc_s
603k137 gold badges1155 silver badges1290 bronze badges
J. SilvermannJ. Silvermann

Not the answer you're looking for? Browse other questions tagged javaodbc or ask your own question.

Ms Access Jdbc Driver Download

Active4 years, 4 months ago

My Java application uses a .mdb database and i want to run this application on MAC OS for that am definitely gonna nead a TYPE 4 JDBC driver i have google and came across two - HXTT & StelsMDB but both are out of my reach

So if any body has some alternative or suggestions please reply.

Thanks in advance

skaffman
352k90 gold badges746 silver badges733 bronze badges
JinithJinith
5476 gold badges10 silver badges26 bronze badges

5 Answers

MS Access databases on MS Windows are driven by the Microsoft Jet Engine. Different from client server database management systems like MS SQL Server or MySQL the connection to a MS Access database runs in embedded mode via OLE and some DLLs.

As far as I know there is no Jet Engine implementation for operating systems other than MS Windows. So if you want to connect to a MDB file on Mac OS a simple JDBC driver is not enough. There has to be some kind of emulation layer to emulate the Jet Engine DLLs. According to the HXTT website this is exactly the way the HXTT JDBC driver works.

From the HXTT website:

It contains a fast database engine written in Java, which supports embedded and server modes.

If the usage of the MS Access database format is an absolute requirement, then these kind of emulation might be the best way for you. But you have to testify if the compatibility level is high enough. (Maybe there is no way to access VBA macros contained in the MDB file.)

It seems there is no open source project doing the same kind of emulation like HXTT.

Jdbc

There are several alternatives. If you want an embedded database system then you can use for example

  • SQLite (this JDBC driver supports Mac Os) (one database file, requires some native libraries),
  • H2 (only a few database files, pure Java) or
  • Apache Derby (many database files, pure Java).

Or you can use a client server database management system, install the server on a host and connect to that host from your Mac OS machine. For that you can use for example

Even the pure Java databases H2 and Derby have client server modes.

vanjevanje
8,5392 gold badges26 silver badges39 bronze badges

I've used jackcess to read the tables from an MDB and convert the database to sqlite3. Not ideal if you need to keep the .mdb format, but it allowed me to keep the database in a single file and made the database cross-platform.

jtahlborn
48.3k5 gold badges63 silver badges100 bronze badges
Jeff KnechtJeff Knecht
2,3671 gold badge12 silver badges11 bronze badges

I suppose UCanAccess is what you are looking for.

It is an open source Java JDBC Driver implementation which allows Java developers and jdbc client programs (e.g., DBeaver, NetBeans, SQLeo, Open Office Base, Libre Office Base, Squirrell) to read/write Microsoft Access database. Because it is a pure java implementation it run in both Windows and non-Windows Operative Systems (e.g., linux/unix). No ODBC needed.

lu_kolu_ko
2,7121 gold badge18 silver badges27 bronze badges

StelsMDB is not as expensive as HXTT, still not open source...

Have'n tried it, but evaluation copy is available.

Anyone else got suggestions? I'm looking for an opensource variant myself. Shouldn't be impossible to build on top of jaccess ...

Jon Martin SolaasJon Martin Solaas

Ms Access Jdbc Driver

6721 gold badge8 silver badges19 bronze badges

We use stelsMDB JDBC driver at our server to read/write MDB files. It is platform-independent, so you can use it in MacOS as well.

serg kunzserg kunz

Not the answer you're looking for? Browse other questions tagged javams-accessjdbc or ask your own question.

Comments are closed.