0

Dear all,

I am making MS Access database connection with my java program.
As i know that in Connection Following things are required:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con  = DriverManager.getConnection("jdbc:odbc:DSNname","Username","password");

Now i have created System DSN in Odbc data connection and also i have attached database with that DSN.
While creating DSN, i also provide username and password in configuration.

but now my problem is,Even if i am not passing username and password in getConnection() method, it will insert data into database.

So where's the problem?
How can i put username and password, so that without it my data should not be inserted in my database.
i am using MS-Access database right now.

please reply as soon as possible.

Thanks.

3
Contributors
4
Replies
28
Views
3 Years
Discussion Span
Last Post by jalpesh_007
0

if it updates no matter what pass/user you provide, my guess: you did something wrong during the configuration.

0

yes my database is updated every time i run the program,but wihtout username & password it will update data.

Is it compulsory to pass username and password in getConnection() method?Even if we have given username and password in configuration at creation of System DSN.

0

My guess is that if your Access file is not password protected the username and password make no difference.

0

Thanks

Mean is it compulsory to make access file password protected?

can't i make database refuse request on entering wrong password i had set for ?

This article has been dead for over six months. Start a new discussion instead.
Be sure to adhere to our posting rules.