I know I will use JDBC. An .udl file is a simple textfile with
something writed in it (like this):
[oledb]
; Everything after this line is an OLE DB initstring
Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=D:\Programmering\Work\MediaGruppa\New
Site\Database\kassetter.mdb;Mode=Share Deny None;Persist Security
Info=False
In Windows, you just create a empty text file, and name the extention
.udl . Double click on the .udl file, and you will get up a
configuration window. Here you can choose driver, path to the
database, and access mode, password, and even test the connection. I
know JDBC can use ODBC to connect to database. So I hoped there was a
way to access this initstring from Java. (That would be cool)
More experienced programmers I know didn't know about this technic,
and that surprised me. In the first round, I want to connect to MS
Access.