HOW TO: connect to Microsoft Access using JDBC

Find out how to get things done with Servoy. Post how YOU get things done with Servoy

HOW TO: connect to Microsoft Access using JDBC

Postby Jan Aleman » Thu May 20, 2010 12:46 pm

1. Download the hxtt JDBC driver here http://www.hxtt.com/access.html
2. Extract the ZIP file, inside it in the lib directory you will find Access_JDBC30.jar copy that file into the drivers directory inside your application_server directory of your Servoy folder
3. (Re)-start Servoy developer
4. Right Click on Database Servers, choose New --> Empty and fill in the following:
Server Name: whatever you wish to name the connection
URL: jdbc:access://PATHTOMDBFILE
Driver: com.hxtt.sql.access.AccessDriver

Thats it. Save and you are ready to use it.
Some URL examples:

"jdbc:access:/."
"jdbc:access:/c:/data" for Windows driver
"jdbc:access:///c:/data" for Windows driver
"jdbc:access:////usr/data" for unix or linux
"jdbc:access://///192.168.10.2/sharedir" for UNC path
"jdbc:access:/./data"
"jdbc:access:/./data/mydata.mdb"
Screen shot 2010-05-20 at 12.45.37 PM.png
Screen shot 2010-05-20 at 12.45.37 PM.png (48.51 KiB) Viewed 9370 times
Jan Aleman
Servoy
Jan Aleman
 
Posts: 2083
Joined: Wed Apr 23, 2003 9:49 pm
Location: Planet Earth

Re: HOW TO: connect to Microsoft Access using JDBC

Postby Siem » Fri May 21, 2010 2:33 pm

UP and RUNNING !

Thanks Jan! Now I'm browsing through my linked Access tables, field and query's with Servoy on one computer while in my old MS Access environment on the other.

Now I can start playing around with rebuilding some forms.

Best regards,
Siem

PS the trial of this HXTT driver is free, but limited to 50 records. You need to buy this driver for at least US$ 361,-- (Single Server License: unlimited connections, for a single server)
Siem
 
Posts: 5
Joined: Sat May 15, 2010 4:33 pm

Re: HOW TO: connect to Microsoft Access using JDBC

Postby mwiedemann » Wed Aug 05, 2015 7:08 pm

I have a user that insists on using an Access database as part of a larger solution. So, I have installed the hxtt Access driver and followed the instructions as laid out by Jan but am getting an error when I attempt to save my database connection.

Any ideas??

Thanks much!
Martin

Picture.png
Picture.png (26.92 KiB) Viewed 8163 times
mwiedemann
 
Posts: 13
Joined: Wed Aug 05, 2015 7:05 pm

Re: HOW TO: connect to Microsoft Access using JDBC

Postby mwiedemann » Fri Aug 07, 2015 6:10 pm

Bump....
mwiedemann
 
Posts: 13
Joined: Wed Aug 05, 2015 7:05 pm

Re: HOW TO: connect to Microsoft Access using JDBC

Postby Jan Aleman » Fri Aug 14, 2015 12:37 pm

what's the detailed error?
Jan Aleman
Servoy
Jan Aleman
 
Posts: 2083
Joined: Wed Apr 23, 2003 9:49 pm
Location: Planet Earth


Return to How To

Who is online

Users browsing this forum: No registered users and 5 guests