I might be getting off-topic here, but do you have any recommendations for
alternatives to access MS-Access databases via JDBC? I think that I am going
to use i-net Software's JDBC driver for SQL Server, but I might still need a
driver for MS-Access (or ODBC in general) if the JDBC-ODBC bridge does not
work out.
-Mirko
> -----Original Message-----
> From: A mailing list about Java Server Pages specification and reference
> [mailto:[EMAIL PROTECTED]]On Behalf Of brian
> Sent: Tuesday, December 14, 1999 1:49 PM
> To: [EMAIL PROTECTED]
> Subject: Re: ODBC and JSP
>
>
> the jdbc-odbc bridge should be avoided, especially from servlets
> (and therefore
> jsp), as it is not threadsafe.
> -bml
>
> Mirko Froehlich wrote:
>
> > I am just fighting with a similar issue, although not (yet)
> from JSP, but
> > from a Java application. You cannot directly access ODBC data
> sources from
> > Java, but there are a couple of options that all involve JDBC.
> One of them
> > is the JDBC-ODBC bridge, which allows you to access ODBC data
> sources via
> > JDBC. Unfortunately, this is (according to Sun) experimental,
> and in fact
> > JDK 1.2.2 has some major problems. I was unable to get this
> working with SQL
> > Server, although I was able to successfully access an MS Access
> database via
> > JDBC-ODBC. There are some third-party drivers, for example a native JDBC
> > driver for SQL Server (from http://www.inetsoftware.de/), which seems to
> > work fine. I believe there are also third-party JDBC-ODBC
> bridges that might
> > be more robust. Sun has a nice list of JDBC drivers at this URL:
> > http://java.sun.com/products/jdbc/drivers.html
> >
> > -Mirko
> >
> > > -----Original Message-----
> > > From: A mailing list about Java Server Pages specification
> and reference
> > > [mailto:[EMAIL PROTECTED]]On Behalf Of Jeff Brown
> > > Sent: Tuesday, December 14, 1999 11:30 AM
> > > To: [EMAIL PROTECTED]
> > > Subject: ODBC and JSP
> > >
> > >
> > > Let me start by saying that I'm new to the whole JSP game. I'm an
> > > ActiveServerPage developer that needs to port all of my ASP's
> to JSP's for
> > > the next release of a product I'm working on.
> > >
> > > What I need to do is open a connection to an ODBC source (in this
> > > case a SQL
> > > 7.0 Database) and run simple SQL calls against it. The code I
> > > would use in
> > > an ASP is:
> > >
> > > Set Conn = Server.CreateObject("ADODB.Connection")
> > > Conn.Open "dsn=SQLCharDB;uid=sa;pwd="
> > >
> > > First of all, I need to figure out how to set up an ODBC
> connection to my
> > > SQL DB on a Solaris 7 box. Then I need to learn the correct
> syntax for
> > > opening a connection to said ODBC from inside my JSP's.
> Currently the web
> > > server I'm using is Netscape Enterprise 4.0, but I'll
> eventually be using
> > > Apache as well.
> > >
> > > Any information would be greatly appreciated.
> > >
> > >
> > > Jeffrey W. Brown
> > > Test Engineer
> > > Citr!x Systems, Inc.
> > > PHONE: (954) 267-2846
> > > EMAIL: jeff.brown @ citrix.com
> > >
> > > ==================================================================
> > > =========
> > > 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
>
> --
>
>
> Brian M. Long
> RandomWalk Computing, Inc.
> [EMAIL PROTECTED]
> 212.480.5280 x276
>
> ==================================================================
> =========
> 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
