Setting the DSN

**tim** · 01-30-2008, 01:17 PM

Hello everyone.

I'm self-studying JDBC and in the books and tutorials it says that the DSN for a database system must be set on the operating system, Windows in my case. How can this be done by Java code? I don't think that the end user should be doing this technical work. :rolleyes:

Thank you. :D

**jelly** · 02-14-2008, 10:55 PM

Hi Tim, just in case you never found the answer to this. Strictly speaking you cannot set the DSN from Java but what you can do is make a JDBC connect without a DSN, usually referred to as a DSNless connection. In this case you specify from code the details that you would have put in th eDSN, e.g.

Java Code:

String connectionString =
"jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/dbs/salaries.MDB";
DBConn = DriverManager.getConnection(connectionString);

Masses on the net under dsnless connections if you need more