Bug #68123 for DBD-ODBC: Allow SQLDescribeParam to be disabled in DBD::ODBC

# Wed May 11 16:09:51 2011 pedrinho [...] gmail.com - Ticket created

From pedrinho [...] gmail.com Wed May 11 16:	09:50 2011
MIME-Version:	1.0
X-Spam-Status:	No, score=-6.208 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_HI=-5, RFC_ABUSE_POST=0.001, SPF_NEUTRAL=0.779, T_TO_NO_BRKTS_FREEMAIL=0.01] autolearn=ham
X-Spam-Flag:	NO
X-Virus-Checked:	Checked by ClamAV on 16.mx.develooper.com
Content-Type:	multipart/alternative; boundary=bcaec5485cfc2e7ab004a305a7d1
Message-ID:	<BANLkTinHre046pieGZdhFzu15vG4+65jNw [...] mail.gmail.com>
X-Virus-Scanned:	Debian amavisd-new at bestpractical.com
X-Spam-Score:	-6.208
Received:	from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 8C54D61E00B for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Wed, 11 May 2011 16:09:50 -0400 (EDT)
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 TZbxqe0CwiX2 for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Wed, 11 May 2011 16:09:48 -0400 (EDT)
Received:	from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 9428361E00A for <bug-DBD-ODBC [...] rt.cpan.org>; Wed, 11 May 2011 16:09:48 -0400 (EDT)
Received:	(qmail 8850 invoked by uid 103); 11 May 2011 20:09:47 -0000
Received:	from x16.dev (10.0.100.26) by x1.dev with QMQP; 11 May 2011 20:09:47 -0000
Received:	from mail-vx0-f178.google.com (HELO mail-vx0-f178.google.com) (209.85.220.178) by 16.mx.develooper.com (qpsmtpd/0.80/v0.80-19-gf52d165) with ESMTP; Wed, 11 May 2011 13:09:44 -0700
Received:	by vxc11 with SMTP id 11so670243vxc.9 for <bug-DBD-ODBC [...] rt.cpan.org>; Wed, 11 May 2011 13:09:41 -0700 (PDT)
Received:	by 10.52.108.105 with SMTP id hj9mr300984vdb.211.1305144581847; Wed, 11 May 2011 13:09:41 -0700 (PDT)
Received:	by 10.52.166.163 with HTTP; Wed, 11 May 2011 13:09:41 -0700 (PDT)
Authentication-Results:	hipster.bestpractical.com (amavisd-new); dkim=pass header.i= [...] gmail.com
Authentication-Results:	hipster.bestpractical.com (amavisd-new); domainkeys=pass header.from=pedrinho [...] gmail.com
Delivered-To:	cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
Subject:	Allow SQLDescribeParam to be disabled in DBD::ODBC
Return-Path:	<pedrinho [...] gmail.com>
Domainkey-Signature:	a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:date:message-id:subject:from:to:content-type; b=pv86wkPzsb4sMKIaa8xn/EofnbglHTp/n+oltQaac4rlwtP1LGZ5hwePi6K9Eax48q T2C999GWguD79u9yG4bdpLoYZd+ywEDi4XKmha+NJjxs5f6V3SeJuWGnQnpAJHssvmVh KLZFY+Dw+CJNl1YrBgDzDyRcZ62arBeSnAcCg=
X-RT-Mail-Extension:	dbd-odbc
X-Original-To:	cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
X-Spam-Check-BY:	16.mx.develooper.com
Dkim-Signature:	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:date:message-id:subject:from:to :content-type; bh=3bAm9f2dlEqzE+6Gozorona21tOMHPxareklbobTWb0=; b=fEN5pjztQfTwzWvQZZSWCyZaw+PuKV5E+eTbNCzNP46T6DiqS2n04KdJXv6McnIEzW tjnica0lL7ahzwl34xsYobjEV49yQZgJ4bj9LhYIvQ5lLkLCeOXiEJAMd0RH6/9rB2Yf NVCHdUz3yWX5SWribTSb8nra6krIu5UJq+3os=
Date:	Wed, 11 May 2011 16:09:41 -0400
X-Spam-Level:
To:	bug-DBD-ODBC [...] rt.cpan.org
From:	"Peter C. Norton" <pedrinho [...] gmail.com>
Content-Length:	0

content-type:	text/plain; charset="utf-8"
X-RT-Original-Encoding:	ISO-8859-1
Content-Length:	1018

