Lookup executes 3 time upon Recordset.Save
- From: "Julian Madle" <julian@xxxxxxxxxxxxxxxx>
- Date: Mon, 30 Jan 2006 14:54:33 +0100
Getting really strange problem using Recordset.Save: my SQL command gets
executed three times (tested on SQL Server 2000 and 2005 using both sqloledb
and {SQL Server} drivers):
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open("Driver={SQL Server}; Server=localhost; Database=DBname; User
ID=Username; Password='password'")
Set RS = objConn.Execute("SET NOCOUNT ON; SELECT ID FROM Products; INSERT
INTO DebugLog (Message) VALUES ('Done'); SET NOCOUNT OFF")
RS.Save "c:\output.xml", 1
Set RS = Nothing
objConn.Close
Set objConn = Nothing
When executed (once) there will be three 'Done' messages in the table named
DebugLog. This does not occur when the (exetremly simplified) SQL is
executed directly inside SQL Server, or when RS.Save is not called. This
looks like a bug in ADO to me.
Can anybody confirm this behaviour and more importantly suggest a
solution/workaround?
Thanks
Julian
.
- Prev by Date: Re: ADO/ASP timeout issue
- Next by Date: Re: Using SQL to create user defined table & column names
- Previous by thread: Q: DataSets and SQL Server
- Next by thread: Lookup executes 3 time upon Recordset.Save
- Index(es):
Relevant Pages
|
