Tim Bunce wrote:
On Sun, Mar 23, 2008 at 12:49:22PM -0700, Dean Arnold wrote:
I've finally have a reason to write an ODBC wrapper around
Perl/DBI (not DBD::ODBC, but the other way around).
Strange what some people have to do for a living! :)
Do you mean a Perl-level wrapper (ala Win32::ODBC API)
or a C-level ODBC emulation?
If the former, then the Win32::DBIODBC hack may be s start:
http://search.cpan.org/src/TIMB/DBI-1.603/lib/Win32/DBIODBC.pm
If the later then I suspect you're in for a bumpy ride.
Grafting DBI into the guts of an exiting open source ODBC driver
may be the best approach here.
Its the latter. I've found a decent resource from an old DDJ
article to bootstrap things. I've already built a couple embedded
Perl projects, so much of the process will hopefully be
cut/paste code. The hard part will be finding DBD's that provide
sufficient metadata at the right steps in the process...esp. the sort
of DBDs I'm trying to support (eg, DBD::Amazon, DBD::iPod, DBIx::Chart,
maybe even DBD::Gofer ?)
But I'm having no luck finding the formal ODBC 3.5 spec.
It appears our friends in Redmond have deep-6'd it from
their websites, and a lengthy googling session
hasn't surfaced anything.
Anyone know where the spec might be hiding ?
archive.org may help.
Last clue I had was some MSDN CD circa 2000.
Sounds plausible. You may be able to find a copy of the "ODBC 3.5
Developers Guide" book by Roger Sanders (pub Mc Graw Hill).
Have fun!
Tim.
Thanks for the pointers,
Dean