Download (untitled) / with headers
text/plain 1018b

While transitioning from the FreeTDS odbc driver to the easysoft odbc sql server driver, we discovered that some date/datetime strings that are legal SQL formats are not also legal ODBC formats, and are therefore causing errors. Our current code (lots of it) relies on dates like '20100101' to be inferred as YYYYMMDD and if it's passed to SQL Server as a string then the server will DTRT (perhaps dependent on locale, I'm not sure). This works for Sybase and SQL Server with FreeTDS. However, when using the easysoft driver and DBD::ODBC, the migration processes runs into a kink: '20100101' can't be converted in the driver into a date type, and the query fails when using prepared statements. To disable this, I've added an option, "odbc_force_default_bind_type" that will disable imp_dbh->odbc_sqldescribeparam_supported. For our purposes, I've only allowed this to be disabled and not have it re-enabled. If this has a place in the upstream driver let me know and I'll send you the patch. Thanks, -Peter

content-type:	text/html; charset="utf-8"
Content-Transfer-Encoding:	quoted-printable
X-RT-Original-Encoding:	ISO-8859-1
Content-Length:	1164

Download (untitled) / with headers
text/html 1.1k

# Wed May 11 16:48:36 2011 bohica [...] ntlworld.com - Correspondence added

MIME-Version:	1.0
In-Reply-To:	<BANLkTinHre046pieGZdhFzu15vG4+65jNw [...] mail.gmail.com>
X-Mailer:	MIME-tools 5.427 (Entity 5.427)
Content-Disposition:	inline
References:	<BANLkTinHre046pieGZdhFzu15vG4+65jNw [...] mail.gmail.com>
Content-Type:	text/plain; charset="UTF-8"
Message-ID:	<rt-3.8.HEAD-18806-1305146916-612.68123-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding:	binary
X-RT-Original-Encoding:	utf-8
Content-Length:	2341

Download (untitled) / with headers
text/plain 2.2k

On Wed May 11 16:09:51 2011, pedrinho@gmail.com wrote: Show quoted text

> While transitioning from the FreeTDS odbc driver to the easysoft odbc > sql server driver, we discovered that some date/datetime strings that > are legal SQL formats are not also legal ODBC formats, and are > therefore causing errors. > > Our current code (lots of it) relies on dates like '20100101' to be > inferred as YYYYMMDD and if it's passed to SQL Server as a string then > the server will DTRT (perhaps dependent on locale, I'm not sure). This > works > for Sybase and SQL Server with FreeTDS. > > However, when using the easysoft driver and DBD::ODBC, the migration > processes runs into a kink: '20100101' can't be converted in the

driver into Show quoted text

> a date type, and the query fails when using prepared statements. > > To disable this, I've added an option, "odbc_force_default_bind_type" that > will > disable imp_dbh->odbc_sqldescribeparam_supported. For our purposes, > I've only allowed this to be disabled and not have it re-enabled. If this > has > a place in the upstream driver let me know and I'll send you the patch. > > > Thanks, > > -Peter

I understand the issue you are describing and to some extent I can see why you have ended up with the solution you have picked. I've personally never come across the problem the way around you describe as normally it is a problem NOT supporting SQLDescribeParam. I appreciate if you've got a lot of code which is written to a driver which does not support SQLDescribeParam and so it would be annoying to change it but by disabling SQLDescribeParam you are inevitably going to hit another issue in the future e.g., I sincerely hope you have not got any varchar(max) columns or you are in a world of pain. Just so you realise the implications. I have no problem with adding a flag to disable SQLDescribeParam and I don't need any patch from you to do it. Are you offering the patch on the basis that you'd like this added to DBD::ODBC for the future (as a supported feature) or are you offering this idea on the basis that you think it might be useful for others. It is a slim difference I agree, but if you are happy as you are and don't think it would benefit others I'd leave it. If you'd like it as a supported feature I'll add it so long as you are prepared to test it. Martin -- Martin J. Evans Wetherby, UK

# Wed May 11 16:48:37 2011 The RT System itself - Status changed from 'new' to 'open'

# Fri May 13 16:21:15 2011 pedrinho [...] gmail.com - Correspondence added

