wood burning stoves 2.0*
The moose likes JSP and the fly likes JSP -> MySQL -> MS Access Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » JSP
Bookmark "JSP -> MySQL -> MS Access" Watch "JSP -> MySQL -> MS Access" New topic
Author

JSP -> MySQL -> MS Access

senthil raja
Greenhorn

Joined: Jul 11, 2001
Posts: 17
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

Joined: Jun 25, 2001
Posts: 15639
    
  15

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.


Customer surveys are for companies who didn't pay proper attention to begin with.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JSP -> MySQL -> MS Access
 
Similar Threads
importing data from excel to Mysql database using jsp code
Suggestion on technologies that used for JSP to develop a project !
servlet-jdbc
How would I connect mysql database in lan using jdbc?
Get index of a row