SQL Server 7 and Win32::ODBC perl module
Quote:
> >What is strange is that the previous database that I was using was
Access,
> >and I was able to return the entire entry (all 2000+ characters) using
the
> >same perl scripts. It was only after switching to a SQL Server 7 database
> >that this unusual behavior was shown.
> Hm, what version of the ODBC driver do you have? I believe you
> need to have 3.70 or higher. Previous versions will be regarded
> as legacy clients by SQL7 which will truncate strings longer than
> 255 chars.
My original setup was that I had my perl scripts on one machine and the SQL
Server on another machine. The machine that contained my perl scripts had
driver version 3.5; the machine with SQL Server had 3.7. The DSN entry I was
using pointed to the version 3.5 driver.
After reading your email I moved my perl scripts to be on the same machine
as the SQL Server and changed my DSN entry accordingly. However, the
truncation still occurs, even with driver version 3.7.
So one hurdle down, but another has appeared.
Any additional suggestions? They would be much appreciated.
Kelley Kent
