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
