aceland
May 29th, 2001, 03:26 AM
Hi! I wonder if anyone know a solution for this problem.
I have a recordset that I want to persist to a file and then get it from the file into a recordset again.
This works just fine in ide-mode and compiled to but not when running the components in MTS. (Transaction server). Saving/Persisting is ok that works fine but the open command does not work. I get the error The channel is not open for this kind of operation.
I have ADO 2.1 and are running on NT4 SP6. I know that 2.6 supports other fine features for persisting recordsets that works fine but I'm not allowed to use ado 2.5 or 6
Code-example
Persisting recordset
InRecordset.Save FileName, adPersistXML
Reading the persisted recordset
Set rsXML = CreateObject("ADODB.Recordset")
rsXML.CursorLocation = adUseClient
rsXML.Open FileName, , adOpenStatic, , adCmdFile
I have a recordset that I want to persist to a file and then get it from the file into a recordset again.
This works just fine in ide-mode and compiled to but not when running the components in MTS. (Transaction server). Saving/Persisting is ok that works fine but the open command does not work. I get the error The channel is not open for this kind of operation.
I have ADO 2.1 and are running on NT4 SP6. I know that 2.6 supports other fine features for persisting recordsets that works fine but I'm not allowed to use ado 2.5 or 6
Code-example
Persisting recordset
InRecordset.Save FileName, adPersistXML
Reading the persisted recordset
Set rsXML = CreateObject("ADODB.Recordset")
rsXML.CursorLocation = adUseClient
rsXML.Open FileName, , adOpenStatic, , adCmdFile