[freetds] Invalid cursor state error
Casey Allen Shobe
cshobe at osss.net
Tue Mar 2 17:53:55 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? Is there something I need to do differently in my
script or is this a freetds configuration issue?
Thanks in advance,
- Casey
More information about the FreeTDS
mailing list