Solved

JAVA Connection to Access using aveConnect 1.1

Posted on 2009-05-19
6
246 Views
Last Modified: 2013-11-24
Does any Experts have an example or documentation on how to connect to an Access DB using this product [aveConnect 1.1] ? It does not look like its supported any more but i have the JAR file. I know there is another company that has a similar product (I-Connect or something) but it is pretty pricy $$.

Essentially, I would like to connect to an MS Access DB through a Java Application without using ODBC.
Thanks.
0
Comment
Question by:Ben_ocm
  • 3
  • 3
6 Comments
 
LVL 46

Expert Comment

by:tbsgadi
Comment Utility
0
 
LVL 4

Author Comment

by:Ben_ocm
Comment Utility
Gary,
Thanks for the reply. the method they discuss in the above link uses an ODBC connection:
private String url   = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=MyCustomers.mdb";
which needs to be set up on the machine hosting the web server. the product aveConnect 1.1 is a pure Java JDBC that can connect to Access without the need for an ODBC connection. Unless I can find a product that is relatively inexpensive I'll probably need to use ODBC.
0
 
LVL 46

Accepted Solution

by:
tbsgadi earned 500 total points
Comment Utility
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 4

Author Comment

by:Ben_ocm
Comment Utility
I have been to alot of websites and the product (StelsMDB) on this appears to have good potential. I'll download and test and report back. Thanks!
0
 
LVL 4

Author Comment

by:Ben_ocm
Comment Utility
StelsMDB is the way to go it works great, easy to implement and resonable $$.
Good call tbsqadi.
0
 
LVL 46

Expert Comment

by:tbsgadi
Comment Utility
Glad to help!
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now