See:
http://java.sun.com/products/jdbc/drivers.html
I used the IDS drivers for SQL Server once a while
back and they worked nicely, I'm not sure how they
would work with Access but I think you can
get an eval. Anyway, there were a lot more there
at a glance that supported MS Access.
JVM crashing, well you're moving into the
Java native interface with ODBC calls, something
bound to be able to cause a crash on Windows :L
That and also inhaling can cause Windows to crash.
Servlets are multithreaded unless you use
the SingleThreadedModel, otherwise you
may be able to use a single server type
beast to talk to the database on behalf of the
servlets... you're using Access so I take it
you're requirements are not large.
Regards,
Joe.
----- Original Message -----
From: "Greg Ames" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 09, 2000 9:42 AM
Subject: JRUN-MS Access connection question
> We are using JRUN 2.3.3 and are trying to connect to a Microsoft Access
> Database. We are using Java 1.2 and Windows NT 4.0. We have tried:
>
> Class.forName ("sun.jdbc.odbc.JdbcOdbcDriver");
> Connection con =
DriverManager.getConnection( "jdbc:odbc:WadeTest" );
>
> If we just retrieve data, everything seems fine. If we update, or insert,
> Dr. Watson is called about every 3d time, and JRUN dies. We had similar
> problems with Oracle until we used their JDBC driver. A discussion on
> Alliare's site indicated that the JDBC:ODBC driver was not thread safe and
> that would be problematic with Servlets.
>
> http://www.allaire.com/Handlers/index.cfm?ID=12409&Method=Full
>
> http://java.sun.com/products/jdbc/faq.html#20
>
>
> Is there an alternative driver that works with MS Access. We could switch
> to the MS Java, and the problem would go away, but we also kiss off
> portability. (Not a good choice as we are using 1.2 features.) I once
> thought there was nothing I should be able to do to crash Java, but I was
> wrong. Am I really the only person having this problem? Any help or
> guidance would be appreciated.
>
> Greg
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> FAQs on JSP can be found at:
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
