RE: [JBoss-user] MS SQL7 JDBC-ODBC parameters
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
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
Re: [JBoss-user] MS SQL7 JDBC-ODBC parameters
Here is a doc page on SQL Server: http://www.jboss.org/documentation/mssql.htm Plus you need to add a jaws.xml file that is similar to this: java:/SQLServerPool MS SQLSERVER false MS SQLSERVER --- Brenton House Java Software Engineer Pixel Magic Imaging, Inc. - Original Message - From: "Steve Shier" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 27, 2001 4:05 AM Subject: [JBoss-user] MS SQL7 JDBC-ODBC parameters I want to use the JDBC-ODBC bridge to a Microsoft SQL 7.0 database and would like to know the configuration parameters. They are listed in the manual only for MS Access (see http://www.jboss.org/documentation/HTML/ch03s05.html) and shown here below-which of these MS Access parameters needs to be changed for MSSQL7 and to what values? MS Access Configuration: 1. jboss.properties jdbc.drivers=sun.jdbc.odbc.JdbcOdbcDriver 2. jboss.conf 3. jboss.jcml jdbc:odbc:ODBC datasource name Is there anything else that needs to be done/avoided, such as in the mappings in the jaws.xml file? I am using JDK 1.3 and JBoss 2.0 on WinNT 4.0 Server SP6a . TIA, Steve Shier ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
RE: [JBoss-user] MS SQL7 JDBC-ODBC parameters
See Anthony & Kunle's SQl Server HOWTO on the site: http://www.jboss.org/documentation/mssql.htm Micheal > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Steve Shier > Sent: 27 March 2001 11:06 > I want to use the JDBC-ODBC bridge to a Microsoft SQL 7.0 database and > would like to know the configuration parameters. They are listed in > the manual only for MS Access (see ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
[JBoss-user] MS SQL7 JDBC-ODBC parameters
I want to use the JDBC-ODBC bridge to a Microsoft SQL 7.0 database and would like to know the configuration parameters. They are listed in the manual only for MS Access (see http://www.jboss.org/documentation/HTML/ch03s05.html) and shown here below-which of these MS Access parameters needs to be changed for MSSQL7 and to what values? MS Access Configuration: 1. jboss.properties jdbc.drivers=sun.jdbc.odbc.JdbcOdbcDriver 2. jboss.conf 3. jboss.jcml jdbc:odbc:ODBC datasource name Is there anything else that needs to be done/avoided, such as in the mappings in the jaws.xml file? I am using JDK 1.3 and JBoss 2.0 on WinNT 4.0 Server SP6a . TIA, Steve Shier ___ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user