Do you know of any issues with DBI, ADO (OLE DB) or DBD::ODBC doing updates
to a MS-SQL 7.0 database that has some text "blob" columns? Are there any
patches?
I've never had any trouble with inserts to MS-SQL 7.0, except for occasional
trunction errors, so I decided to use it for other things. Anyway, I have a
table that I'm trying to do updates with that has two text "blob".
I keep getting a timeout on the execute method.
Changing the text fields to varchar works, but I need to come up with
something that supports recordsets over 8k (not always an easy prospect in
MS-SQL 7, but none of the test data I'm working with is close to that
limit).
I've tried every combination of OLE DB and ODBC that I can think of, using
T-SQL, Stored Procedures, and Binded calls. The DBI Trace just shows an
Error 1 - can't execute statement. Here's the error:
03/07/2001 18:35:33
update WALKER_TEMP set ANNOUNCEDDATE='2001-03-07' where ID = '3a9e6bac79'
DBD::ADO::db do failed: Can't execute statement 'update WALKER_TEMP set
ANNOUNCEDDATE='2001-03-07' where ID = '3a9e6bac79'': -2147217871: OLE
exception from "Microsoft OLE DB Provider for SQL Server":
Timeout expired
Win32::OLE(0.1401) error 0x80040e31
in METHOD/PROPERTYGET "Execute"
-2147217871: at ../dbconnect.pl line 122.
DBH Error: 1 Can't execute statement 'update WALKER_TEMP set
ANNOUNCEDDATE='2001-03-07' where ID = '3a9e6bac79'': -2147217871: OLE
exception from "Microsoft OLE DB Provider for SQL Server":
Timeout expired
Win32::OLE(0.1401) error 0x80040e31
in METHOD/PROPERTYGET "Execute"
-2147217871:
I'm not updating the text column in this case, but did read all the columns
in the table. The same code works fine if these columns are changed to
varchar.
Any Ideas?
Dan
