Re: Patch for MS SQL Server 2000 via ODBC

Kevin Rosenberg <kevin-HJRc7zDS/[email protected]> Tue, 8 Nov 2005 17:45:42 -0700
Newsgroups gmane.lisp.clsql.devel
Message-ID <[email protected]>
lisp wrote:
> Thanks for the feedback.  There should be no problem moving the code
> into the generic odbc driver.  I went with the seperate backend
> initially as this seemed to be the pattern. I'll put together an updated
> patch for you to take a look at as soon as I get the time.

Very good, Dominic. In general, the difference backends encode a
different API for interacting with the backend. If your patch used
freetds, for instance, to communicate with MSSQL, that should go in
its own backend.

While ODBC is great to have a middle layer for divergent
databases. Compared to the other backends, it has quite a few run-time
specializations since different SQL engines give slightly different
results thought the same ODBC API.

> I've just tracked down a nasty little bug in the ODBC code that reads
> data in chunks - I'll post this as well.

That'll be great. I haven't used the ODBC backend since I finished
coding and debugging it.

-- 
Kevin Rosenberg
kevin-HJRc7zDS/[email protected]