Sitemap

Amicuk Programming Answers

JSP - MySQL - MS Access

-0001-11-30   Views:1

Advertisement

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

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

The replay answer
Advertisement
Thats what I meant. If both (Access and MySQL) both run on Windows there should be no problem. But if MySQL is on Linux and Access is on Windows it could be.
How about setting up Mysql on Windows, going the way magnoli supposed and after that using mysqldump to export zo linux.

Go to See the other 6 answers

JSP - MySQL - MS Access

Category:DefaultRelease time:-0001-11-30Views:130

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[More]

How to use taglibs in JSP for Database access

Category:DefaultRelease time:-0001-11-30Views:130

Hi Could any one please tell me how to use taglibs in JSP for Database access with regrds JojoThis is a sample how to connect to a MySQL database with JSTL 1.0: <%@ page contentType="text/html; charset=iso-8859-1" language="java" im[More]

JSP + MYSQL question: input form value into a SQL table

Category:DefaultRelease time:-0001-11-30Views:130

Hello, I am writing some JSP code to read input information from a input form to write this information into a SQL field. My problems are: - how can i pass the input form information to other jsp file ? (like Getproperty of something like this) - how[More]

JSP - MYSQL HELP

Category:DefaultRelease time:-0001-11-30Views:130

HI, Im trying to create a JSP which connects to a mysql database. I have downloaded all the connectivity drivers and dont know what to do from this stage. I have heard people talking about tomcat and apache but was wondering if i need them? Im new to[More]

JSP MYSQL ERROR moving in resultset

Category:DefaultRelease time:-0001-11-30Views:130

Hi I am new to jsp & mysql . I am trying to fetch data in a multiple select list box in my jsp page from a table in mysql . It fetches the first value and then exception is generated as no data found while there is data in the table . The same data i[More]

JSP/MYSQL Hosting

Category:DefaultRelease time:-0001-11-30Views:130

Hey all, Im looking to host a JSP/MYSQL site. Please tell me a hosting provider. also are there any providers in India that you know of . would really help if tis the same country. after looking through a lot of sites i have shortlisted. http://www.e[More]

Setup mySQL and access the same from jsp

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I have installed the MySQL in local desktop in d: drive. As per the documentation, have created my.cnf file to point sql directory in d drive. Now I dont know how to proceed further. I need to see if MySQL installation is fine, create table and a[More]

[b][u]JSP/mySQL CREATE DATABASE problem[/u][/b]

Category:DefaultRelease time:2015-10-11Views:130

I am trying to create a mySQL DB through JSP program (query). The Query : stmt.executeUpdate("CREATE DATABASE employee;"); is not working. PLEASE HELP ME................. The program is as follows. try Connection con =null; Class.forName("o[More]

JDBC/JSP/MySQL Code works from my local machine, but not on server

Category:DefaultRelease time:-0001-11-30Views:130

Hi there! I've been struggling with this problem for a while. I have a database from which I need to read and display some data on a browser. (The database is set up for remote access). I'm using the following JSP/JDBC code to do that. Class.forName[More]

Why doesn't doFilter work was expected when a .jsp page is accessed?

Category:DefaultRelease time:2015-10-11Views:130

I'm hoping an expert could point me in the right direction or tell me           if this is a bug in WebLogic.           My environment is WebLogic 6.1 (service pack 4), on Windows 2000.           I need to capture all the response data that comes bac[More]

I have setup JSP & MySQL but how can i Connect it to eche other ?

Category:DefaultRelease time:2015-10-11Views:130

I feel sory by asking this qustion but i tried very enough 100 mile start from 1 mile ^_^ I have tested JSP files by http://localhost:8080/test.jsp and it works very will also i have already installd MySQL and i can create databases and tables by htt[More]

Hot
Hello, I'm using Skillbuilders modal page plugin on Apex 4.1. The plugin works great in all browsers except in IE, where I'm unable to close the success message by clicking on the "x" in the upper right corner. I'll explain further. I have a rep [More]
Hi I am getting the following error while accessing my pages in the prod server. My prod servers are in loadshared mode with 3 servers. When I access the first and 2nd server all the pages are working fine but its failing in the 3rd server. Is it bec [More]
Hello - I received the following error message when I attempted to load a cube: No SID found for value '0.000' of characteristic 0CURRENCY Is anyone familiar with this error message?  Also, I tested this load in DEV before I moved the cube into QA bu [More]
Hi All I am very very new to Applets, and i am having a problem. Basically i need to create an applet with a GUI that creates a file and writes to it. I found this web pages and modified the code slightly so that it did what i needed: http://www.capt [More]
I want to send email message body as html. as some news sites send.What will easiest way of doing that?oops!!! Sorry there is one more thing in it the ByteArrayDataSource class. I am posting the code in the class here. Compile it in a separate class. [More]
Hi, I am looking for a platform to abstract form. I have to write a simple library that implements a network P2P server/Client scenario in TCP/IP or SNMP etc. The library has to be applicable for a variety of microcontroller. I thought a few years ag [More]
I have a Imac Mid 2011 , imac12,2 , i believe i should have Airplay mirroring but i cant find the option to turn on/off etc , i have followed the guides to where it should be .Im currently running Mountain lion 10.7.5 , if i upgrade to latest version [More]
hello, my name is Udi, from Israel. i have an iPhone 5 which i purchased in June 2013. since the beginning, i have always kept the battery saving "rules", including correct charging of a lithium ion battery, auto-brightness off, reduce motion on [More]
How do I upgrade to iPhoto 9.0 or iLife 11.  Can't find them in App store.  Not in my updates.If your stated OS is correct (OS X 10.8.3) then you must purchase an iLie '11 DVD - Amazon or eBay are potential sources LNRead other 2 answers [More]
Hi all Can anyone tell me how to create a community? Is it same as normal collaboration room? Regards AparnnaHi Aparnna, SDN is a very good example for a great community platform. It's build on the SAP NetWeaver Portal but without the use of collabor [More]