problem in registering JDBC connection for MS ACCESS

Thu, 11/17/2011 - 06:01
Presto Version: Presto 3.0
gomashan07
User offline. Last seen 9 weeks 4 days ago. Offline
Joined: 01/27/2011
Points: 251

Hi, 

            I went to  the configurations and opened the JDBC configuration option. I  tried to add a new JDBC driver . My intent is to add JDBC driver for MS Access, so i entered the class name as     " sun.jdbc.odbc.JdbcOdbcDriver  " and in the location of the jar file i  pointed to the rt.jar file present in the JRE in my system. when i click add the add button disappears , uploading starts and it never ends. Hence i am  not able to add the JDBC driver . Please help me . 

0
Your rating: None
Thu, 11/17/2011 - 14:36
Copy comment link
smitchell
smitchell's picture
User offline. Last seen 2 weeks 5 days ago. Offline
Joined: 08/29/2008
Points: 34

A couple of points:

* You're trying to upload the JRE jar itself which Presto cannot do as these classes are already in the classpath. So you need to find a third-party source for your driver.

* Presto doesn't support MS Access as a datasource, although we have had some users who were successfull with a JDBC/ODBC bridge. Given your class, it looks like you already know this.

Sara, technical writer/jackbe