On Mon, 26 Apr 2004 14:31:56 -0400
Dossy <[EMAIL PROTECTED]> wrote:
> > -------------
> > 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.
Yes. I seem to recall some comments a while back (they may have
been from you) that the whole ns_db API is showing its age and could
stand some revamping. I only mentioned Select and DML since the API
supports them, but I see no advantage to having them in the API in the
first place. (In your next post you enlightened me even further about
this.) I'm guessing that Select maybe dates from a time before Exec
could return a result set, and I don't know why DML might have been
thought necessary.
> > 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.
If it does, then it should probably work with iODBC too. When I
launched into this project, nsodbc wouldn't compile, and I didn't look
any further into it. I later found that the problem was a missing
incoude for nsdb.h. But by that time, I'd been working with Tom's
module, and after comparing the two, I decided that his looked like a
cleaner code base.
> I'm pretty confident that it won't be much work to get nsodbc to build
> on Win32 against Microsoft's ODBC manager.
I think this should be true of either module, I just haven't had time
lately to look into it.
> 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.
I don't think either of us wanted to retain the nsunixodbc name once
we had a module that worked with all the known driver managers. I think
nsodbc is a fine name for whatever we finally come up with.
--
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.