From pedrinho [...] gmail.com Fri May 13 16:	21:15 2011
MIME-Version:	1.0
X-Spam-Status:	No, score=-6.208 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_HI=-5, RFC_ABUSE_POST=0.001, SPF_NEUTRAL=0.779, T_TO_NO_BRKTS_FREEMAIL=0.01] autolearn=ham
In-Reply-To:	<rt-3.8.HEAD-18806-1305146916-1159.68123-6-0 [...] rt.cpan.org>
X-Spam-Flag:	NO
References:	<RT-Ticket-68123 [...] rt.cpan.org> <BANLkTinHre046pieGZdhFzu15vG4+65jNw [...] mail.gmail.com> <rt-3.8.HEAD-18806-1305146916-1159.68123-6-0 [...] rt.cpan.org>
X-Virus-Checked:	Checked by ClamAV on 16.mx.develooper.com
X-Virus-Scanned:	Debian amavisd-new at bestpractical.com
Message-ID:	<BANLkTint9c4dpscLWYBdWqJ06k2ehVM5LA [...] mail.gmail.com>
Content-Type:	multipart/alternative; boundary=20cf307f3a36a7a22504a32e0b3a
X-Spam-Score:	-6.208
Authentication-Results:	hipster.bestpractical.com (amavisd-new); dkim=pass header.i= [...] gmail.com
Authentication-Results:	hipster.bestpractical.com (amavisd-new); domainkeys=pass header.from=pedrinho [...] gmail.com
Received:	from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 284CD241A39 for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Fri, 13 May 2011 16:21:15 -0400 (EDT)
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 WlrGRM6vtGJy for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Fri, 13 May 2011 16:21:13 -0400 (EDT)
Received:	from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id E4736241A24 for <bug-DBD-ODBC [...] rt.cpan.org>; Fri, 13 May 2011 16:21:12 -0400 (EDT)
Received:	(qmail 9740 invoked by uid 103); 13 May 2011 20:21:12 -0000
Received:	from x16.dev (10.0.100.26) by x1.dev with QMQP; 13 May 2011 20:21:12 -0000
Received:	from mail-vx0-f178.google.com (HELO mail-vx0-f178.google.com) (209.85.220.178) by 16.mx.develooper.com (qpsmtpd/0.80/v0.80-19-gf52d165) with ESMTP; Fri, 13 May 2011 13:21:09 -0700
Received:	by vxc11 with SMTP id 11so2221174vxc.9 for <bug-DBD-ODBC [...] rt.cpan.org>; Fri, 13 May 2011 13:21:06 -0700 (PDT)
Received:	by 10.52.96.138 with SMTP id ds10mr523985vdb.11.1305318066200; Fri, 13 May 2011 13:21:06 -0700 (PDT)
Received:	by 10.52.166.163 with HTTP; Fri, 13 May 2011 13:21:06 -0700 (PDT)
Delivered-To:	cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
Subject:	Re: [rt.cpan.org #68123] Allow SQLDescribeParam to be disabled in DBD::ODBC
Domainkey-Signature:	a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=kSQGhpTHDhroSIK96m3hwWFeq3Io4qyym6UT+phuvDGx+In58ngYtmKz1jbit0yMCl kXGZUC9/bjA0TXS7PWLPjaIlvdcygn1aGGmxRb47hmn4BGFaimIhf2F9j3zMRFqTW14U V6OTvv5gPtNeCJKNtXF7A1G95gy01FONoXVW4=
Return-Path:	<pedrinho [...] gmail.com>
Dkim-Signature:	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=M5o3AD9eERRS1GQAtwSfz4FGuppxx1oD4vdfpT0ofk8=; b=PFz9eaoaTR40Fhmzm5ocGZFo6x8uuiyCjRT34ALe37XeAE+P3LxcSYElAqxbbk/VmT vweloUcrPLpoqt6tXlVQZZGW/VXYVXKfmSPAmkqijiko86dSAQT7YlQMnq9kaOSLv/Yd ydKxQPtZgu0q+hpXXbPH89M17T+yV3VV3sdEA=
X-Spam-Check-BY:	16.mx.develooper.com
X-Original-To:	cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
X-RT-Mail-Extension:	dbd-odbc
Date:	Fri, 13 May 2011 16:21:06 -0400
X-Spam-Level:
To:	bug-DBD-ODBC [...] rt.cpan.org
From:	"Peter C. Norton" <pedrinho [...] gmail.com>
RT-Message-ID:	<rt-3.8.HEAD-18809-1305318075-158.68123-0-0 [...] rt.cpan.org>
Content-Length:	0

Content-Type:	text/plain; charset="utf-8"
X-RT-Original-Encoding:	utf-8
Content-Length:	2668

Download (untitled) / with headers
text/plain 2.6k

If you can add it to DBD::ODBC then I will be happy to test it. -Peter On Wed, May 11, 2011 at 4:48 PM, Martin J Evans via RT < bug-DBD-ODBC@rt.cpan.org> wrote: Show quoted text

> <URL: https://rt.cpan.org/Ticket/Display.html?id=68123 > > > On Wed May 11 16:09:51 2011, pedrinho@gmail.com wrote:

> > While transitioning from the FreeTDS odbc driver to the easysoft odbc > > sql server driver, we discovered that some date/datetime strings that > > are legal SQL formats are not also legal ODBC formats, and are > > therefore causing errors. > > > > Our current code (lots of it) relies on dates like '20100101' to be > > inferred as YYYYMMDD and if it's passed to SQL Server as a string then > > the server will DTRT (perhaps dependent on locale, I'm not sure). This > > works > > for Sybase and SQL Server with FreeTDS. > > > > However, when using the easysoft driver and DBD::ODBC, the migration > > processes runs into a kink: '20100101' can't be converted in the

