tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ramon Buckland <>
Subject RE: jdbc odbc bridge on linux
Date Sun, 29 Jul 2001 10:47:11 GMT

Here is a free JDBC Driver for MSSQL 7.0

It is based on FreeTDS from which also has
it's own JDBC Driver. I don't know what differences they hold.

I wouldn't say it is production quality. But it does do simple
SELECT's etc. We have a few problems with it and thus use
a commercial version also.


- Ramon

-----Original Message-----
From: Jim Seach []
Sent: Sunday, 29 July 2001 10:12 AM
Subject: Re: jdbc odbc bridge on linux

The jdbc odbc bridge requires an odbc driver on the
local machine.  The local datasource then points to
the remote machine that the server is on, rather than
the JDBC URL.  The jdbc odbc driver is also not
multi-threaded, so not a good choice for using with

I'm not aware of any free jdbc drivers that will work
with SQL Server, but there are a number of commercial
solutions.  I use the OPTA 2000 driver from

Hope this helps,

--- Jerry QU <> wrote:
> Hi All,
> I posted question about how to use Sun's jdbc.odbc
> bridge from jsp on linux to access SQL server on
> windows. because all examples I saw were using LOCAL
> dsn like jdbc:odbc:dsnName. but how to do it if the
> JSP is on linux and the SQL server is on a remote
> host.
> something like jdbc:odbc:@host:port:DB_name(or
> DSN)???
> I am kind of confused!!
> Jerry

Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger

View raw message