Topics Search

JDBC-ODBC - Running Queries on MS Access Database

JDBC-ODBC - Running Queries on MS Access Database
Views: 142
This section describes how to run queries on MS Access database through the JDBC-ODBC driver.
Sponsored Links:

Similar posts...

 

MS Access JDBC Driver -- Connecting MS Access with Java

MS Access JDBC Driver -- Connecting MS Access with Java Icon
To connect Java with MS Access, you need a JDBC driver. Although Microsoft do not produce a JDBC driver for MS Access, you can use the Easysoft JDBC-ODBC Bridge as a MS Access JDBC driver. Use the JDBC-ODBC Bridge to provide the connectivity layer between your Java code and MS Access database. The MS Access database can be on the same machine as your Java or a remote machine.
 

JDBC-ODBC - Creating New Tables in MS Access Database

JDBC-ODBC - Creating New Tables in MS Access Database Icon
This section describes how to create a new table in a MS Access database through the JDBC-ODBC driver.
 

JDBC-ODBC Bridge Driver

JDBC-ODBC Bridge Driver Icon
This chapter provides tutorial notes on using the JDBC-ODBC Bridge driver with MS Access database. Topics include creating MS Access database file; creating DSN for MS Access database files; inserting rows to and retrieving rows from Access database.
 

Needed - JDBC Derby or ODBC-JDBC bridge

Needed - JDBC Derby or ODBC-JDBC bridge Icon
I would like to use Access (2003) as a front end for a Java DB I am working on in a separate java project. These speed and ease of using Access would be a godsend.

I would be extremely grateful if anyone could point me in the right direction.

So far I found one commercial ODBC-JDBC bridge that failed to run on 64 bit Win 7. Other interfaces I tried either didn't work, were just hard to set up, or didn't provide the functionality you get with Access.

Hopefully I am overlooking something easy.

Any tips, clues, or links to a driver or method to get Access connected to a jdbc DB would be extremely appreciated
 

On Using Pass-through Queries

On Using Pass-through Queries Icon
You might want to send a SQL specific query in Microsoft Access directly to the underlying ODBC database server to improve performance. You may do this by using a pass-through query. Running such queries is the topic of this tutorial. TOC: On Using Pass-through Queries in MS Access; Providing the ODBC Connectivity information; Creating a Query; Saving Connection information with the query.
 

UNION QUERY to MYSQL Fails

UNION QUERY to MYSQL Fails Icon
I have an Access 2003 database linked via ODBC using MYSQL ODBC version 5.1 It works very well apart from UNION queries with more than 1 UNION

If I run a query with 2 UNIONS then I get an Error

ODBC – call failed. (Error 3146)
....

Looks like an issue with the MYSQL ODBC Adapter.

IF I write it as a PASS THROUGH query running on the server with the same adapter DSN, then it is fine.

Anyone any ideas of whether it is possible to get round this issue IN ACCESS without resorting to temporary tables OR PASS Through query.
 

ODBC -- call failed. | Oracle ODBC

ODBC -- call failed. | Oracle ODBC Icon
I have an Access 2003 Database that resides on a virtual windows 2003 server that is giving me an error when I attempt to create a linked table or update any linked table that is using an odbc file dsn. The database being connected to is Oracle.

Here's the full error.

Now the weird thing is, the error is only occurring on a virtual machine while on my local development box, it works fine.

Both environments are using identical tnsfilename.ora files.

The failing server is running Windows Server 2003 with MS ODBC for Oracle v2.576.3959.000.
The dev box is running WinXP Pro with MS ODBC for Oracle v
 

Access Database Manipulation via JDBC

Access Database Manipulation via JDBC Icon
This will teach you how to connect to a Microsoft Access database. It's also a great overview of JDBC. Once you are connected, you may run any SQL statement that is allowable on Access, such as SELECT, etc. You don't even have to have MS Access installed to run this tutorial - it shows you how to make a blank one without Access!
 

Pass-through Queries in Access 2003/XP/2000/97

Pass-through Queries in Access 2003/XP/2000/97 Icon
A Pass-through query allows you to execute an SQL statement directly against the tables in an external database (such as an Oracle, Sybase, or SQL Server database). This method uses your ODBC connection to directly access the data in the external database without having to link to the tables or import the data from the external database.
This tutorial will demonstrate how to create pass-through queries as well as how to integrate pass-through queries with other queries in your Access database.
 

bypass odbc connection

bypass odbc connection Icon
I have a MS Access 2007 database that contains a union query that merges 5 different odbc connections. If one connection is down I receive an 'ODBC--call failed' error and the query is unusable.

Is there a way to have the database verify connection and if it cannot connect to one or more odbc, to simply by-pass the odbc(s) and use the others?