RE: String truncation in insert to SQL Server with DBD::ADO and place holders

From: Frediano (Frediano.Ziglio_at_vodafone.com)
Date: 09/20/04 

Date: Mon, 20 Sep 2004 12:50:50 +0200
To: "Steffen Goeldner" <sgoeldner@cpan.org>, "Sarkissian, Vahe - NC" <Vahe.Sarkissian@cnb.com>

>
> Steffen Goeldner wrote:
>
> > Mysterious! Looks like the first execute establishes
> > a sticky max. length in SQL Server.
>
> Indeed, I can reproduce it with pure ADO (see attached script).
> Unfortunately, I don't see a portable workaround for DBD::ADO.
> I think it would be best the SQL Server team buys a Shared
> Source License from the Access or FoxPro team - they know
> how to do it ;-)
>
>
> Steffen
>

Try to update your MDAC. It should be fixed in recent versions (ODBC had
the same problem, DBD::ODBC tests contains this check)

freddy77

Relevant Pages

  • Re: String truncation in insert to SQL Server with DBD::ADO and place holders
    ... Steffen Goeldner wrote: ... I can reproduce it with pure ADO (see attached script). ... I think it would be best the SQL Server team buys a Shared ...
    (perl.dbi.users)
  • Re: Duplicate Values Question
    ... happened with the first release of ACE. ... has taken over development from the SQL Server team. ... thought of Jet as a toy and a competitor so they were not inclined to ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Whats My Password?
    ... SQL Server was written by Sybase in Berkley California. ... While "SQL Server" Compact Edition is now being worked on in India, ... its look and feel has to conform to Microsoft ... While the Visual Studio team and the SQL Server team have ...
    (microsoft.public.dotnet.framework.adonet)
  • Microsoft SQL Server 2005 JDBC Driver is released to the web -- JAN 18, 2005
    ... driver and is being tested against all major application servers including ... - Support for new SQL Server 2005 Data Types ... for improved JDBC connectivity and commitment from the SQL Server team. ...
    (microsoft.public.sqlserver.jdbcdriver)