Link to home
Start Free TrialLog in
Avatar of Ben_ocm
Ben_ocm

asked on

JAVA Connection to Access using aveConnect 1.1

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.
Avatar of tbsgadi
tbsgadi
Flag of Israel image

Avatar of Ben_ocm
Ben_ocm

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of tbsgadi
tbsgadi
Flag of Israel image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ben_ocm

ASKER

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!
Avatar of Ben_ocm

ASKER

StelsMDB is the way to go it works great, easy to implement and resonable $$.
Good call tbsqadi.
Glad to help!