Thank you very much,Celeste, for your advice. I will try to download MySQL.
Emeline
>From: "Haseltine, Celeste" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: JRun-Talk <[EMAIL PROTECTED]>
>Subject: RE: Access Database
>Date: Mon, 27 Aug 2001 11:18:35 -0500
>
>Emiline,
>
>If you are trying to use/create more than one connection at a time, then
>you
>will probably want to write a connection pool object yourself, particularly
>since you are using the ODBC-JDBC bridge. You will then need to pull a
>connection from the pool, use it, then return it to the pool. This type of
>functionality is available to you WITHOUT the headache of writing/testing
>your own connection pool is you use a real database and a Type III/IV JDBC
>driver.
>
>I would strongly suggest that if you have no other database available to
>you
>other than Access, that you download the free database MySQL. I have also
>seen posts to this listserver of other free databases such as Interbase by
>Borland. You can do a search of the archives of the
>[EMAIL PROTECTED] discussion group to find more info on both of
>these databases. Both database's come with JDBC drivers, and offer a much
>more realistic learning experience than the JDBC-ODBC bridge. You will
>NEVER use Access and the JDBC-ODBC bridge in a real development project, or
>at least I hope you never try to. So I would not waste my time working with
>the ODBC-JDBC bridge and Access if you are tying to learn Java and/or
>JPS's.
>
>Celeste
>
>-----Original Message-----
>From: Emeline Barns [mailto:[EMAIL PROTECTED]]
>Sent: Saturday, August 25, 2001 12:39 PM
>To: JRun-Talk
>Subject: RE: Access Database
>
>
>
>Hi Dave,
>If I am using under 20 simeltenious connectons is it OK to use JDBC_ODBC
>bridge for Access when only using SELECT statements?
>Elena
>
>
> >From: "Dave Feltenberger" <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: JRun-Talk <[EMAIL PROTECTED]>
> >Subject: RE: Access Database
> >Date: Thu, 23 Aug 2001 10:16:58 -0400
> >
> >SQL Server is even more expensive than 3rd party drivers... I'd stick
>with
> >Access (if it's working OK for you) and use the JDBC/ODBC bridge. If
> >reliability were an issue, and the application you're using were getting
> >hit
> >thousands of times per second, you wouldn't be using Access in the first
> >place - so the JDBC/ODBC bridge should work perfectly fine. It's
>included
> >with JRun.
> >
> > > -----Original Message-----
> > > From: Bert [mailto:[EMAIL PROTECTED]]
> > > Sent: Thursday, August 23, 2001 10:14 AM
> > > To: JRun-Talk
> > > Subject: Re: Access Database
> > >
> > >
> > > third party drivers are expensive you may want to upgrade to
> > > Sql Server
> > > ----- Original Message -----
> > > From: "Jackie Comeau" <[EMAIL PROTECTED]>
> > > To: "JRun-Talk" <[EMAIL PROTECTED]>
> > > Sent: Thursday, August 23, 2001 9:55 AM
> > > Subject: RE: Access Database
> > >
> > >
> > > > I've tried the JDBC-ODBC bridge and it doesn't work all
> > > that well. Your
> > > > better off going with a third-party driver. They are hard
> > > to find for
> > > > Access, and never found a freebee for Access. I'm using
> > > JDataConnect.
> > > >
> > > > Jackie
> > > >
> > > > On Thursday, August 23, 2001 8:03 AM, Vitaly Shorin
> > > > [SMTP:[EMAIL PROTECTED]] wrote:
> > > > > Hi Rich,
> > > > > I think the only way to do this is to use JDBC-ODBC bridge.
> > > > > I did not hear about any third-party drivers, and the people in
> > > Microsoft
> > > > > are not fans of Java. Really, they didn't implement ever
> > > MS SQL drivers
> > > > for
> > > > > JDBC!
> > > > >
> > > > > Regards,
> > > > > Vitaly.
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Rich Tretola" <[EMAIL PROTECTED]>
> > > > > To: "JRun-Talk" <[EMAIL PROTECTED]>
> > > > > Sent: Thursday, August 23, 2001 3:57 PM
> > > > > Subject: Access Database
> > > > >
> > > > >
> > > > > > How do I set up an Access database connection to JRun?
> > > > > > Rich
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
