File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JSP -> MySQL -> MS Access

 
senthil raja
Greenhorn
Posts: 17
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have a set of tables in MS Access database and MySQL database.
My jsp application is running with the help of Apache/Tomcat in Linux box.
I've the MM.MySQL Driver to integrate MySQL with my application.
my problem is to know how to communicate jsp with MS Access here.
I don't know how to connect jsp to MS Access in Linux.
I searched for solution and finally got an idea of using MyODBC api.
I need to import data from MS Access to MySQL using MyODBC on Linux.
Can anyone help me on how to install,configure MyODBC and import data.
or please pass any reference url.
or
please suggest me any solution for this.
Thanks
Senthil
 
Tim Holloway
Saloon Keeper
Pie
Posts: 17646
39
Android Eclipse IDE Linux
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Actually, most people use the jdbc-odbc bridge to work with MS-Access. Access isn't a good database to be using for web purposes, though. It's a personal-use DBMS and not geared for multithreaded operations.
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic