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