you can bypass the DSN by giving an ODBC compatible URL. This is what I use to connect to my Access database without using a DSN:
The DSN-less connection assumes that 1. you have the specified access driver already installed on your computer. 2. the driver specified in 1 can successfully communicate with the database specified in the URL 3. The database exists in the location specified in the URL and has the same name. 4. You didn't add remove any spaces from the connection URL. If you did, re-cut and paste my code because the URL is space sensitive. 5. All the planets are aligned correctly I have seen guys pull their hair out trying to get this one going, that's why I mention assumption 5. This is not an elegant solution that is portable. Just because it works for me or you, doesn't mean that it will work for a friend( too many OS and Access driver version variations ). Jamie [ January 23, 2003: Message edited by: Jamie Robertson ]
Joined: May 05, 2000
If I remember correctly, Sun does not recommend that the JDBC-ODBC bridge be used for production. Found the link: http://java.sun.com/j2se/1.3/docs/guide/jdbc/getstart/bridge.doc.html The JDBC-ODBC Bridge driver is recommended only for experimental use or when no other alternative is available. [ January 23, 2003: Message edited by: Thomas Paul ]
Joined: Sep 28, 2002
The single most reliable way is to use the DSN entry! It works! Simple and easy! This way you do not have to worry about the Planets! I've been there before. It takes 1 minute tops to create a DSN entry.