Hi,
I hope this is the right place for this - apologies if not.
Does anyone have any experience of using DBI:ODBC with a Faircom db? I can't find
anything in the faq or the archive.
My problem is that $dbh->tables() is truncating the tablenames to 64 characters.
I've tested against a MSSQLServer, and it returns the whole name even if it's more
than 64 chars, so I don't think the
problem is in DBI or DBD::ODBC.
It's not a problem with LongReadLen either (I don't think), because
(a) if LongTruncOk is false, $dbh->tables() will truncate without generating an error
(b) Even if LongReadLen is set huge (e.g. 500000), it still truncates.
What is strange, is that it's unlikely to be a problem with the Faircom ODBC driver
either, as if I do a "Select * from
CTSYSCAT_TABLES" (using dbi:odbc) then it returns the full names.
Any pointers would be most appreciated,
Andy
=========
Activestate perl 5.8.0.806
DBI v1.38
DBD-ODBC v1.06
Win2K
=========
##Following truncates table names to 64 chars without causing an error
my $dbh = DBI->connect( 'dbi:ODBC:FaircomDriver', 'user', 'pass', { LongTruncOk=>False
});
my @tables = $dbh->tables();
foreach (@tables){print "$_ \n";}
##Following connection returns full table names, even if over 64 chars
my $dbh = DBI->connect( 'dbi:ODBC:SQLServerBob', 'user', 'pass');
