Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

new JDBC Driver for MSAccess

 
A George
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
could anyone please tell from where can I download new JDBC driver that support concurrency and many other advance features
such as scrolling resultset.
what are the steps (ie setting of path and classpath)to be followed for its installation and execution with
Java platform - Java 2 StdEdition v 1.2.1
web server - tomcat
Database -MSAccess
OS -WIN98 and WIN NT
I would appreciate your help
Thanks
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
isn't this a contradiction?
"support concurrency and many other advance features" &
"MSAccess"
if you are limited to MSAccess and you want a free driver, I only know of the jdbc dbc bridge packaged with your jdk. This is only as advanced as the underlying odbc installed on the users PC. In fact it is very limited, and basic as opposed to advanced(more info on jdbc dbc here http://java.sun.com/products/jdbc/faq.html ). If your willing to fork out some cash, then you have more options: http://industry.java.sun.com/products/jdbc/drivers/search-results/1,2722,,00.html
but even with the purchased drivers, Access itself is limited.
Maybe if you could define what you need in "advanced features" we could better help you.
 
A George
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The advanced features that I meant are additional methods
(compared to jdk 1.1 docs)included in interface ResultSet of java.sql package in jdk 1.2 documentation .
If my knowledge is correct inorder to make use of that I will have to download J2SE 1.4 beta version consisting of jdbc-odbc driver having both java.sql and javax.sql package
or buy JDBC driver for MSAccess.
Thanks for your response.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic