Forums Register Login

very urgent idea needed

+Pie Number of slices to send: Send
well i want ti do a demo jsp page which can connect to "Microsoft Access ". This page is a simple user authentication page where i have a username and password . In microsoft access i have a table with "username" and password and each having a valid user value and i want to authenticate that is through my jsp page , only if user enters correct name and password he should be taken to next page. how can i do it ?? i found examples only with sql but how can i do it with microsoft access. pls advice.
+Pie Number of slices to send: Send
vivek
You'll need to change the driver to be the jdbcodbc bridge and the connection url to be the access database you're using. After that the SQL query should be the same, something like:
SELECT * FROM users WHERE username='username' AND password='password'. Then just test to see if you get a result set back from the query.
If you get stuck, post the code you've got and let us know exactly where you are stuck.
hope that helps
+Pie Number of slices to send: Send
What do u mean by connection url (is it just the data base name or what ???
It will give me the powers of the gods. Not bad for a tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com


reply
reply
This thread has been viewed 782 times.
Similar Threads
how to display errors in servlet
Connectiong to FTP site
Security BEA
Reading password information from a text file.
Authnetication and getRemoteUser()
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 13:52:15.