Skip Menu |
 

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

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

People
Owner: Nobody in particular
Requestors: William.Flynn [...] ftc.usda.gov
Cc:
AdminCc:

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



Subject: Inserting more than 8,000 characters into SQL Server varchar(max) field give "Invalid precision value" error
Date: Thu, 19 Feb 2009 16:20:12 -0700
To: <bug-DBD-ODBC [...] rt.cpan.org>
From: "Flynn, William - Fort Collins, CO" <William.Flynn [...] ftc.usda.gov>
Download (untitled) / with headers
text/plain 302b
Broken in 1.18 When trying to insert more than 8,000 characters into a varchar(max) field in a SQL Server database the following error occurs: DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access Driver]Invalid precision value (SQL-HY104) Inserting 8,000 characters or less works fine.
Download (untitled) / with headers
text/plain 437b
Apologies for not replying to your bug report sooner. I normally get emails from the rt system when a bug is posted or changed but I have received none recently and did not notice this until I spotted the following thread on perl monks: http://www.perlmonks.org/?node_id=746522 I will try and look in to this in the next few days but I think it may already be fixed. Will get back to you soon. Martin -- Martin J. Evans Wetherby, UK
Download (untitled) / with headers
text/plain 853b
On Thu Feb 19 18:42:22 2009, William.Flynn@ftc.usda.gov wrote: Show quoted text
> Broken in 1.18 > > When trying to insert more than 8,000 characters into a varchar(max) > field in a SQL Server database the following error occurs: > > DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access > Driver]Invalid precision value (SQL-HY104) > > Inserting 8,000 characters or less works fine. > >
Are you using Microsoft native Client? Did make test for DBD::ODBC run to completion without errors? What version of DBD::ODBC are you using? If you are using native client then older versions have a bug which leads to the error you are reporting. Have you updated it to the latest version? When you run make test, it will spot older native clients that are broken. BTW, there is no need to start a new rt for followups. Martin -- Martin J. Evans Wetherby, UK
Download (untitled) / with headers
text/plain 596b
On Sun Mar 08 13:35:28 2009, MJEVANS wrote: Show quoted text
> On Thu Feb 19 18:42:22 2009, William.Flynn@ftc.usda.gov wrote:
> > Broken in 1.18 > > > > When trying to insert more than 8,000 characters into a varchar(max) > > field in a SQL Server database the following error occurs: > > > > DBD::ODBC::st execute failed: [Microsoft][ODBC Microsoft Access > > Driver]Invalid precision value (SQL-HY104) > > > > Inserting 8,000 characters or less works fine. > > > >
I believe this is working in at least 1.18_4 so I'm marking this fixed unless you tell me otherwise. 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.