I've been beating my head against my monitor trying to figure out how to force ODBC version 2.0 behavior instead of 3.0 in DBD::ODBC. I've gone through the man pages, all the online docs that I can find, searched through the archives of this mailing list... I guess it's not a common tweak.
Apparently my ODBC server doesn't support version 3 behavior. This is a proprietary database, Navision Financials using its C/ODBC driver. PHP ODBC is working, and through debugging the only difference I can spot is that the PHP connections are coming across as an ODBC 2 connection. If anybody knows how to do this, I'd be psyched to hear about it. I am using Perl 5.8.0, DBI 1.30, and DBD::ODBC 1.05. Thanks, Todd
