Hallo everyone i need help on how to connect to an MS Access database.

i don't know what i need to specify in the driver and url string for the parameters in the getConnection method.

i've tried with "sun.jdbc.odbc.JdbcOdbcDriver" for the driver string, and "jdbc:odbc:C:\\dbExample.mdb" for the url string, but it won't work. any help would be very appreciated.

 ODBC
 Standard Security: "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;"
 Workgroup: "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;SystemDB=C:\mydatab ase.mdw;"
 Exclusive: "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=adm in;Pwd="

I'm doing similar things, but web-based. Is the connection string similar when you access this via JSP? Would you create a Bean with the above code in it, or could you just use a database connection string in the JSP code itself? I'm trying to make a basic database connection work in JSP -> Access, so as to desktop-test some web apps.

Thanks,

--tgr

Thaddeus G. Reeves
Internet Dissemination
Church of Scientology Int'l

You can add code to JSP, I use a bean that returns a recordset to keep the JSP cleaner.
Another way is to use JNDI to create a database reference in your configuration files (in tomcat at least).

The advantage of using JNDI is that you can take advantage of connection pooling. I prefer the bean as I 'think' it will be more easily ported to a different server.