FreeTDS Development Group

[Casey Allen Shobe <cshobe AT osss.net>]

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),@P2 VARCHAR(80),@P3 
VARCHAR(80),@P4 VARCHAR(80),@P5 VARCHAR(80),@P6 VARCHAR(80),@P7 
VARCHAR(80),@P8 VARCHAR(80),@P9 VARCHAR(80),@P10 VARCHAR(80),@P11 
VARCHAR(80),@P12 VARCHAR(80),@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