Skip to Content.
Sympa Menu

freetds - [freetds] Invalid cursor state error

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Casey Allen Shobe <cshobe AT osss.net>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Invalid cursor state error
  • Date: Tue, 02 Mar 2004 17:52:13 -0500

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




Archive powered by MHonArc 2.6.24.

Top of Page