> driver into

> > a date type, and the query fails when using prepared statements. > > > > To disable this, I've added an option, "odbc_force_default_bind_type"

> that

> > will > > disable imp_dbh->odbc_sqldescribeparam_supported. For our purposes, > > I've only allowed this to be disabled and not have it re-enabled. If

> this

> > has > > a place in the upstream driver let me know and I'll send you the patch. > > > > > > Thanks, > > > > -Peter

> > I understand the issue you are describing and to some extent I can see > why you have ended up with the solution you have picked. I've personally > never come across the problem the way around you describe as normally it > is a problem NOT supporting SQLDescribeParam. I appreciate if you've got > a lot of code which is written to a driver which does not support > SQLDescribeParam and so it would be annoying to change it but by > disabling SQLDescribeParam you are inevitably going to hit another issue > in the future e.g., I sincerely hope you have not got any varchar(max) > columns or you are in a world of pain. Just so you realise the > implications. > > I have no problem with adding a flag to disable SQLDescribeParam and I > don't need any patch from you to do it. Are you offering the patch on > the basis that you'd like this added to DBD::ODBC for the future (as a > supported feature) or are you offering this idea on the basis that you > think it might be useful for others. It is a slim difference I agree, > but if you are happy as you are and don't think it would benefit others > I'd leave it. If you'd like it as a supported feature I'll add it so > long as you are prepared to test it. > > Martin > -- > Martin J. Evans > Wetherby, UK >

Content-Type:	text/html; charset="utf-8"
Content-Transfer-Encoding:	quoted-printable
X-RT-Original-Encoding:	utf-8
Content-Length:	3378

Download (untitled) / with headers
text/html 3.2k

# Mon May 16 05:06:58 2011 bohica [...] ntlworld.com - Correspondence added

MIME-Version:	1.0
In-Reply-To:	<rt-3.8.HEAD-18809-1305318075-158.68123-0-0 [...] rt.cpan.org>
X-Mailer:	MIME-tools 5.427 (Entity 5.427)
Content-Disposition:	inline
References:	<RT-Ticket-68123 [...] rt.cpan.org> <BANLkTinHre046pieGZdhFzu15vG4+65jNw [...] mail.gmail.com> <rt-3.8.HEAD-18806-1305146916-1159.68123-6-0 [...] rt.cpan.org> <BANLkTint9c4dpscLWYBdWqJ06k2ehVM5LA [...] mail.gmail.com> <rt-3.8.HEAD-18809-1305318075-158.68123-0-0 [...] rt.cpan.org>
Content-Type:	text/plain; charset="UTF-8"
Message-ID:	<rt-3.8.HEAD-18809-1305536818-834.68123-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding:	binary
X-RT-Original-Encoding:	utf-8
Content-Length:	441

Download (untitled) / with headers
text/plain 441b

On Fri May 13 16:21:15 2011, pedrinho@gmail.com wrote: Show quoted text

> If you can add it to DBD::ODBC then I will be happy to test it. > > -Peter

