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]