Forum OpenACS Q&A: Offtopic: MS SQL Server access from AOLServer

Collapse
1: Offtopic: MS SQL Server access from AOLServer
Posted by Vlad Seryakov on 05/13/02 07:04 PM
Hello,
May be interesting to somebody who is planning to work with SQL Server
from aolserver. We use nsfreetds driver by mailto:dossy@panoptic.com for
several month already without any problems. I made some modifications
to the driver and submitted them to the author.
We use TDS 7.0 protocol and work with SQL Server 2000.

Driver can be found is at http://www.panoptic.com/ in Projects section.

Collapse
2: Response to Offtopic: MS SQL Server access from AOLServer (response to 1)
Posted by John Sequeira on 05/14/02 12:58 PM
Thanks Vlad - this rules.  I've been keeping my fingers crossed for exactly this post.  The FAQ mentions some difficulties with stored procedure support.  Has this been a problem for you at all?

Aside:  I was glad to see the freetds web site come out of hibernation recently.  I didn't think they'd manage MSSQL2000 support.

Collapse
3: Response to Offtopic: MS SQL Server access from AOLServer (response to 1)
Posted by Vlad Seryakov on 05/14/02 04:38 PM
We did not use ns_db sp_ extensions, just queries and stored procedures that return result sets.