I've just uploaded DBD::ODBC 1.30_2 to PAUSE. You should be able to see it in an hour or two. It adds odbc_describe_parameters attribute (documented but I missed off the Changes file by mistake). I believe it does what you wanted. Please let me know how you get on. Martin -- Martin J. Evans Wetherby, UK

# Tue May 17 05:35:47 2011 bohica [...] ntlworld.com - Correspondence added

MIME-Version:	1.0
In-Reply-To:	<rt-3.8.HEAD-18809-1305536818-834.68123-0-0 [...] rt.cpan.org>
X-Mailer:	MIME-tools 5.427 (Entity 5.427)
Content-Disposition:	inline
References:	<RT-Ticket-68123 [...] rt.cpan.org> <BANLkTinHre046pieGZdhFzu15vG4+65jNw [...] mail.gmail.com> <rt-3.8.HEAD-18806-1305146916-1159.68123-6-0 [...] rt.cpan.org> <BANLkTint9c4dpscLWYBdWqJ06k2ehVM5LA [...] mail.gmail.com> <rt-3.8.HEAD-18809-1305318075-158.68123-0-0 [...] rt.cpan.org> <rt-3.8.HEAD-18809-1305536818-834.68123-0-0 [...] rt.cpan.org>
Content-Type:	text/plain; charset="UTF-8"
Message-ID:	<rt-3.8.HEAD-18805-1305624947-957.68123-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding:	binary
X-RT-Original-Encoding:	utf-8
Content-Length:	557

Download (untitled) / with headers
text/plain 557b

On Mon May 16 05:06:58 2011, MJEVANS wrote: Show quoted text

> On Fri May 13 16:21:15 2011, pedrinho@gmail.com wrote:

> > If you can add it to DBD::ODBC then I will be happy to test it. > > > > -Peter

> > I've just uploaded DBD::ODBC 1.30_2 to PAUSE. You should be able to see > it in an hour or two. It adds odbc_describe_parameters attribute > (documented but I missed off the Changes file by mistake). I believe it > does what you wanted. > > Please let me know how you get on. > > Martin

Correction, it is working in 1.30_3. Martin -- Martin J. Evans Wetherby, UK

# Tue May 17 11:01:33 2011 pedrinho [...] gmail.com - Correspondence added

