wood burning stoves
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: http://aspose.com/file-tools
subject: ODBC authentication problem
It's not a secret anymore!