These CRUD operations are equivalent to the INSERT, SELECT, UPDATE and DELETE statements in SQL language. So, I would use jDBC but introduce a bridge, and that bridge can even be web based, or just a service running on your network.This JDBC tutorial is going to help you learning how to do basic database operations (CRUD - Create, Retrieve, Update and Delete) using JDBC (Java Database Connectivity) API. And any ODBC driver thus can be used - that means FoxPro, Access, heck there are even drivers for Excel and text files. Jdbc driver (but you need the windows ODBC one - but that's as common as water. You not limited by the client side jdbc driver at all anymore. So, server (service) running on your network means that ANY odbc driver that windows support can be used. To the BRIDGE and not actually the target server. The client side connection thus can work with 'any' ODBC connection, since the client part is a jdbc driver So, at the end of the day? You can still go with some JDBC drivers - you just have to also adopt and run a 'bridge' on a server.

(and that service can even run as a web service). With a bridge, your java side (client side) driver is 100% neutral. Now, with dropping of the Oracle drivers, then you not find or get your hands 'easy' on a direct connect. To SQL server from the software I writing for android. I am currently using the JTS driver to SQL server. While the official Java SDK somewhere around 8? Dropped the support for using a JDBC bridge? There are a number of 3rd party companies still offering them, or making them.

There are a number of libraries that support this. However, as noted, you really going to have to use some kind of bridge. Var strQuery = 'select HotelName from tblHotels ' Var strMdbFile= 'c:\test\test44.accdb' So, from jscipt, this works: var dbeng = new ActiveXObject('DAO.DBEngine.120') I suppose it depends on what host you using to run the scripts.

The windows jscript host supports this, but a Java soliuon does not.

Java 8 jdbc odbc bridge alternative