The free JDBC-ODBC driver is evil. Sun's free JDBC-ODBC driver [written
by/with Merant if memory serves] isn't a great driver. It has poor
performance and other issues with threading for instance. www.merant.com and
www.EasySoft.com both offer substantially better JDBC-ODBC drivers. They are
very good indeed. They are Type 3 drivers since they can't be 100% Java
unless someone decided to re-write ODBC in Java (a *very* pointless task
IMO). One benefit of ODBC is that the ODBC layer can handle connection
pooling /transaction enlistment transparently using native Windows services.
If you *prefer* an ODBC-JDBC solution, this is the way to go. If not, then a
Type 4 driver is the way forward. The only time I would recommend Sun's
JDBC-ODBC driver if for basic development or while you are awaiting delivery
of your new driver ;-)
As for free MS SQL Drivers, the only one I am aware of is FreeTDS and is
listed in Kunle's HowTo. I wouldn't rely on Sybase drivers, the protocols
began to diverge quite a while ago and certainly for SQL7 and SQL2000, a
Sybase product would not be ideal.
See http://www.jboss.org/documentation/HTML/ch10s22.html
Cheers!
Micheal
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Peter
> Routtier-Wone
> Sent: 30 March 2001 07:00
> To: [EMAIL PROTECTED]
> Subject: Re: [JBoss-user] MS SQL7 JDBC-ODBC parameters
>
>
> ODBC is evil.
>
> There is more than one free pure Java JDBC driver for TDS (the M$
> and Sybase
> protocol).
>
> Search the net for TDS near JDBC.
>
> ----- Original Message -----
> From: Steve Shier
> To: '[EMAIL PROTECTED]'
> Sent: Tuesday, March 27, 2001 8:05 PM
> Subject: [JBoss-user] MS SQL7 JDBC-ODBC parameters
>
>
> I want to use the JDBC-ODBC bridge to a Microsoft SQL 7.0 database and
>
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
