Originally posted by Manish Hatwalne:
Is it possible to use JDBC w/o a DSN? Is it possible to use JDBC with the MS Access file directly?
TIA,
- Manish
There are workarounds. The one I use for MSAccess and the jdbc:odbc bridge is this ( no configuration or DSN setup required ) :
*NOTE - this method is VERY finicky. All the spaces in the connection
string MUST stay the same. Failure to do this will cause exceptions.
**NOTE - ODBC driver implementations of MSAccess may be different, and thus this may not work for your computer
***NOTE - as you can see from the previous 2 notes, this probably isn't a solution to something that will go into production...then again using MSAccess isn't either
Jamie