Manish For an access file I dont think so. In order to do it DSNless then you'd need to have a different type of driver than an ODBC. I don't think there is one for Access. I know M$ just came out with one for SQL Server but I'm not positive about Access. You could go to google and try to do a search for a type 4 JDBC dirver with access as a keyword in the search statement.
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 jdbcdbc 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