Retrive Data from "restore filelistonly"

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
asc
Posts: 13
Joined: Wed 03 Feb 2010 10:32
Location: Germany, Siegen (NRW)

Retrive Data from "restore filelistonly"

Post by asc » Tue 03 Feb 2015 16:50

How can i retrieve data from a "restore filelistonly"-Command? I try the MSQuery with "RESTORE FILELISTONLY FROM DISK = '<backupfile>'" and get a Metadata-Error (German Errormessage: "Die Metadaten konnten nicht bestimmt werden, weil die RESTORE FILELISTONLY FROM DISK = '<backupfile>'-Anweisung keine Metadatenermittlung unterstützt.").

azyk
Devart Team
Posts: 1057
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Retrive Data from "restore filelistonly"

Post by azyk » Thu 05 Feb 2015 12:35

Unfortunately, we can't reproduce the described problem. Please make sure that the SQL query you are using is successfully executed in SQL Server Management Studio. Use the same credentials as you used in SDAC.

asc
Posts: 13
Joined: Wed 03 Feb 2010 10:32
Location: Germany, Siegen (NRW)

Re: Retrive Data from "restore filelistonly"

Post by asc » Thu 05 Feb 2015 15:47

I have found the error. I create a own class for the query (and create the TMSQuery inside), and have set there "AutoPrepare = true"...

azyk
Devart Team
Posts: 1057
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Retrive Data from "restore filelistonly"

Post by azyk » Fri 06 Feb 2015 09:41

It is good to see that the problem has been solved. Feel free to contact us if you have any further questions about SDAC.

Post Reply