Hard to Figure out.

[Karl Blessing]

I get this error when trying to save a persistant recordset, it has worked in the past but I Dont know why it is not working now.

the Error


Microsoft OLEDB Persistence Provider error '80040e1d'

Requested conversion is not supported.

/customreport3/report.asp, line 119


The line of code, with preceded code.(some debug info included)


set fs = server.CreateObject("Scripting.FileSystemObject&quot
filename = fs.GetTempName()
Path = server.MapPath("saveddata&quot
Path = Path & "\" & filename & ".adtg"

Set reportRS = ReportWriter.ExecuteSQL (false)
if reportRS is nothing then
Response.Write "reportRS is nothing"
else
reportRS.movefirst()
if reportRS.EOF then
Response.Write "reportRS is Empty"
else
while not reportRS.eof
Response.Write reportRS(0).value &amp; &quot;<br>&quot;
reportRS.movenext()
wend
reportRS.save Path, 0 'adPersistADTG
end if
end if


I make the thing loop to make sure there was actually valid data in the recordset, but all in all it used to be just that line in red, until I wraped the conditions around it to make sure I even had data.

any clue why this is not working?

Any help will be appreciated.
Karl
kb244@kb244.com

http://www.kb244.com

Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)

http://www.brainbench.com/transcript.jsp?pid=629151

 

[Nanda]

its not a solution to your problem but a reason of error occurance...check this. you may get some direction, to solve your problem...

http://support.microsoft.com/support/kb/articles/Q168/3/54.asp

Good Luck!!

 

[Karl Blessing]

unfortunatly that doesnt help me at all (no offense) since I already know the Error Number, I already know the Error Description, which is basically the same thing the page tells me, so I still dont know what exactly it means, nor do I know how to fix it.
Karl
kb244@kb244.com

http://www.kb244.com

Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)

http://www.brainbench.com/transcript.jsp?pid=629151

 

[Nanda]

My one more guess...
did you try removing adPersistADTG (as it is default) OR
did <!--#INCLUDE VIRTUAL=&quot;/adovbs.inc&quot; --> make any difference.

excuse me, if it does not help.

 

[Karl Blessing]

if you notice, that string is commented out, so it does not effect the code, the type is '0' , which is also the value that command defaults to if no ID is given.
Karl
kb244@kb244.com

http://www.kb244.com

Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)

http://www.brainbench.com/transcript.jsp?pid=629151

 

[giahan]

Have you tried to print out the Path if you set it correctly???
Try to put a

Response.write Path

just after the set Path = .....


Hope this helps


GH

 

[Karl Blessing]

The path is correct, I already checked that, it has worked before, but now for some reason it will not save that persistant Recordset.
Karl
kb244@kb244.com

http://www.kb244.com

Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)

http://www.brainbench.com/transcript.jsp?pid=629151