On 2004.04.26, Tom Jackson <[EMAIL PROTECTED]> wrote: > On Mon, 2004-04-26 at 09:41, Dossy wrote: > > > It is? What does the nsunixodbc module do that nsodbc currently > > doesn't, *other* than the newly implemented support for turning off > > autocommit and explicit ending of transactions with COMMIT or ROLLBACK. > > I think both nssolid and nsodbc use the older odbc2 API, the "unixodbc" > module now has support for compiling either odbc2 or odbc3 API's, also, > Bob Woodside, who added the 2/3 options noted the following: > > ------------- > 1) It supports more ns_ functions (DbFn_DbType, DbFn_Select, > DbFn_DML) than nsodbc, and lacks none that nsodbc has.
Frankly, you should really only implement DbFn_Exec which should be capable of doing DbFn_Select and DbFn_DML -- the entire DB API is pretty silly. > 2) It has more informative logging. Interesting. I'll have to take a look at exactly what this means. > 3) I've tested it with both unixODBC and iODBC (libiodbc), and > feel comfortable that it works well. (I haven't tried the > DbFn_DML function yet, though.) I haven't tested my changes to nsodbc against iODBC but I can definitely say that it works with the latest unixODBC. > 4) I've already made an ODBC3 version based on it (actually, it > will conditionally build to use either the ODBC2 or ODBC3 API). Ah, yes -- ODBC v3 could be a good thing. If you've already made the necessary changes to conditionally build either v2 or v3, merging those changes back into nsodbc is probably easy enough. > Also, Bob and you (and now I) agree there should be one version in the > end for both platforms. However, the ODBC support is still very thin > even in the "unixodbc" module. I am going to commit myself to getting > this to work under windows when the time comes. I'm pretty confident that it won't be much work to get nsodbc to build on Win32 against Microsoft's ODBC manager. I'm personally in favor of keeping the ODBC driver module named "nsodbc" even if it means merging in all the changes you've made to the nsunixodbc and retiring it. Unless you have real attachment to keeping the module named "nsunixodbc" ... lets identify the things that are implemented in nsunixodbc which you feel should stay and we'll merge those changes into nsodbc and bring it up to date. I can work on the Win32 build part as well. -- Dossy -- Dossy Shiobara mail: [EMAIL PROTECTED] Panoptic Computer Network web: http://www.panoptic.com/ "He realized the fastest way to change is to laugh at your own folly -- then you can let go and quickly move on." (p. 70) -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
