?
Solved

Connect to an ms access database

Posted on 2006-04-30
3
Medium Priority
?
176 Views
Last Modified: 2008-03-17
I have a hotel  reservations database. I am currently creating a website that people can use to check the room availability using requested dates. I already have an sql query that does this
A friend suggessted JSP using a DSN connection. I have no ideas what this means
Question #1
 How can I incorporate this feature on the site using JSP?

Question #2
Are there any starter tutorial that will help me out? (nothing too complex)

Question #3
What software/hardware do I require besides access?
0
Comment
Question by:wkellya
1 Comment
 
LVL 19

Accepted Solution

by:
Jim Cakalic earned 200 total points
ID: 16574244
#1 Simplest thing is to use java scriptlets and/or sql tags in your JSP
     (see http://today.java.net/pub/a/today/2003/11/27/jstl2.html)
#2 http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&lngWId=2#SECTION0
#3 nothing, JDK has all the necessary classes for the JDBC-ODBC bridge (see #2) and your servlet engine should have the JSTL (Java Standard Tag Library). Which servlet engine are you using?

Regards,
Jim
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Over time, the online landscape has altered considerably, but that’s nothing compared to the up-and-coming trends that will shape the web design industry in the coming year. Keep reading to find out which trends will shape B2B web design in 2018.
Last month Marc Laliberte, WatchGuard’s Senior Threat Analyst, contributed reviewed the three major email authentication anti-phishing technology standards: SPF, DKIM, and DMARC. Learn more in part 2 of the series originally posted in Cyber Defense …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Screencast - Getting to Know the Pipeline
Suggested Courses

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question