You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Vladimer Shioshvili <vs...@qrc.com> on 2003/05/09 00:22:41 UTC
sqlserver jdbc driver
any suggestions on what to use?
thanks,
Vlad
________________
Vladimer Shioshvili
QRC Division of Macro International Inc.
7315 Wisconsin Avenue, Suite 400W
Bethesda, MD 20814
Phone: (301) 657 3077 ext. 155
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: sqlserver jdbc driver
Posted by Jason Bainbridge <ja...@jblinux.org>.
http://jtds.sourceforge.net
A much better solution than MS's driver, we have started using it with our web
application and are quite pleased with the results so I would highly
recommend it.
Regards,
Jason
On Fri, 9 May 2003 10:41 pm, John Turner wrote:
> Microsoft's driver is old and has fairly picky support, especially for
> older versions of SQL Server. We had problems with it, as well, such as no
> support for CachedRowSet (critical in our apps) and other stuff.
>
> I would recommend a third-party driver, the cost is only a couple hundred
> dollars for all but the largest environments. I also seem to remember that
> there was a freeware or open source driver that was getting good reviews, I
> think it was mainly for Sybase but the protocol for SQL Server is
> compatible. Sourceforge or freshmeat would probably have it.
>
> John
>
> On Thu, 8 May 2003 16:16:57 -0700, Dick Brooks <di...@tech-comm.com> wrote:
> > Vlad,
> >
> > I've successfully used Microsoft's JDBC driver and JSQLConnect from Net
> > Direct (http://www.j-netdirect.com/JSQLConnect/JSQLvsMicrosoftJDBC.html)
> > to access SQL Server 2000 as a JNDI resource under Tomcat 4.1.24
> >
> > Personally, I like the debugging features of JSQLConnect. However
> > it does cost $ whereas Microsoft's driver is free.
> >
> > Regards,
> >
> > Dick Brooks
> > Independent Consultant B2B Integration and Cyber Security
> > Mobile:602-684-1484
> > eFax:240-352-0714
> >
> >
> > -----Original Message-----
> > From: Vladimer Shioshvili [mailto:vshioshvili@qrc.com]
> > Sent: Thursday, May 08, 2003 3:23 PM
> > To: Tomcat Users List
> > Subject: sqlserver jdbc driver
> >
> >
> >
> > any suggestions on what to use?
> >
> >
> > thanks,
> > Vlad
> >
> >
> > ________________
> > Vladimer Shioshvili
> >
> > QRC Division of Macro International Inc.
> > 7315 Wisconsin Avenue, Suite 400W
> > Bethesda, MD 20814
> >
> > Phone: (301) 657 3077 ext. 155
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
--
Jason Bainbridge
KDE Web Team - http://kde.org
webmaster@kde.org
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
Re: sqlserver jdbc driver
Posted by John Turner <to...@johnturner.com>.
Microsoft's driver is old and has fairly picky support, especially for
older versions of SQL Server. We had problems with it, as well, such as no
support for CachedRowSet (critical in our apps) and other stuff.
I would recommend a third-party driver, the cost is only a couple hundred
dollars for all but the largest environments. I also seem to remember that
there was a freeware or open source driver that was getting good reviews, I
think it was mainly for Sybase but the protocol for SQL Server is
compatible. Sourceforge or freshmeat would probably have it.
John
On Thu, 8 May 2003 16:16:57 -0700, Dick Brooks <di...@tech-comm.com> wrote:
> Vlad,
>
> I've successfully used Microsoft's JDBC driver and JSQLConnect from Net
> Direct (http://www.j-netdirect.com/JSQLConnect/JSQLvsMicrosoftJDBC.html)
> to access SQL Server 2000 as a JNDI resource under Tomcat 4.1.24
>
> Personally, I like the debugging features of JSQLConnect. However
> it does cost $ whereas Microsoft's driver is free.
>
> Regards,
>
> Dick Brooks
> Independent Consultant B2B Integration and Cyber Security
> Mobile:602-684-1484
> eFax:240-352-0714
>
>
> -----Original Message-----
> From: Vladimer Shioshvili [mailto:vshioshvili@qrc.com]
> Sent: Thursday, May 08, 2003 3:23 PM
> To: Tomcat Users List
> Subject: sqlserver jdbc driver
>
>
>
> any suggestions on what to use?
>
>
> thanks,
> Vlad
>
>
> ________________
> Vladimer Shioshvili
>
> QRC Division of Macro International Inc.
> 7315 Wisconsin Avenue, Suite 400W
> Bethesda, MD 20814
>
> Phone: (301) 657 3077 ext. 155
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
>
>
--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
RE: sqlserver jdbc driver
Posted by Dick Brooks <di...@tech-comm.com>.
Vlad,
I've successfully used Microsoft's JDBC driver and
JSQLConnect from Net Direct
(http://www.j-netdirect.com/JSQLConnect/JSQLvsMicrosoftJDBC.html)
to access SQL Server 2000 as a JNDI resource under Tomcat 4.1.24
Personally, I like the debugging features of JSQLConnect. However
it does cost $ whereas Microsoft's driver is free.
Regards,
Dick Brooks
Independent Consultant
B2B Integration and Cyber Security
Mobile:602-684-1484
eFax:240-352-0714
-----Original Message-----
From: Vladimer Shioshvili [mailto:vshioshvili@qrc.com]
Sent: Thursday, May 08, 2003 3:23 PM
To: Tomcat Users List
Subject: sqlserver jdbc driver
any suggestions on what to use?
thanks,
Vlad
________________
Vladimer Shioshvili
QRC Division of Macro International Inc.
7315 Wisconsin Avenue, Suite 400W
Bethesda, MD 20814
Phone: (301) 657 3077 ext. 155
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org