From pedrinho [...] gmail.com Tue May 17 11:	01:33 2011
MIME-Version:	1.0
X-Spam-Status:	No, score=-6.208 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_HI=-5, RFC_ABUSE_POST=0.001, SPF_NEUTRAL=0.779, T_TO_NO_BRKTS_FREEMAIL=0.01] autolearn=ham
In-Reply-To:	<rt-3.8.HEAD-18805-1305624948-1836.68123-6-0 [...] rt.cpan.org>
X-Spam-Flag:	NO
References:	<RT-Ticket-68123 [...] rt.cpan.org> <BANLkTinHre046pieGZdhFzu15vG4+65jNw [...] mail.gmail.com> <rt-3.8.HEAD-18806-1305146916-1159.68123-6-0 [...] rt.cpan.org> <BANLkTint9c4dpscLWYBdWqJ06k2ehVM5LA [...] mail.gmail.com> <rt-3.8.HEAD-18809-1305318075-158.68123-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-18809-1305536818-834.68123-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-18805-1305624948-1836.68123-6-0 [...] rt.cpan.org>
X-Virus-Checked:	Checked by ClamAV on 16.mx.develooper.com
X-Virus-Scanned:	Debian amavisd-new at bestpractical.com
Message-ID:	<BANLkTingvaO+JNZapX5pyzw=Sq=ZJYqndA [...] mail.gmail.com>
Content-Type:	multipart/alternative; boundary=bcaec548a8c7bee5fa04a37a0b71
X-Spam-Score:	-6.208
Authentication-Results:	hipster.bestpractical.com (amavisd-new); dkim=pass header.i= [...] gmail.com
Authentication-Results:	hipster.bestpractical.com (amavisd-new); domainkeys=pass header.from=pedrinho [...] gmail.com
Received:	from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 39ABF241AB1 for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Tue, 17 May 2011 11:01:33 -0400 (EDT)
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 s1o-ldEbxn8p for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Tue, 17 May 2011 11:01:31 -0400 (EDT)
Received:	from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 18E00241AAE for <bug-DBD-ODBC [...] rt.cpan.org>; Tue, 17 May 2011 11:01:30 -0400 (EDT)
Received:	(qmail 15704 invoked by uid 103); 17 May 2011 15:01:30 -0000
Received:	from x16.dev (10.0.100.26) by x1.dev with QMQP; 17 May 2011 15:01:30 -0000
Received:	from mail-vx0-f178.google.com (HELO mail-vx0-f178.google.com) (209.85.220.178) by 16.mx.develooper.com (qpsmtpd/0.80/v0.80-19-gf52d165) with ESMTP; Tue, 17 May 2011 08:01:28 -0700
Received:	by vxc11 with SMTP id 11so407418vxc.9 for <bug-DBD-ODBC [...] rt.cpan.org>; Tue, 17 May 2011 08:01:25 -0700 (PDT)
Received:	by 10.52.181.102 with SMTP id dv6mr972133vdc.251.1305644485240; Tue, 17 May 2011 08:01:25 -0700 (PDT)
Received:	by 10.52.166.163 with HTTP; Tue, 17 May 2011 08:01:25 -0700 (PDT)
Delivered-To:	cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
Subject:	Re: [rt.cpan.org #68123] Allow SQLDescribeParam to be disabled in DBD::ODBC
Domainkey-Signature:	a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=L6ZTDifZQeLqz0mkz6OdBK288FmO+vn2ZchuhVkuCC9z1l3YNCycyfLKnptL6pT1Q3 KJN+vHGsNIdnQjmWketDuKpMt6pU15BB9iqlFiJXBqV4Ucd5hqItmQXFzFVSLyHZJbcK rXxRtSp72z7daMs/4OB86E7pVk02B1TZQMpPQ=
Return-Path:	<pedrinho [...] gmail.com>
Dkim-Signature:	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=yEkx9Z6Lq7fISvIKHz9uwPc9rRMf9xKGoxxPVVWNLkA=; b=TK0MziHhZa0wl1ZjGChX2YgBE3aGlL0KWDrCC2mhMejo8ePYlXqx0gOXlgrZQa0lYf juyDj5UpMhwH7Wfh5GcUWf4iKvKzBpIVR/cBQuiwX0AQfEByKXdjq04rxsZ/rEMOCpGe U1wo5CeugYzv7sv6YAd3EBZ6H84vMkoFVOnRU=
X-Spam-Check-BY:	16.mx.develooper.com
X-Original-To:	cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
X-RT-Mail-Extension:	dbd-odbc
Date:	Tue, 17 May 2011 11:01:25 -0400
X-Spam-Level:
To:	bug-DBD-ODBC [...] rt.cpan.org
From:	"Peter C. Norton" <pedrinho [...] gmail.com>
RT-Message-ID:	<rt-3.8.HEAD-18808-1305644493-1203.68123-0-0 [...] rt.cpan.org>
Content-Length:	0

Content-Type:	text/plain; charset="utf-8"
X-RT-Original-Encoding:	utf-8
Content-Length:	833

Download (untitled) / with headers
text/plain 833b

OK, I'm not familiar with PAUSE, so I'll get an account and download 1.30_3. -Peter On Tue, May 17, 2011 at 5:35 AM, Martin J Evans via RT < bug-DBD-ODBC@rt.cpan.org> wrote: Show quoted text

> <URL: https://rt.cpan.org/Ticket/Display.html?id=68123 > > > On Mon May 16 05:06:58 2011, MJEVANS wrote:

> > On Fri May 13 16:21:15 2011, pedrinho@gmail.com wrote:

> > > If you can add it to DBD::ODBC then I will be happy to test it. > > > > > > -Peter

> > > > I've just uploaded DBD::ODBC 1.30_2 to PAUSE. You should be able to see > > it in an hour or two. It adds odbc_describe_parameters attribute > > (documented but I missed off the Changes file by mistake). I believe it > > does what you wanted. > > > > Please let me know how you get on. > > > > Martin

> > Correction, it is working in 1.30_3. > > Martin > -- > Martin J. Evans > Wetherby, UK >

Content-Type:	text/html; charset="utf-8"
Content-Transfer-Encoding:	quoted-printable
X-RT-Original-Encoding:	utf-8
Content-Length:	1417

Download (untitled) / with headers
text/html 1.3k

# Tue May 17 11:19:50 2011 bohica [...] ntlworld.com - Correspondence added

MIME-Version:	1.0
In-Reply-To:	<rt-3.8.HEAD-18808-1305644493-1203.68123-0-0 [...] rt.cpan.org>
X-Mailer:	MIME-tools 5.427 (Entity 5.427)
Content-Disposition:	inline
References:	<RT-Ticket-68123 [...] rt.cpan.org> <BANLkTinHre046pieGZdhFzu15vG4+65jNw [...] mail.gmail.com> <rt-3.8.HEAD-18806-1305146916-1159.68123-6-0 [...] rt.cpan.org> <BANLkTint9c4dpscLWYBdWqJ06k2ehVM5LA [...] mail.gmail.com> <rt-3.8.HEAD-18809-1305318075-158.68123-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-18809-1305536818-834.68123-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-18805-1305624948-1836.68123-6-0 [...] rt.cpan.org> <BANLkTingvaO+JNZapX5pyzw=Sq=ZJYqndA [...] mail.gmail.com> <rt-3.8.HEAD-18808-1305644493-1203.68123-0-0 [...] rt.cpan.org>
Content-Type:	text/plain; charset="UTF-8"
Message-ID:	<rt-3.8.HEAD-18810-1305645590-300.68123-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding:	binary
X-RT-Original-Encoding:	utf-8
Content-Length:	417

Download (untitled) / with headers
text/plain 417b

On Tue May 17 11:01:33 2011, pedrinho@gmail.com wrote: Show quoted text

> OK, I'm not familiar with PAUSE, so I'll get an account and download

1.30_3. Show quoted text

> > -Peter

You don't need one. Just go to http://search.cpan.org and enter DBD::ODBC in the search box. Click on the resultant link and it should get you to: http://search.cpan.org/~mjevans/DBD-ODBC-1.29/ where you can download 1.30_3. Martin -- Martin J. Evans Wetherby, UK

# Tue May 17 18:25:15 2011 pedrinho [...] gmail.com - Correspondence added

From pedrinho [...] gmail.com Tue May 17 18:	25:15 2011
MIME-Version:	1.0
X-Spam-Status:	No, score=-6.208 tagged_above=-99.9 required=10 tests=[AWL=0.000, BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_HI=-5, RFC_ABUSE_POST=0.001, SPF_NEUTRAL=0.779, T_TO_NO_BRKTS_FREEMAIL=0.01] autolearn=ham
In-Reply-To:	<rt-3.8.HEAD-18810-1305645590-474.68123-6-0 [...] rt.cpan.org>
X-Spam-Flag:	NO
References:	<RT-Ticket-68123 [...] rt.cpan.org> <BANLkTinHre046pieGZdhFzu15vG4+65jNw [...] mail.gmail.com> <rt-3.8.HEAD-18806-1305146916-1159.68123-6-0 [...] rt.cpan.org> <BANLkTint9c4dpscLWYBdWqJ06k2ehVM5LA [...] mail.gmail.com> <rt-3.8.HEAD-18809-1305318075-158.68123-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-18809-1305536818-834.68123-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-18805-1305624948-1836.68123-6-0 [...] rt.cpan.org> <BANLkTingvaO+JNZapX5pyzw=Sq=ZJYqndA [...] mail.gmail.com> <rt-3.8.HEAD-18808-1305644493-1203.68123-6-0 [...] rt.cpan.org> <rt-3.8.HEAD-18810-1305645590-474.68123-6-0 [...] rt.cpan.org>
X-Virus-Checked:	Checked by ClamAV on 16.mx.develooper.com
X-Virus-Scanned:	Debian amavisd-new at bestpractical.com
Message-ID:	<BANLkTinM=aRLc_re-_48gd87CLZmVqG6Sg [...] mail.gmail.com>
Content-Type:	multipart/alternative; boundary=20cf307f37048295d404a3803ed5
X-Spam-Score:	-6.208
Authentication-Results:	hipster.bestpractical.com (amavisd-new); dkim=pass header.i= [...] gmail.com
Authentication-Results:	hipster.bestpractical.com (amavisd-new); domainkeys=pass header.from=pedrinho [...] gmail.com
Received:	from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 3E87E241AB6 for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Tue, 17 May 2011 18:25:15 -0400 (EDT)
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 loUuBpW8MhcU for <cpan-bug+DBD-ODBC [...] hipster.bestpractical.com>; Tue, 17 May 2011 18:25:13 -0400 (EDT)
Received:	from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 3DED2241AB0 for <bug-DBD-ODBC [...] rt.cpan.org>; Tue, 17 May 2011 18:25:13 -0400 (EDT)
Received:	(qmail 25604 invoked by uid 103); 17 May 2011 22:25:12 -0000
Received:	from x16.dev (10.0.100.26) by x1.dev with QMQP; 17 May 2011 22:25:12 -0000
Received:	from mail-vw0-f50.google.com (HELO mail-vw0-f50.google.com) (209.85.212.50) by 16.mx.develooper.com (qpsmtpd/0.80/v0.80-19-gf52d165) with ESMTP; Tue, 17 May 2011 15:25:09 -0700
Received:	by vws14 with SMTP id 14so732470vws.9 for <bug-DBD-ODBC [...] rt.cpan.org>; Tue, 17 May 2011 15:25:07 -0700 (PDT)
Received:	by 10.52.99.7 with SMTP id em7mr1679895vdb.131.1305671106728; Tue, 17 May 2011 15:25:06 -0700 (PDT)
Received:	by 10.52.166.163 with HTTP; Tue, 17 May 2011 15:25:06 -0700 (PDT)
Delivered-To:	cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
Subject:	Re: [rt.cpan.org #68123] Allow SQLDescribeParam to be disabled in DBD::ODBC
Domainkey-Signature:	a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=qsggPeeLhnWwIBgAgzl7cDv2Lkx1ZbbkxqHwoDki9VvwezYuVV7m4OApXVuWhAUmh6 2hrEnhhCWkcHuhleaZKhq9OykbGnoCaxZ41pkLi+1BivPMdl+kQq28/kwXFhBwnUz3Oy fG+JwU3hKGixmquZIpBvEiXWE6/A3QPLuXgoM=
Return-Path:	<pedrinho [...] gmail.com>
Dkim-Signature:	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :message-id:subject:from:to:content-type; bh=LlS+W/z8o5zSRfg+OQcWFwmccENAPiU45E/z+j/97ro=; b=CSdk+haLFlD0VCjMw/GJLjUBZrs29Fc4iMxdhQcTo5PCZXw2G7vqpGubjQIim5tcKG jApIETLJ4+D7/wlHzYUNufLerF4zoI+9I26CZDp1V0JqSAG/s27agdmBHoPt8T2g822G 57eAGbxtWc3274de8Veb37djjSQJqWHloG8ZA=
X-Spam-Check-BY:	16.mx.develooper.com
X-Original-To:	cpan-bug+DBD-ODBC [...] hipster.bestpractical.com
X-RT-Mail-Extension:	dbd-odbc
Date:	Tue, 17 May 2011 18:25:06 -0400
X-Spam-Level:
To:	bug-DBD-ODBC [...] rt.cpan.org
From:	"Peter C. Norton" <pedrinho [...] gmail.com>
RT-Message-ID:	<rt-3.8.HEAD-18805-1305671115-456.68123-0-0 [...] rt.cpan.org>
Content-Length:	0

Content-Type:	text/plain; charset="utf-8"
X-RT-Original-Encoding:	utf-8
Content-Length:	771

Download (untitled) / with headers
text/plain 771b

OK, I've run the basic functionality tests and the flag works as we need. We're going to run further in-house tests to see how this driver works for us. Thanks, -Peter On Tue, May 17, 2011 at 11:19 AM, Martin J Evans via RT < bug-DBD-ODBC@rt.cpan.org> wrote: Show quoted text

> <URL: https://rt.cpan.org/Ticket/Display.html?id=68123 > > > On Tue May 17 11:01:33 2011, pedrinho@gmail.com wrote:

> > OK, I'm not familiar with PAUSE, so I'll get an account and download

> 1.30_3.

> > > > -Peter

> > You don't need one. Just go to http://search.cpan.org and enter > DBD::ODBC in the search box. Click on the resultant link and it should > get you to: > > http://search.cpan.org/~mjevans/DBD-ODBC-1.29/ > > where you can download 1.30_3. > > Martin > -- > Martin J. Evans > Wetherby, UK >

Content-Type:	text/html; charset="utf-8"
Content-Transfer-Encoding:	quoted-printable
X-RT-Original-Encoding:	utf-8
Content-Length:	1438

Download (untitled) / with headers
text/html 1.4k

# Wed May 25 05:04:00 2011 bohica [...] ntlworld.com - Status changed from 'open' to 'resolved'

# Wed May 25 05:04:01 2011 bohica [...] ntlworld.com - Fixed in 1.30_3 added