Todd,
>From the dbdimp.c source code it looks like you set the odbc_version attribute
of DBD::ODBC (at least in 1.05 it is).
>From the docs:
odbc_version
This was added prior to the move to ODBC 3.x to allow
the caller to "force" ODBC 3.0 compatibility. It's
probably not as useful now, but it allowed get_info
and get_type_info to return correct/updated
information that ODBC 2.x didn't permit/provide.
but as far as I can see if you set it to 2 it will call SQLSetEnvAttr for ODBC
2.
Martin
--
Martin J. Evans
Easysoft Ltd, UK
Development
On 16-Jun-2003 Todd Morrey wrote:
> 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
