Oh hey, that did the trick. Is there a reference of all the
variables that DBD::ODBC has?
Thanks for your prompt response!
Nice first name :)
Ilya
On Sat, 2 Jun 2001 13:13:11 -0400
"Sterin, Ilya" <[EMAIL PROTECTED]> wrote:
> Even if you set LongTruncOk => 1 ???
> Are you fetching from any Long, or LOB fields?
>
> Ilya Sterin
>
> -----Original Message-----
> From: Ilya Zherebetskiy [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, June 02, 2001 12:47 PM
> To: [EMAIL PROTECTED]
> Subject: DBD::ODBC & SQL Server 7
>
>
> I have a particular problem fetching information:
>
> Server is running Microsoft SQL Server 7, OpenLink DAD
> Server Software, Win NT 4.0
>
> Client is a debian box running odbcsdk drivers (detects
> them
> as iODBC). I successfully connect through the examples,
> and
> successfully retrieve data. I then try to compile the
> DBD::ODBC Package to interact with perl.
>
> The package compiles, however it fails on one test:
>
> t/02simple..........ok 7/14DBD::ODBC::st fetchrow failed:
> [OpenLink][ODBC][Driver]Data was truncated
> (SQL-S1004)(DBD:
> st_fetch/SQLFetch (long truncated) err=1) at t/02simple.t
> line 222.
>
> This is the code where it fails:
> $sth = $dbh->prepare("SELECT A,C FROM
> $ODBCTEST::table_name WHERE A=4");
> if ($sth) {
> $sth->execute();
> eval {
> [Line 222 >>] while (@row =
> $sth->fetchrow()) {
> }
> };
> $rc = 1 unless ($@) ;
> }
>
>
> If i compile with make install, it goes through, however
> all
> commands regarding fetch, fetch_array, fetchrow, etc..
> fail
> with the DATA TRUNCATED Error.
>
> Has anyone seen/run into this? Anyone know how to
> resolve
> this?
>
> Thank you!
>
> --
> Ilya Zherebetskiy
> Senior Brainlink Development
> www.brainlink.com
--
Ilya
Brainlink Development
"But the eyes are blind. One must look with the heart..."
