That is exactly what I was looking for!
Thanks
> -----Original Message-----
> From: Accardo, Glen [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, June 24, 2002 4:41 PM
> To: 'Brad Fike'
> Subject: RE: ODBC trying to select a Text field from SQL6.5
>
>
> After connecting to the database, use the following statement to
> change the "Long Read Length" for the database connection:
> $dbh->{LongReadLen} = 2097152;
>
> glen accardo
> BMC Software, Inc.
> [EMAIL PROTECTED]
>
> -----Original Message-----
> From: Brad Fike [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 24, 2002 4:38 PM
> To: [EMAIL PROTECTED]
> Subject: DBI:ODBC trying to select a Text field from SQL6.5
>
>
> All,
>
> My Environment is...
> NT 4.0
> MS SQL 6.5
> ActivePerl v5.6.1
>
> I am trying to run a select statement but one of the fields that I'm
> trying
> to get is a Text datatype.
> If I remove that field from my select statement everything works fine.
>
> the error message I get is...
> DBD::ODBC::db selectall_arrayref failed: [Microsoft][ODBC SQL Server
> Driver]String data, right truncation
> (SQL-01004)(DBD: st_fetch/SQLFetch (long truncated) err=1) at
> C:\TEMP\test-disdplay.pl line 27.
>
> Can anyone help me figure out how to get at that data or is there a
> different datatype that I can use that
> can hold more then 255 (I'm talking 1-3 pages of text) characters?
>
> Thanks,
> Brad
>
>
> **********************************************************************
> Notice: The area code for the Wal-Mart Bentonville General
> Office in the US has changed from 501 to 479. Please make
> sure that you are dialing 479 when making calls to any
> General Office location.
>
> **********************************************************************
> This email and any files transmitted with it are confidential
> and intended solely for the individual or entity to
> whom they are addressed. If you have received this email
> in error destroy it immediately.
> **********************************************************************
> Wal-Mart Stores, Inc. Confidential
> **********************************************************************
