Skip Menu | will be shut down on March 1st, 2021.

This queue is for tickets about the DBD-ODBC CPAN distribution.

Report information
The Basics
Id: 128000
Status: new
Priority: 0/

Owner: Nobody in particular
Requestors: Michael.OKeefe [...]

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

Subject: causes truncating ODBC filenames for Paradox
Date: Wed, 12 Dec 2018 12:12:01 -0800
To: bug-DBD-ODBC [...]
From: Michael O'Keefe <Michael.OKeefe [...]>
Download (untitled) / with headers
text/plain 916b
ActiveState Perl 5.24 on a 32-bit Windows where System DSN "DSN_Name" is a Paradox 5.x database. test program : use strict; use DBI; my $odbc = DBI->connect(q(dbi:ODBC:DSN=DSN_Name),q(),q()); my $sql = q{SELECT COUNT(*) AS Result FROM LongNameDatabase}; my $query = $odbc->prepare($sql); $query->execute(); while (my $result = $query->fetchrow_hashref()) { warn($result->{Result}); } $query->finish(); $odbc->disconnect(); If I add a module that uses Storable (like LWP::UserAgent) then I can see (using procmon.exe for example) that the table filename gets truncated to "LongName.DB". I can "stop" it with : $INC{q(} = 1; require LWP::UserAgent; If I "hack" to not call : XSLoader::load('Storable', $Storable::VERSION); then it has the same "workaround" So something in Storable's XS DLL is causing DBD-ODBC to truncate it's filename access to the filesystem to 8.3 filenames

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to