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.
Essentially, I would like to connect to an MS Access DB through a Java Application without using ODBC.
Thanks.
ASKER
Gary,
Thanks for the reply. the method they discuss in the above link uses an ODBC connection:
private String url = "jdbc:odbc:Driver={Microso ft Access Driver (*.mdb)};DBQ=MyCustomers.m db";
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.
Thanks for the reply. the method they discuss in the above link uses an ODBC connection:
private String url = "jdbc:odbc:Driver={Microso
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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!
ASKER
StelsMDB is the way to go it works great, easy to implement and resonable $$.
Good call tbsqadi.
Good call tbsqadi.
Glad to help!
http://wiki.netbeans.org/ConnectingToMsAccessDB#section-ConnectingToMsAccessDB-ConnectingToMicrosoftAccessDatabase
Gary