jdbc odbc bridge on linux

[Jerry QU <jq...@baijia.com>]

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!!

TIA

Jerry

  
 

Re: jdbc odbc bridge on linux

["Nils O. Selåsdal" <no...@frisurf.no>]

On Sunday 29 July 2001 01:12 am, you wrote:

> 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
> www.inetsoftware.de.
Take a look at www.freetds.org


-- 
Nils O. Selåsdal

Re: jdbc odbc bridge on linux

[Jim Seach <jw...@yahoo.com>]

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

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
www.inetsoftware.de.

Hope this helps,

Jim
--- Jerry QU <jq...@baijia.com> 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!!
> 
> TIA
> 
> Jerry
> 
>   
>  
> 


__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/