ODBC, SQL Server, "FOR XML" & Cursors error
From: Thomas Keegan (thomasjkeegan_at_yahoo.co.uk)
Date: 10/14/04
- Next message: Florian Hofmann: "Re: Linking To FoxPro via ODBC problem"
- Previous message: Travis Chase: "DSN caching?"
- Next in thread: Brannon Jones: "Re: ODBC, SQL Server, "FOR XML" & Cursors error"
- Reply: Brannon Jones: "Re: ODBC, SQL Server, "FOR XML" & Cursors error"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 14 Oct 2004 09:00:07 -0700
Hi,
Has anybody had any luck using the Microsoft SQLServer
ODBC drivers (Driver version: 03.81.9030, ODBC version :
03.52)
to connect to a SQL Server 2000 database and passing in a
SELECT with a FOR XML clause. I keep
getting Error [Microsoft][ODBC SQL Server Driver][SQL
Server]The FOR XML clause is not allowed in a CURSOR
statement
., State: 42000, Error: 6819.
Is there a work around (eg putting the select in a stored
procedure) or am I missing something ?
I am using SQLExecDirect() to execute the statement.
Or could any one suggest a better way to retrieve data
from a standard table in XML formated string?
Please Help!!
- Next message: Florian Hofmann: "Re: Linking To FoxPro via ODBC problem"
- Previous message: Travis Chase: "DSN caching?"
- Next in thread: Brannon Jones: "Re: ODBC, SQL Server, "FOR XML" & Cursors error"
- Reply: Brannon Jones: "Re: ODBC, SQL Server, "FOR XML" & Cursors error"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
