Solved

JAVA Connection to Access using aveConnect 1.1

Posted on 2009-05-19
6
248 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
ID: 24430715
0
 
LVL 4

Author Comment

by:Ben_ocm
ID: 24431628
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
ID: 24431785
0
Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

 
LVL 4

Author Comment

by:Ben_ocm
ID: 24431902
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
ID: 24434237
StelsMDB is the way to go it works great, easy to implement and resonable $$.
Good call tbsqadi.
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24435160
Glad to help!
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
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…
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.

785 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