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
