Access, IMHO, is a dangerous bit of software when used badly. I think as
long as you keep it on the backend and resident on the web server, with
only the servlets accessing it, you should be OK. As far as stable,
multi-user databases go, steer well clear of Access. Go SQL Server or,
if you are of the Unix tilt, PostgreSQL (free and potent!) or MySQL. The
various open source RDBMS (well, MySQL and Postgres might be GPL'ed or
something similar) have JDBC drivers (types III and IV usually) which
would perhaps be more stable than the ODBC bridge (if not more stable,
offering more functionality perhaps).
HTH,
Joe.
"Curi, Miguel E (Miguel)" wrote:
>
> Thanks all! Changing the ODBC to system DSN worked! That was really fast to
> fix.... thanks.
>
> Now, David, I am planning on having some amount of activity in the database
> since is an application to be use in an intranet for a group of 16 people
> who are going to be constantly accessing data from their browsers. What do
> you suggest I use to prevent problems with the bridge? Is this going to be
> ok using Access as the database engine?
>
> -----Original Message-----
> From: David Hecksel [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, May 05, 1999 1:42 PM
> To: Curi, Miguel E (Miguel)
> Subject: Re: Servlets and JDBC
>
> I hope you're not planning on too much activity going to that database, or
> many
> threads simultaneously accessing the database. If so, the JDBC-ODBC bridge
> will
> likely cause you trouble. Read comp.lang.java.databases for periodic real
> life
> feedback on "the bridge".
>
> If a single user application that has a web interface, you shouldn't have
> any
> problems.
>
> Curi, Miguel E (Miguel) wrote:
>
> > I am working on a web base application that uses a servlet to access a
> > database using the JDBC-ODBC bridge (sun.jdbc.odbc.JdbcOdbcDriver). The
> > database is a MS Access database. I am having trouble connecting to the
> > database.
> > My program is able to load the driver but it fails to open the connection.
> >
> > I am using :
> >
> > Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> > Connection conn = DriverManager.getConnection("jdbc:odbc:MyDatabase");
> <----
> > This fails.
> >
> > I have MyDatabase setup in the ODBC Datasource Administrator of Windows NT
> > Workstation 4.0 SP4 as:
> >
> > User DSN: Pointing to my database file
> > D:\JavaWebServer1.1.3\database\mydata.mdb with no passwords.
> >
> > Anyone has any ideas????? It also happens with stand alone applications so
> > I'm thinking something is wrong in my ODBC settings in Windows.
> >
> > Need Help!
> > ---------------------------------------
> > Miguel Curi
> > Lucent Technologies
> > Network Wireless Systems
> > phone: (614) 860-3438
> > [EMAIL PROTECTED]
> >
> >
> ===========================================================================
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> > of the message "signoff JSP-INTEREST". For general help, send email to
> > [EMAIL PROTECTED] and include in the body of the message "help".
>
> --
>
> Regards,
>
> Dave Hecksel
> Axtive Software Corporation
> (214) 880-4820
>
> ---------------------------
>
> e.Business Personalization Made e.Z
>
> ===> For Interactive e.Business Personalization Solutions, <===
> ===> check out http://www.axtive.com <===
>
> ===========================================================================
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff JSP-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
--
---------------------------------------------
,-._|\ | Joe Shevland
/ \ | Principal Consultant
\_,--._/ | Turnaround Solutions Pty. Ltd.
v | http://www.TurnAround.com.au
---------------------------------------------
It is a dangerous thing to try to reform
anyone - Oscar Wilde
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff JSP-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".