File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes ODBC authentication problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "ODBC authentication problem" Watch "ODBC authentication problem" New topic

ODBC authentication problem


Joined: Feb 02, 2002
Posts: 4
My application currently uses JDBC-ODBC driver to connect to an MS Access database. With a correct username and password, authenticates fine. With invalid username and password, authentication fails. With any username and no password, authenticates fine. The last one is a big problem, have any suggestions on how to fix?
Sals Hamid

Joined: Jan 04, 2002
Posts: 24
By using sessions u can handle this problem e.g.
u create html file for login. There is 2 text boxes in it one is for user name and other for password,there names are id and p.
In jsp file in scriplets tag
<% id = request.getParameter("id");
In this way u can solve ur problem

No Path of Flowers lead to glory

Joined: Feb 02, 2002
Posts: 4
Is there away to do it without using any external application? The password will be set in ODBC Data Source Administrator, and will not be hard-coded or stored in a config file.
I agree. Here's the link:
subject: ODBC authentication problem
It's not a secret anymore!