Re: Is there a native JDBC driver for MS Access?
There are JDBC drivers for Access out there, but you have to pay for them: http://www.idssoftware.com/jdbcdrv.html http://www.atinav.com/products/aveconnect/MSAccess.htm (I have no idea how either of these performs though) --- chuck amadi <[EMAIL PROTECTED]> wrote: > Adrian Beech wrote: > > >Um, okay then how stable is the JDBC/ODBC bridge? As I > previously > >mentioned in my initial posting some bits and peices that I've read > suggest > >that this method of connecting to a DB back end is, or can be, a > little > >dodgy. The comments basically revolved around the premise that the > bridge > >is not capable of being threaded and it is considered by Sun to > still be > >experimental. I got the impression that there is potential for data > loss or > >corruption along with performance related issues. > > > >I guess I really need to know if it is reasonable to use Tomcat to > host an > >environment that relies on this sort of DB connectivity. > > > >Adrian > >[EMAIL PROTECTED] > > > > > >- Original Message - > >From: "Matt Gregory" <[EMAIL PROTECTED]> > >To: "Tomcat Users List" <[EMAIL PROTECTED]> > >Sent: Saturday, April 06, 2002 11:06 PM > >Subject: Re: Is there a native JDBC driver for MS Access? > > > > > >>No, you are forced to use the JDBC/ODBC bridge or purchase one of > the > >>proprietary drivers available. I know there are Paradox, FoxPro > and dBase > >>IV drivers but I have not seen any for Access. > >> > >>- Original Message ----- > >>From: "Adrian Beech" <[EMAIL PROTECTED]> > >>To: "'Tomcat Users List'" <[EMAIL PROTECTED]> > >>Sent: Sunday, April 07, 2002 6:47 AM > >>Subject: Is there a native JDBC driver for MS Access? > >> > >> > >>G'day all, > >> > >>Is there a native JDBC driver for MS Access? A few postings I've > seen in > >>the list archive make mentioned that the JDBC/ODBC bridge is a bit > dodgy. > >> > >>I have Tomcat 4.03 running as a standalone on a Win 2k pro box with > JDK > >>1.3.1 installed. > >> > >>I'm rather new to Tomcat, JSP, JDBC, etc... > >> > >>Any help would be appreciated. > >> > >>Adrian Beech > >>[EMAIL PROTECTED] > >> > >> > >> > >> > >>-- > >>To unsubscribe: > <mailto:[EMAIL PROTECTED]> > >>For additional commands: > <mailto:[EMAIL PROTECTED]> > >>Troubles with the list: > <mailto:[EMAIL PROTECTED]> > >> > > > > > >-- > >To unsubscribe: > <mailto:[EMAIL PROTECTED]> > >For additional commands: > <mailto:[EMAIL PROTECTED]> > >Troubles with the list: > <mailto:[EMAIL PROTECTED]> > > > I was under the impression that it was recommended that you obtain a > commercial JDBC driver from a vendor such as your RDBMS /middleware > vendor as the JDBC-ODBC driver is usaually used for experimental use > or > if no other is available. > Anyway there is mysql odbc which works fine with Mysql back-end and > front-end M$ Aceess 2000. > > Cheers Chuck Amadi > Systems Programmer > > > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> > __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
Re: Is there a native JDBC driver for MS Access?
Adrian Beech wrote: >Um, okay then how stable is the JDBC/ODBC bridge? As I previously >mentioned in my initial posting some bits and peices that I've read suggest >that this method of connecting to a DB back end is, or can be, a little >dodgy. The comments basically revolved around the premise that the bridge >is not capable of being threaded and it is considered by Sun to still be >experimental. I got the impression that there is potential for data loss or >corruption along with performance related issues. > >I guess I really need to know if it is reasonable to use Tomcat to host an >environment that relies on this sort of DB connectivity. > >Adrian >[EMAIL PROTECTED] > > >- Original Message - >From: "Matt Gregory" <[EMAIL PROTECTED]> >To: "Tomcat Users List" <[EMAIL PROTECTED]> >Sent: Saturday, April 06, 2002 11:06 PM >Subject: Re: Is there a native JDBC driver for MS Access? > > >>No, you are forced to use the JDBC/ODBC bridge or purchase one of the >>proprietary drivers available. I know there are Paradox, FoxPro and dBase >>IV drivers but I have not seen any for Access. >> >>- Original Message - >>From: "Adrian Beech" <[EMAIL PROTECTED]> >>To: "'Tomcat Users List'" <[EMAIL PROTECTED]> >>Sent: Sunday, April 07, 2002 6:47 AM >>Subject: Is there a native JDBC driver for MS Access? >> >> >>G'day all, >> >>Is there a native JDBC driver for MS Access? A few postings I've seen in >>the list archive make mentioned that the JDBC/ODBC bridge is a bit dodgy. >> >>I have Tomcat 4.03 running as a standalone on a Win 2k pro box with JDK >>1.3.1 installed. >> >>I'm rather new to Tomcat, JSP, JDBC, etc... >> >>Any help would be appreciated. >> >>Adrian Beech >>[EMAIL PROTECTED] >> >> >> >> >>-- >>To unsubscribe: <mailto:[EMAIL PROTECTED]> >>For additional commands: <mailto:[EMAIL PROTECTED]> >>Troubles with the list: <mailto:[EMAIL PROTECTED]> >> > > >-- >To unsubscribe: <mailto:[EMAIL PROTECTED]> >For additional commands: <mailto:[EMAIL PROTECTED]> >Troubles with the list: <mailto:[EMAIL PROTECTED]> > I was under the impression that it was recommended that you obtain a commercial JDBC driver from a vendor such as your RDBMS /middleware vendor as the JDBC-ODBC driver is usaually used for experimental use or if no other is available. Anyway there is mysql odbc which works fine with Mysql back-end and front-end M$ Aceess 2000. Cheers Chuck Amadi Systems Programmer -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
Re: Is there a native JDBC driver for MS Access?
You may want to check out Sprinta2000 driver. I could get you the URL on monday or you can just look it up on a search engine. We use it for getting to MS-SQL. I expect that they could be used to get to Access. Shantul. On Saturday, April 6, 2002, at 08:55 PM, <[EMAIL PROTECTED]> wrote: > mysql, postgresql, anything but ms access even sqlserver would be vast > improvement. > > On Sat, 6 Apr 2002, Sriram N wrote: > >> >> --- "Craig R. McClanahan" <[EMAIL PROTECTED]> wrote: >>> >>> >>> On Mon, 8 Apr 2002, Adrian Beech wrote: >>> >>>> Date: Mon, 8 Apr 2002 10:38:45 +1000 >>>> From: Adrian Beech <[EMAIL PROTECTED]> >>>> Reply-To: Tomcat Users List <[EMAIL PROTECTED]> >>>> To: Tomcat Users List <[EMAIL PROTECTED]> >>>> Subject: Re: Is there a native JDBC driver for MS Access? >>>> >>>> Um, okay then how stable is the JDBC/ODBC bridge? As I >>>> previously >>>> mentioned in my initial posting some bits and peices that I've read >>>> suggest >>>> that this method of connecting to a DB back end is, or can be, a >>>> little >>>> dodgy. The comments basically revolved around the premise that the >>>> bridge >>>> is not capable of being threaded and it is considered by Sun to >>>> still be >>>> experimental. I got the impression that there is potential for data >>>> loss >>> or >>>> corruption along with performance related issues. >>>> >>> >>> The JDBC/ODBC bridge is not appropriate for use in a multithreaded >>> environment like a servlet container. Also, lots of people have had >>> problems trying to use MS Access (designed for personal desktop use) >>> in >>> environments like this, even with a for-pay JDBC driver. >>> >>> I'd start by choosing a different database. >> >> How about MySQL (http://www.mysql.org) ? They have a type 4 JDBC >> driver. >> Is this OK in a multithreaded environment ? >> >>> >>>> I guess I really need to know if it is reasonable to use Tomcat to >>>> host an >>>> environment that relies on this sort of DB connectivity. >>>> >>>> Adrian >>>> [EMAIL PROTECTED] >>>> >>> >>> Craig >>> >> Sriram >> >> __ >> Do You Yahoo!? >> Yahoo! Tax Center - online filing with TurboTax >> http://taxes.yahoo.com/ >> >> -- >> To unsubscribe: <mailto:[EMAIL PROTECTED]> >> For additional commands: <mailto:[EMAIL PROTECTED]> >> Troubles with the list: <mailto:[EMAIL PROTECTED]> >> >> > > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> > > == = Knowledge is power = = Absolute Knowledge is Absolute Power = == -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
Re: Is there a native JDBC driver for MS Access?
i agree, access is a very poor choice of db for ANY production system. matt - Original Message - From: "Craig R. McClanahan" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Saturday, April 06, 2002 8:08 PM Subject: Re: Is there a native JDBC driver for MS Access? > > > On Mon, 8 Apr 2002, Adrian Beech wrote: > > > Date: Mon, 8 Apr 2002 10:38:45 +1000 > > From: Adrian Beech <[EMAIL PROTECTED]> > > Reply-To: Tomcat Users List <[EMAIL PROTECTED]> > > To: Tomcat Users List <[EMAIL PROTECTED]> > > Subject: Re: Is there a native JDBC driver for MS Access? > > > > Um, okay then how stable is the JDBC/ODBC bridge? As I previously > > mentioned in my initial posting some bits and peices that I've read suggest > > that this method of connecting to a DB back end is, or can be, a little > > dodgy. The comments basically revolved around the premise that the bridge > > is not capable of being threaded and it is considered by Sun to still be > > experimental. I got the impression that there is potential for data loss or > > corruption along with performance related issues. > > > > The JDBC/ODBC bridge is not appropriate for use in a multithreaded > environment like a servlet container. Also, lots of people have had > problems trying to use MS Access (designed for personal desktop use) in > environments like this, even with a for-pay JDBC driver. > > I'd start by choosing a different database. > > > I guess I really need to know if it is reasonable to use Tomcat to host an > > environment that relies on this sort of DB connectivity. > > > > Adrian > > [EMAIL PROTECTED] > > > > Craig > > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
Re: Is there a native JDBC driver for MS Access?
mysql, postgresql, anything but ms access even sqlserver would be vast improvement. On Sat, 6 Apr 2002, Sriram N wrote: > > --- "Craig R. McClanahan" <[EMAIL PROTECTED]> wrote: > > > > > > On Mon, 8 Apr 2002, Adrian Beech wrote: > > > > > Date: Mon, 8 Apr 2002 10:38:45 +1000 > > > From: Adrian Beech <[EMAIL PROTECTED]> > > > Reply-To: Tomcat Users List <[EMAIL PROTECTED]> > > > To: Tomcat Users List <[EMAIL PROTECTED]> > > > Subject: Re: Is there a native JDBC driver for MS Access? > > > > > > Um, okay then how stable is the JDBC/ODBC bridge? As I previously > > > mentioned in my initial posting some bits and peices that I've read suggest > > > that this method of connecting to a DB back end is, or can be, a little > > > dodgy. The comments basically revolved around the premise that the bridge > > > is not capable of being threaded and it is considered by Sun to still be > > > experimental. I got the impression that there is potential for data loss > > or > > > corruption along with performance related issues. > > > > > > > The JDBC/ODBC bridge is not appropriate for use in a multithreaded > > environment like a servlet container. Also, lots of people have had > > problems trying to use MS Access (designed for personal desktop use) in > > environments like this, even with a for-pay JDBC driver. > > > > I'd start by choosing a different database. > > How about MySQL (http://www.mysql.org) ? They have a type 4 JDBC driver. > Is this OK in a multithreaded environment ? > > > > > > I guess I really need to know if it is reasonable to use Tomcat to host an > > > environment that relies on this sort of DB connectivity. > > > > > > Adrian > > > [EMAIL PROTECTED] > > > > > > > Craig > > > Sriram > > __ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://taxes.yahoo.com/ > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> > > -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
Re: Is there a native JDBC driver for MS Access?
--- "Craig R. McClanahan" <[EMAIL PROTECTED]> wrote: > > > On Mon, 8 Apr 2002, Adrian Beech wrote: > > > Date: Mon, 8 Apr 2002 10:38:45 +1000 > > From: Adrian Beech <[EMAIL PROTECTED]> > > Reply-To: Tomcat Users List <[EMAIL PROTECTED]> > > To: Tomcat Users List <[EMAIL PROTECTED]> > > Subject: Re: Is there a native JDBC driver for MS Access? > > > > Um, okay then how stable is the JDBC/ODBC bridge? As I previously > > mentioned in my initial posting some bits and peices that I've read suggest > > that this method of connecting to a DB back end is, or can be, a little > > dodgy. The comments basically revolved around the premise that the bridge > > is not capable of being threaded and it is considered by Sun to still be > > experimental. I got the impression that there is potential for data loss > or > > corruption along with performance related issues. > > > > The JDBC/ODBC bridge is not appropriate for use in a multithreaded > environment like a servlet container. Also, lots of people have had > problems trying to use MS Access (designed for personal desktop use) in > environments like this, even with a for-pay JDBC driver. > > I'd start by choosing a different database. How about MySQL (http://www.mysql.org) ? They have a type 4 JDBC driver. Is this OK in a multithreaded environment ? > > > I guess I really need to know if it is reasonable to use Tomcat to host an > > environment that relies on this sort of DB connectivity. > > > > Adrian > > [EMAIL PROTECTED] > > > > Craig > Sriram __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
Re: Is there a native JDBC driver for MS Access?
On Mon, 8 Apr 2002, Adrian Beech wrote: > Date: Mon, 8 Apr 2002 10:38:45 +1000 > From: Adrian Beech <[EMAIL PROTECTED]> > Reply-To: Tomcat Users List <[EMAIL PROTECTED]> > To: Tomcat Users List <[EMAIL PROTECTED]> > Subject: Re: Is there a native JDBC driver for MS Access? > > Um, okay then how stable is the JDBC/ODBC bridge? As I previously > mentioned in my initial posting some bits and peices that I've read suggest > that this method of connecting to a DB back end is, or can be, a little > dodgy. The comments basically revolved around the premise that the bridge > is not capable of being threaded and it is considered by Sun to still be > experimental. I got the impression that there is potential for data loss or > corruption along with performance related issues. > The JDBC/ODBC bridge is not appropriate for use in a multithreaded environment like a servlet container. Also, lots of people have had problems trying to use MS Access (designed for personal desktop use) in environments like this, even with a for-pay JDBC driver. I'd start by choosing a different database. > I guess I really need to know if it is reasonable to use Tomcat to host an > environment that relies on this sort of DB connectivity. > > Adrian > [EMAIL PROTECTED] > Craig -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
Re: Is there a native JDBC driver for MS Access?
Um, okay then how stable is the JDBC/ODBC bridge? As I previously mentioned in my initial posting some bits and peices that I've read suggest that this method of connecting to a DB back end is, or can be, a little dodgy. The comments basically revolved around the premise that the bridge is not capable of being threaded and it is considered by Sun to still be experimental. I got the impression that there is potential for data loss or corruption along with performance related issues. I guess I really need to know if it is reasonable to use Tomcat to host an environment that relies on this sort of DB connectivity. Adrian [EMAIL PROTECTED] - Original Message - From: "Matt Gregory" <[EMAIL PROTECTED]> To: "Tomcat Users List" <[EMAIL PROTECTED]> Sent: Saturday, April 06, 2002 11:06 PM Subject: Re: Is there a native JDBC driver for MS Access? > No, you are forced to use the JDBC/ODBC bridge or purchase one of the > proprietary drivers available. I know there are Paradox, FoxPro and dBase > IV drivers but I have not seen any for Access. > > - Original Message - > From: "Adrian Beech" <[EMAIL PROTECTED]> > To: "'Tomcat Users List'" <[EMAIL PROTECTED]> > Sent: Sunday, April 07, 2002 6:47 AM > Subject: Is there a native JDBC driver for MS Access? > > > G'day all, > > Is there a native JDBC driver for MS Access? A few postings I've seen in > the list archive make mentioned that the JDBC/ODBC bridge is a bit dodgy. > > I have Tomcat 4.03 running as a standalone on a Win 2k pro box with JDK > 1.3.1 installed. > > I'm rather new to Tomcat, JSP, JDBC, etc... > > Any help would be appreciated. > > Adrian Beech > [EMAIL PROTECTED] > > > > > -- > To unsubscribe: <mailto:[EMAIL PROTECTED]> > For additional commands: <mailto:[EMAIL PROTECTED]> > Troubles with the list: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
Re: Is there a native JDBC driver for MS Access?
There is NO native Access Driver... for NON-Microsoft Platforms... OBDC only... It is possible to run a JDBC Driver to get to an ODBC Connection on a Microsoft Machine. For developers, I believe even Microsoft suggests you use Foxpro. There is a fellow who wrote a Class 4 JDBC Driver for Foxpro, and it works great I've been working with him on better UltraDev Integration. There will be File Locking Soon, that will allow native foxpro applications to seemlessly work with web applications. http://www.hxtt.net/jdbc.html todd http://www.wiserlabz.com collaborative effort to promote Novell and Open Source solutions Adrian Beech wrote: >G'day all, > >Is there a native JDBC driver for MS Access? A few postings I've seen in the list >archive make mentioned that the JDBC/ODBC bridge is a bit dodgy. > >I have Tomcat 4.03 running as a standalone on a Win 2k pro box with JDK 1.3.1 >installed. > >I'm rather new to Tomcat, JSP, JDBC, etc... > >Any help would be appreciated. > >Adrian Beech >[EMAIL PROTECTED] > > -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
Re: Is there a native JDBC driver for MS Access?
No, you are forced to use the JDBC/ODBC bridge or purchase one of the proprietary drivers available. I know there are Paradox, FoxPro and dBase IV drivers but I have not seen any for Access. - Original Message - From: "Adrian Beech" <[EMAIL PROTECTED]> To: "'Tomcat Users List'" <[EMAIL PROTECTED]> Sent: Sunday, April 07, 2002 6:47 AM Subject: Is there a native JDBC driver for MS Access? G'day all, Is there a native JDBC driver for MS Access? A few postings I've seen in the list archive make mentioned that the JDBC/ODBC bridge is a bit dodgy. I have Tomcat 4.03 running as a standalone on a Win 2k pro box with JDK 1.3.1 installed. I'm rather new to Tomcat, JSP, JDBC, etc... Any help would be appreciated. Adrian Beech [EMAIL PROTECTED] -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
Is there a native JDBC driver for MS Access?
G'day all, Is there a native JDBC driver for MS Access? A few postings I've seen in the list archive make mentioned that the JDBC/ODBC bridge is a bit dodgy. I have Tomcat 4.03 running as a standalone on a Win 2k pro box with JDK 1.3.1 installed. I'm rather new to Tomcat, JSP, JDBC, etc... Any help would be appreciated. Adrian Beech [EMAIL PROTECTED]