Solved

JAVA Connection to Access using aveConnect 1.1

Posted on 2009-05-19
6
247 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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
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 …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

863 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

22 Experts available now in Live!

Get 1:1 Help Now