[freetds] Invalid cursor state error

Casey Allen Shobe cshobe at osss.net
Tue Mar 2 17:52:13 EST 2004


OK, so now I'm trying to run the same program that works via ODBC on 
Windows on linux/unixODBC/freeTDS, but no matter what, I get the 
following error for any insert I attempt:

* main::write_data:  Inserting record into table.
   --> Table:  report_sensor_stats; First value:  1218.
DBD::ODBC::st execute failed: [unixODBC][FreeTDS][SQL Server]Invalid 
cursor state (SQL-24000)(DBD: st_execute/SQLRowCount err=-1) at 
/usr/bin/dbtransfer.pl line 336.

 From MS Profiler:

declare @P1 int
set @P1=520
exec sp_prepare @P1 output, N'@P1 VARCHAR(80), at P2 VARCHAR(80), at P3 
VARCHAR(80), at P4 VARCHAR(80), at P5 VARCHAR(80), at P6 VARCHAR(80), at P7 
VARCHAR(80), at P8 VARCHAR(80), at P9 VARCHAR(80), at P10 VARCHAR(80), at P11 
VARCHAR(80), at P12 VARCHAR(80), at P13 VARCHAR(80)', N'insert into 
report_sensor_stats (stats_index, radio_state_index, sensor_mac, 
radio_id, protocol, channel_id, start_collection, end_collection, 
crc_errors, signal_strength, noise, total_bytes, total_payload_bytes) 
values (@P1, @P2, @P3, @P4, @P5, @P6, @P7, @P8, @P9, @P10, @P11, @P12, 
@P13)', 1
select @P1

exec sp_execute 520, '1218', '34', '00:01:02:03:04:0c', '2', 'a', '0', 
'2004-03-01 15:33:00', '2004-03-01 15:34:00', '0', '0', '0', '0', '0'

...and following the error...

exec sp_unprepare 520

What's going wrong?

- Casey



More information about the FreeTDS mailing list