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

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

Report information
The Basics
Id: 111666
Status: resolved
Priority: 0/
Queue: DBD-ODBC

People
Owner: Nobody in particular
Requestors: mts [...] ansto.gov.au
Cc:
AdminCc:

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



MIME-Version: 1.0
X-Protective-Marking: VER=2012.3, NS=gov.au, SEC=UNCLASSIFIED, ORIGIN=mts [...] ansto.gov.au
X-Spam-Flag: NO
X-Virus-Checked: Checked
Content-Type: multipart/alternative; boundary="_000_0E5BB4F945105948AF5D21EE077891F101AD9E44EXMBS2B51anstog_"
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Spam-Score: -4.2
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 42353240389 for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Tue, 2 Feb 2016 01:31:25 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id o9cbD84pWYo8 for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Tue, 2 Feb 2016 01:31:23 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 960A32400C1 for <bug-DBD-ODBC [...] rt.cpan.org>; Tue, 2 Feb 2016 01:31:22 -0500 (EST)
Received: (qmail 30901 invoked by alias); 2 Feb 2016 06:31:21 -0000
Received: from ironport1.ansto.gov.au (HELO ironport1.ansto.gov.au) (137.157.2.13) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Mon, 01 Feb 2016 22:30:56 -0800
Received: from emailgw2.ansto.gov.au ([137.157.2.5]) by ironport1.ansto.gov.au with ESMTP; 02 Feb 2016 17:30:46 +1100
Received: from exchange.ansto.gov.au (exch1-b51-nlb.ansto.gov.au [137.157.12.51]) by emailgw2.ansto.gov.au (8.13.8+Sun/8.13.8) with ESMTP id u126UhQ0015299 for <bug-DBD-ODBC [...] rt.cpan.org>; Tue, 2 Feb 2016 17:30:46 +1100 (EST)
Received: from EXMBS2-B51.ansto.gov.au ([169.254.2.17]) by EXCH1-B51.ansto.gov.au ([137.157.12.50]) with mapi id 14.01.0289.001; Tue, 2 Feb 2016 17:30:43 +1100
Delivered-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
Subject: DBI - Access OBDC bug [SEC=UNCLASSIFIED]
Thread-Index: AdFdgz0w5TH/VwXgSj2pX8sUUPz6Sw==
X-Spam-Check-BY: la.mx.develooper.com
Date: Tue, 2 Feb 2016 06:30:42 +0000
X-Spam-Level:
To: "bug-DBD-ODBC [...] rt.cpan.org" <bug-DBD-ODBC [...] rt.cpan.org>
X-Spam-Status: No, score=-4.2 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_MED=-2.3, RP_MATCHES_RCVD=-0.001] autolearn=ham
X-Ansto-PM-Filtering: accepted by emailgw2.ansto.gov.au; message from <mts [...] ansto.gov.au> (exch1-b51-nlb.ansto.gov.au [137.157.12.51]); Tue, 02 Feb 2016 17:30:46 +1100 [1454394646] auth=407a0376b3adcb6da7f719c48ec20184799bf6f6
X-Janusnet-Dialogconfirmed: True
X-Ansto-Senderip: 137.157.12.51
Received-SPF: Pass (ironport1.ansto.gov.au: domain of mts [...] ansto.gov.au designates 137.157.2.5 as permitted sender) identity=mailfrom; client-ip=137.157.2.5; receiver=ironport1.ansto.gov.au; envelope-from="mts [...] ansto.gov.au"; x-sender="mts [...] ansto.gov.au"; x-conformance=spf_only; x-record-type="v=spf1"
Received-SPF: None (ironport1.ansto.gov.au: no sender authenticity information available from domain of postmaster [...] emailgw2.ansto.gov.au) identity=helo; client-ip=137.157.2.5; receiver=ironport1.ansto.gov.au; envelope-from="mts [...] ansto.gov.au"; x-sender="postmaster [...] emailgw2.ansto.gov.au"; x-conformance=spf_only
Content-Language: en-US
Message-ID: <0E5BB4F945105948AF5D21EE077891F101AD9E44 [...] EXMBS2-B51.ansto.gov.au>
X-MS-Tnef-Correlator:
X-Classifier: janusSEAL for Outlook 2.6.2
Return-Path: <mts [...] ansto.gov.au>
X-Original-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
X-RT-Mail-Extension: dbd-odbc
Thread-Topic: DBI - Access OBDC bug [SEC=UNCLASSIFIED]
X-MS-Has-Attach:
X-Originating-Ip: [137.157.126.44]
Accept-Language: en-AU, en-US
From: "SALE, Matthew" <mts [...] ansto.gov.au>
X-RT-Interface: Email
Content-Length: 0
content-type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: ascii
Content-Length: 1011
Download (untitled) / with headers
text/plain 1011b
Good Day I have been doing some work with DBI/OBDC/ACCESS 2010 Unfortunately, some of the time when I ask for my data it ends up corrupted. For example, the following code produces corruption... #!perl use strict; use warnings; use DBI; use Data::Dumper; my $dbh = DBI->connect('dbi:ODBC:Test'); my $sqlstatementExisting = " SELECT * FROM Table1 "; my $sth = $dbh->prepare($sqlstatementExisting); $sth->execute # ([$name]) || die "Could not execute SQL statement ... maybe invalid? ".$dbh->errstr; while (my @row = $sth->fetchrow_array) { print Dumper (@row); } This produces the following result... $VAR1 = 1; $VAR2 = 'E-6'; However, the data stored in the database is as follows... Table1 ID Field1 1 8.93601020357839E-06 For some reason, my data is being truncated to just the exponent values and text. I am unsure how to fix this as it appears to be a bug in either the perl modules or hopefully not in the OBDC or ACCESS part of the code. Matt
content-type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: ascii
Content-Length: 7116
MIME-Version: 1.0
In-Reply-To: <0E5BB4F945105948AF5D21EE077891F101AD9E44 [...] EXMBS2-B51.ansto.gov.au>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <0E5BB4F945105948AF5D21EE077891F101AD9E44 [...] EXMBS2-B51.ansto.gov.au>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-20175-1454410668-1374.111666-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 1461
Download (untitled) / with headers
text/plain 1.4k
On Tue Feb 02 01:31:26 2016, mts@ansto.gov.au wrote: Show quoted text
> Good Day > > I have been doing some work with DBI/OBDC/ACCESS 2010 > Unfortunately, some of the time when I ask for my data it ends up > corrupted. > > For example, the following code produces corruption... > > #!perl > use strict; > use warnings; > use DBI; > use Data::Dumper; > > my $dbh = DBI->connect('dbi:ODBC:Test'); > > my $sqlstatementExisting = " > SELECT * > FROM Table1 > "; > > my $sth = $dbh->prepare($sqlstatementExisting); > $sth->execute # ([$name]) > || die "Could not execute SQL statement ... > maybe invalid? ".$dbh->errstr; > > while (my @row = $sth->fetchrow_array) { > print Dumper (@row); > } > > > This produces the following result... > $VAR1 = 1; > $VAR2 = 'E-6'; > > However, the data stored in the database is as follows... > Table1 > > ID > > Field1 > > 1 > > 8.93601020357839E-06 > > > > For some reason, my data is being truncated to just the exponent > values and text. > I am unsure how to fix this as it appears to be a bug in either the > perl modules or hopefully not in the OBDC or ACCESS part of the code. > > > Matt
Hi Matt, What versions of Perl, DBI and DBD::ODBC are you using? What is the access column type for Field1? I'm presuming you are running on Windows? Could you do this: set DBI_TRACE=15=x.log perl myprogram.pl then send me what is in x.log. Martin -- Martin J. Evans Wetherby, UK
X-Protective-Marking: VER=2012.3, NS=gov.au, SEC=UNCLASSIFIED, ORIGIN=mts [...] ansto.gov.au
MIME-Version: 1.0
X-Spam-Flag: NO
X-Virus-Checked: Checked
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
content-type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8
X-Spam-Score: -4.201
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 303E924034F for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Tue, 2 Feb 2016 20:03:55 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id O4Pk0-MRkjEF for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Tue, 2 Feb 2016 20:03:52 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 60F9E2402D5 for <bug-DBD-ODBC [...] rt.cpan.org>; Tue, 2 Feb 2016 20:03:50 -0500 (EST)
Received: (qmail 17892 invoked by alias); 3 Feb 2016 01:03:50 -0000
Received: from ironport1.ansto.gov.au (HELO ironport1.ansto.gov.au) (137.157.2.13) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Tue, 02 Feb 2016 17:03:42 -0800
Received: from emailgw1.ansto.gov.au ([137.157.2.4]) by ironport1.ansto.gov.au with ESMTP; 03 Feb 2016 12:03:38 +1100
Received: from exchange.ansto.gov.au (exch2-b51-nlb.ansto.gov.au [137.157.12.53]) by emailgw1.ansto.gov.au (8.13.8+Sun/8.13.8) with ESMTP id u1313bqP015907 for <bug-DBD-ODBC [...] rt.cpan.org>; Wed, 3 Feb 2016 12:03:37 +1100 (EST)
Received: from EXCH1-B81.ansto.gov.au (137.157.65.160) by EXCH2-B51.ansto.gov.au (137.157.12.52) with Microsoft SMTP Server (TLS) id 14.1.289.1; Wed, 3 Feb 2016 12:03:37 +1100
Received: from EXMBS2-B51.ansto.gov.au ([169.254.2.17]) by EXCH1-B81.ansto.gov.au ([169.254.5.181]) with mapi id 14.01.0289.001; Wed, 3 Feb 2016 12:03:37 +1100
Delivered-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
Subject: RE: [rt.cpan.org #111666] DBI - Access OBDC bug [SEC=UNCLASSIFIED]
X-Spam-Check-BY: la.mx.develooper.com
Thread-Index: AdFeHrWt8p2XHzd+RzSKw8Yygc+2qg==
Date: Wed, 3 Feb 2016 01:03:36 +0000
X-Spam-Level:
To: "bug-DBD-ODBC [...] rt.cpan.org" <bug-DBD-ODBC [...] rt.cpan.org>
Content-Transfer-Encoding: base64
X-Ansto-PM-Filtering: accepted by emailgw1.ansto.gov.au; message from <mts [...] ansto.gov.au> (exch2-b51-nlb.ansto.gov.au [137.157.12.53]); Wed, 03 Feb 2016 12:03:37 +1100 [1454461417] auth=6091527a1e86f6c72d51148f82277a819812fdfd
X-Spam-Status: No, score=-4.201 tagged_above=-99.9 required=10 tests=[AWL=0.000, BAYES_00=-1.9, RCVD_IN_DNSWL_MED=-2.3, RP_MATCHES_RCVD=-0.001] autolearn=ham
X-Ansto-Senderip: 137.157.12.53
Received-SPF: Pass (ironport1.ansto.gov.au: domain of mts [...] ansto.gov.au designates 137.157.2.4 as permitted sender) identity=mailfrom; client-ip=137.157.2.4; receiver=ironport1.ansto.gov.au; envelope-from="mts [...] ansto.gov.au"; x-sender="mts [...] ansto.gov.au"; x-conformance=spf_only; x-record-type="v=spf1"
Received-SPF: None (ironport1.ansto.gov.au: no sender authenticity information available from domain of postmaster [...] emailgw1.ansto.gov.au) identity=helo; client-ip=137.157.2.4; receiver=ironport1.ansto.gov.au; envelope-from="mts [...] ansto.gov.au"; x-sender="postmaster [...] emailgw1.ansto.gov.au"; x-conformance=spf_only
X-RT-Interface: API
Content-Language: en-US
Message-ID: <0E5BB4F945105948AF5D21EE077891F101ADA01D [...] EXMBS2-B51.ansto.gov.au>
X-MS-Tnef-Correlator:
X-Classifier: janusSEAL for Outlook 2.6.2
Return-Path: <mts [...] ansto.gov.au>
X-RT-Mail-Extension: dbd-odbc
X-Original-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
X-Original-Protective-Marking: VER=2012.3, NS=gov.au, SEC=UNCLASSIFIED, ORIGIN=mts [...] ansto.gov.au
X-MS-Has-Attach:
Thread-Topic: [rt.cpan.org #111666] DBI - Access OBDC bug [SEC=UNCLASSIFIED]
X-Originating-Ip: [137.157.126.44]
Accept-Language: en-AU, en-US
From: "SALE, Matthew" <mts [...] ansto.gov.au>
RT-Message-ID: <rt-4.0.18-3756-1454461436-1289.111666-0-0 [...] rt.cpan.org>
Content-Length: 23493
Download (untitled) / with headers
text/plain 22.9k

Message body is not shown because it is too large.

MIME-Version: 1.0
In-Reply-To: <rt-4.0.18-3756-1454461436-1289.111666-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <0E5BB4F945105948AF5D21EE077891F101ADA01D [...] EXMBS2-B51.ansto.gov.au> <rt-4.0.18-3756-1454461436-1289.111666-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-12745-1454492595-815.111666-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 808
Download (untitled) / with headers
text/plain 808b
On Tue Feb 02 20:03:56 2016, mts@ansto.gov.au wrote: Show quoted text
> Good Day Martin > > I am currently running > Strawberry perl 32-bit v5.22.1 > DBI 1.634 > DBD::ODBC 1.52 > Windows 7 > Access 2010 > > The content of the data base is ... > ID(LongInteger) Field1(Double) > 1 8.93601020357839E-06 > 2 0.0000000086 > > The result of running the code is... > $VAR1 = 1; > $VAR2 = 'E-6'; > $VAR1 = 2; > $VAR2 = '0.0000000086'; > > -> it appears that something doesn't like scientific notation but > things are OK if there aren't too many significant figures. > > The result of x.log is as follows... >
<snipped> Thanks for all the info. I have something to look at here. Give me until end of tomorrow and if you haven't heard anything from me nag me to remind me. Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
In-Reply-To: <rt-4.0.18-12745-1454492595-815.111666-0-0 [...] rt.cpan.org>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <0E5BB4F945105948AF5D21EE077891F101ADA01D [...] EXMBS2-B51.ansto.gov.au> <rt-4.0.18-3756-1454461436-1289.111666-0-0 [...] rt.cpan.org> <rt-4.0.18-12745-1454492595-815.111666-0-0 [...] rt.cpan.org>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-15736-1454510597-1915.111666-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 1500
Download (untitled) / with headers
text/plain 1.4k
On Wed Feb 03 04:43:15 2016, MJEVANS wrote: Show quoted text
> On Tue Feb 02 20:03:56 2016, mts@ansto.gov.au wrote:
> > Good Day Martin > > > > I am currently running > > Strawberry perl 32-bit v5.22.1 > > DBI 1.634 > > DBD::ODBC 1.52 > > Windows 7 > > Access 2010 > > > > The content of the data base is ... > > ID(LongInteger) Field1(Double) > > 1 8.93601020357839E-06 > > 2 0.0000000086 > > > > The result of running the code is... > > $VAR1 = 1; > > $VAR2 = 'E-6'; > > $VAR1 = 2; > > $VAR2 = '0.0000000086'; > > > > -> it appears that something doesn't like scientific notation but > > things are OK if there aren't too many significant figures. > > > > The result of x.log is as follows... > >
> > <snipped> > > Thanks for all the info. I have something to look at here. Give me > until end of tomorrow and if you haven't heard anything from me nag me > to remind me. > > Martin
Hi Matt, The good news is I have the fix for you. The bad news (maybe) is you'll need to download a new MS Access ODBC Driver. I'm guessing you are using the MS Access 2010 driver (v14 - look in your ODBC driver manager under the driver tab for the accdb driver) or earlier. This driver is broken (and earlier) are broken. I have verified this using MS's odbctest application. The newer 2013 (v15) driver appears to work. Search for "MS Access 2013 redistributable engine" and install the appropriate version for your OS. I have verified this fixes the problem for me here. Martin -- Martin J. Evans Wetherby, UK
X-Protective-Marking: VER=2012.3, NS=gov.au, SEC=UNCLASSIFIED, ORIGIN=mts [...] ansto.gov.au
MIME-Version: 1.0
X-Spam-Flag: NO
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
content-type: text/plain; charset="utf-8"
X-RT-Original-Encoding: utf-8
X-Spam-Score: -6.201
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 31C61240393 for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Wed, 3 Feb 2016 20:33:20 -0500 (EST)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id utubKd+pHj0d for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Wed, 3 Feb 2016 20:33:18 -0500 (EST)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 401AB2402D0 for <bug-DBD-ODBC [...] rt.cpan.org>; Wed, 3 Feb 2016 20:33:17 -0500 (EST)
Received: (qmail 23276 invoked by alias); 4 Feb 2016 01:33:17 -0000
Received: from ironport1.ansto.gov.au (HELO ironport1.ansto.gov.au) (137.157.2.13) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Wed, 03 Feb 2016 17:33:14 -0800
Received: from emailgw1.ansto.gov.au ([137.157.2.4]) by ironport1.ansto.gov.au with ESMTP; 04 Feb 2016 12:33:02 +1100
Received: from exchange.ansto.gov.au (exch2-b51-nlb.ansto.gov.au [137.157.12.53]) by emailgw1.ansto.gov.au (8.13.8+Sun/8.13.8) with ESMTP id u141X1Dp002714 for <bug-DBD-ODBC [...] rt.cpan.org>; Thu, 4 Feb 2016 12:33:01 +1100 (EST)
Received: from EXMBS2-B51.ansto.gov.au ([169.254.2.17]) by exch2-b51.ansto.gov.au ([137.157.12.52]) with mapi id 14.01.0289.001; Thu, 4 Feb 2016 12:33:01 +1100
Delivered-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
Subject: RE: [rt.cpan.org #111666] DBI - Access OBDC bug [SEC=UNCLASSIFIED]
X-Spam-Check-BY: la.mx.develooper.com
Thread-Index: AdFeHrWt8p2XHzd+RzSKw8Yygc+2qgAco71hABagUyA=
Date: Thu, 4 Feb 2016 01:33:00 +0000
X-Spam-Level:
To: "bug-DBD-ODBC [...] rt.cpan.org" <bug-DBD-ODBC [...] rt.cpan.org>
Content-Transfer-Encoding: base64
In-Reply-To: <rt-4.0.18-15736-1454510597-1437.111666-6-0 [...] rt.cpan.org>
X-Spam-Status: No, score=-6.201 tagged_above=-99.9 required=10 tests=[AWL=2.000, BAYES_00=-1.9, FROM_OUR_RT=-4, RCVD_IN_DNSWL_MED=-2.3, RP_MATCHES_RCVD=-0.001] autolearn=ham
X-Ansto-PM-Filtering: accepted by emailgw1.ansto.gov.au; message from <mts [...] ansto.gov.au> (exch2-b51-nlb.ansto.gov.au [137.157.12.53]); Thu, 04 Feb 2016 12:33:01 +1100 [1454549581] auth=9dd892e915ce97f5bc925db0681b26fb2ceba7a1
X-Ansto-Senderip: 137.157.12.53
Received-SPF: Pass (ironport1.ansto.gov.au: domain of mts [...] ansto.gov.au designates 137.157.2.4 as permitted sender) identity=mailfrom; client-ip=137.157.2.4; receiver=ironport1.ansto.gov.au; envelope-from="mts [...] ansto.gov.au"; x-sender="mts [...] ansto.gov.au"; x-conformance=spf_only; x-record-type="v=spf1"
Received-SPF: None (ironport1.ansto.gov.au: no sender authenticity information available from domain of postmaster [...] emailgw1.ansto.gov.au) identity=helo; client-ip=137.157.2.4; receiver=ironport1.ansto.gov.au; envelope-from="mts [...] ansto.gov.au"; x-sender="postmaster [...] emailgw1.ansto.gov.au"; x-conformance=spf_only
X-RT-Interface: API
Content-Language: en-US
References: <RT-Ticket-111666 [...] rt.cpan.org> <0E5BB4F945105948AF5D21EE077891F101ADA01D [...] EXMBS2-B51.ansto.gov.au> <rt-4.0.18-3756-1454461436-1289.111666-6-0 [...] rt.cpan.org> <rt-4.0.18-12745-1454492595-815.111666-6-0 [...] rt.cpan.org> <rt-4.0.18-15736-1454510597-1437.111666-6-0 [...] rt.cpan.org>
Message-ID: <0E5BB4F945105948AF5D21EE077891F101ADA341 [...] EXMBS2-B51.ansto.gov.au>
X-MS-Tnef-Correlator:
X-Classifier: janusSEAL for Outlook 2.6.2
Return-Path: <mts [...] ansto.gov.au>
X-RT-Mail-Extension: dbd-odbc
X-Original-To: cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
X-Original-Protective-Marking: VER=2012.3, NS=gov.au, SEC=UNCLASSIFIED, ORIGIN=bug-DBD-ODBC [...] rt.cpan.org
X-MS-Has-Attach:
Thread-Topic: [rt.cpan.org #111666] DBI - Access OBDC bug [SEC=UNCLASSIFIED]
X-Originating-Ip: [137.157.126.44]
Accept-Language: en-AU, en-US
From: "SALE, Matthew" <mts [...] ansto.gov.au>
RT-Message-ID: <rt-4.0.18-15116-1454549600-606.111666-0-0 [...] rt.cpan.org>
Content-Length: 2051
Good Day Martin I have updated to the "MS Access 2013 redistributable engine" and after re-configuring my ODBC connections, the database access appears to be working now. Thanks for your speedy help, Matt Show quoted text
-----Original Message----- From: Martin J Evans via RT [mailto:bug-DBD-ODBC@rt.cpan.org] Sent: Thursday, 4 February 2016 1:43 AM To: SALE, Matthew Subject: [rt.cpan.org #111666] DBI - Access OBDC bug [SEC=UNCLASSIFIED] <URL: https://rt.cpan.org/Ticket/Display.html?id=111666 > On Wed Feb 03 04:43:15 2016, MJEVANS wrote:
> On Tue Feb 02 20:03:56 2016, mts@ansto.gov.au wrote:
> > Good Day Martin > > > > I am currently running > > Strawberry perl 32-bit v5.22.1 > > DBI 1.634 > > DBD::ODBC 1.52 > > Windows 7 > > Access 2010 > > > > The content of the data base is ... > > ID(LongInteger) Field1(Double) > > 1 8.93601020357839E-06 > > 2 0.0000000086 > > > > The result of running the code is... > > $VAR1 = 1; > > $VAR2 = 'E-6'; > > $VAR1 = 2; > > $VAR2 = '0.0000000086'; > > > > -> it appears that something doesn't like scientific notation but > > things are OK if there aren't too many significant figures. > > > > The result of x.log is as follows... > >
> > <snipped> > > Thanks for all the info. I have something to look at here. Give me > until end of tomorrow and if you haven't heard anything from me nag me > to remind me. > > Martin
Hi Matt, The good news is I have the fix for you. The bad news (maybe) is you'll need to download a new MS Access ODBC Driver. I'm guessing you are using the MS Access 2010 driver (v14 - look in your ODBC driver manager under the driver tab for the accdb driver) or earlier. This driver is broken (and earlier) are broken. I have verified this using MS's odbctest application. The newer 2013 (v15) driver appears to work. Search for "MS Access 2013 redistributable engine" and install the appropriate version for your OS. I have verified this fixes the problem for me here. Martin -- Martin J. Evans Wetherby, UK


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

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.