Hi, Just want to ask is it possible for java application to connect to MS access without configuring the DSN? and if i dont have office install on my machine, can the application still connect to the database? regards Jamie.
This is how I connect to MSAccess using a dsn-less connection. I believe you will need MSAccess Installed because the jdbc dbc bridge uses its ODBC drivers. Try it with and without to see:
note: spacing matters so just cut and paste your data into this string Jamie I had better disable smilies! [This message has been edited by Jamie Robertson (edited November 12, 2001).] [This message has been edited by Jamie Robertson (edited November 12, 2001).]
Joined: Nov 05, 2001
Thanks a million for the code! i tried out to run my program without Office installed and it works. Apparently, the ODBC driver comes with the OS. i will further test the result on other platform. Thanks again Jamie.