Wow! Thanks for the plethora of responses everyone. Looks like most of the people that responded seem to like jTDS. I will look further into that one and hope for the best.
Thanks again everyone. Charles -----Original Message----- From: Al Gidden [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 23, 2004 4:34 PM To: Tomcat Users List Subject: Re: JDBC We use jTds drivers. They are available on sourceforge I think. We tried the 'free' Microsoft JDBC driver as well. There is information to support that jTds is the faster of the two. On SQLServer 2000 we float about 1000 total connections between three DBCP pools using jTds and the DB just rips along fine. jTds has config options to work for SQL7 or SQL2000. Like any JDBC implementation, make sure you are careful with database connections in your code - bad code can prevent anything from scaling well. Al G ----- Original Message ----- From: "Charles P. Killmer" <[EMAIL PROTECTED]> Date: Tuesday, November 23, 2004 4:13 pm Subject: JDBC > Looking for concensus on how people, with much more experience than I > have, use to connect to SQL Server 7. I have been planning on using > Datadirect's JDBC Connect until I saw the price tag for a server. > > So with that does any body have a preferred JDBC connector to SQL > Server7? > > Any help is greatly appreciated. > Thanks > Charles > > ------------------------------------------------------------------- > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
