Invalid cursor state - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Invalid cursor state

Author

Topic

tkotey
Yak Posting Veteran

75 Posts

Posted - 2008-07-15 : 08:57:43

Hi

Below is an error i am getting. The statement that is being used is just after it. I am not sure what the error means. Please take a look at it.

SQLExecDirect, State=24000, Native Err= 0, ODBC Err= [Microsoft][ODBC Driver Manager] Invalid cursor state

Insert Into Bills(BillType, UserIndex, BillStartDate, BillEndDate, CreateDate, Emailed, Charged, EmailedSessions, Exported1, Exported2) Values(1, 294, {ts '2008-07-04 00:00:00'}, {ts '2008-07-14 23:59:59'}, {ts '2008-07-15 11:11:26'}, 0, 0, 0, 0, 0)

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-15 : 09:14:31

STOP USING ODBC FUNCTION CALLS!

INSERT	Bills
	(
		BillType,
		UserIndex,
		BillStartDate,
		BillEndDate,
		CreateDate,
		Emailed,
		Charged,
		EmailedSessions,
		Exported1,
		Exported2
	)
VALUES	(
		1,
		294,
		'2008-07-04 00:00:00',
		'2008-07-14 23:59:59',
		'2008-07-15 11:11:26',
		0,
		0,
		0,
		0,
		0
	)

E 12°55'05.25"
N 56°04'39.16"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources