[jelly]

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.

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