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".
