On Fri, 27 Apr 2001, Jerry Asher wrote:
> So that's an interesting rumor I've also heard once or twice.
>
> What's the scoop, has anyone gotten the sybase driver to work with a recent
> version of SQL Server? If so, what does it entail (esp. on Linux). What
> sorts of libraries might we need?
I can tell you from personal experience that it *DID* work with SQL Server
6.5 becuase I setup an AOLserver process running on Linux that accessed
the ERP system of the company I worked for at the time. From discussions
with a consultant-type DBA we had coming in for our ERP system I learned
that both SQL Server and Sybase both use TDS or Tabular Data Stream, which
is the protocol used by both Sybase and Microsoft.
In SQL Server 7, Microsoft made changes to the TDS protocol which made it
not work reliable with clients written to work with earler versions of the
protocol.
I don't know if the nssybase driver could be made to use FreeTDS (a free
implementation of the TDS layer which can be found at
http://www.freetds.org), but if so I believe it would work with newer
versions of MS SQL Server.
--
Louis Zirkel III ([EMAIL PROTECTED]) System Admin/Programmer
"We're living on the Edge of the Century" -- Styx
