On Jun 3, 2011, at 9:58 PM, <eric.b...@barclayscapital.com>
<eric.b...@barclayscapital.com> wrote:
> Thanks, John.
>
> If anyone can comment with authority on the lack of intraspection
> capabilities in DBD::Sybase, that'd be helpful. I looked through the code as
> well, and didn't find anything to say one way or another. Get_info() appears
> to be relatively new to DBI, and it look slike there is some facility to
> generate the code required to populate get_info() for your DBD's, but nothing
> that says one way or another if there is actually any way to get info form
> the driver.
>
> Hoping someone can help here. We are currently running DBD::Sybase for
> Sybase and moving toward using DBD::ODBC for MSSQL instead of using FreeTDS
> under DBD::Sybase for MS SQL. IN any case, it would be particularly helpful
> if we could ask the driver object what type of DB it's a connection handle to.
There are a couple of things you could try - maybe see if any of the
private/driver specific methods are available.
Or something like $dbh->{syb_oc_version}, which if it returns something will at
least identify the driver handle as being a DBD::Sybase handle using Sybase
OpenClient. If you are using DBD::Sybase with FreeTDS then you may need to use
another private attribute, maybe something like
defined($dbh->{syb_dyn_supported}).
Michael
--
Michael Peppler
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
"A successful [software] tool is one that was used to do something undreamed of
by its author." -- S. C. Johnson
