Persisting RS to file

[aceland]

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

[aceland]

File could not be created because of authority problems. Temp-directory works fine.