Look for the JDBC-ODBC bridge doco on Javasoft's jdbc site. You must register your Access MDB as an ODBC datasource with Windows, first off.
The JDBC-ODBC bridge comes with the JDK. It's free and not recommended by Sun or anyone else for production. Scott Stirling JRun QA > -----Original Message----- > From: Tamas Vertse [mailto:[EMAIL PROTECTED]] > > > Hey, > > I found a JDBC-ODBC brigde by JDBC wizard in the setting of > "Jrun admin > server > JDBC Data Sources" and I tried to add a new one. > name: firstdb.mdb > display name: http://localhost:8100/firstdb.mdb > driver: sun.jdbc.odbc.JdbcOdbcDriver > > I copied the mdb file into the JRun home directory and the > folder of admin > server. > The test of the new jdbc occured the following error: > "[Microsoft][ODBC Driver Manager] Data source name not found > and no default > driver specified" > > Bye, > Tamas > > > >From: "Mark Phelps" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: JRun-Talk <[EMAIL PROTECTED]> > >Subject: RE: access a MS Access DB from Jrun > >Date: Tue, 20 Nov 2001 08:39:35 -0700 > > > >You just need to obtain a JDBC driver for Access. Sun > provides a driver > >called the JDBC-ODBC bridge which would work. You can > download it from > >www.javasoft.com. I have heard from others on this list, > however, that > >this > >driver is not very good for heavy duty projects. Perhaps > somebody on the > >list knows of a better driver out there somewhere. > > > >-----Original Message----- > >From: Tamas Vertse [mailto:[EMAIL PROTECTED]] > >Sent: Tuesday, November 20, 2001 8:24 AM > >To: JRun-Talk > >Subject: access a MS Access DB from Jrun > > > > > >Hey, > >I have a Jrun server 3.0 and I would like to access an mdb > file from a JSP > >file under Jrun. > >How can I do it? (My Jrun is standalone. I haven't linked > any external > >webserver to it.) > >I wait your respones. > >Thanks, > >Tamas > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/jrun-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
