Forums Register Login

Connecting MS Access databse to web using JDBC

+Pie Number of slices to send: Send
I have a MS Access database that i wish to connect to the web using JDBC. I have designed a basic web page with a text box and submit button. I wish to be able to query my Access database using the input provided by a user on the web page, and return to the user the information he/she has requested.
I am new to this game and need to know where to start from. I have done a lot of reading around this subject and am confused as I understand there are many ways of doing this.
Obviously my server would need a copy of MS Access and my database. Would i need IIS to be installed on the server as well?
I am a bit confused in terms of where the JAVA coding will go. Will it be on the HTML web page or as a servlet on the server?
All help is greatly appreciated.
+Pie Number of slices to send: Send
well. basically u will need a web server that supports servlets. IIS wont do, but there is a free one called tomcat u can find at the sun site (http://java.sun.com)
your code to connect to the DB will be either in a servlet (which u will call from a jsp page or html page) or in a bean that u will use inside a jsp page.
i recommend trying to read this site for a little bit more background.
+Pie Number of slices to send: Send
Actually, Tomcat is located at http://jakarta.apache.org
All of your Java code will either go into a servlet or a JSP page. I recommend using JSP and calling most of your code from JavaBeans. If you have no clue how to do this then email me and I'll send you some instructions for setting up Tomcat and some source code I have written to do exactly what you want to do. Also, the computer does not have to have MS Access installed on it. You just have to have a copy of the database. If you are using a Windows machine you can use a JDBC-ODBC bridge to connect to your database. Otherwise, you will have to buy a MS Access JDBC driver that is compatible with Linix/UNIX or whatever OS you will be running this application on.
If you try to please everybody, your progress is limited by the noisiest fool. And this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 821 times.
Similar Threads
JDBC type 3 driver
SqueLink Server 5.2, SequeLink Socket Server and SequeLinl Legacy Server
Design Suggestions
Major Dilemna
Servlets, JDBC and Mysql
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 19, 2024 00:23:10.