Use a persisted XML file as datasource

[Omar]

Hi,

I have this situation. I am developing a system where i am Persisting the
data retrieved from a SQL server locally in xml files to be used offline. I
open the ADO recordsets from these files smoothly but i am trying to query
the data in these files with no success. I thought of opening a connection to
the local files but i couldn't find a provider for XML files. I thought of
building a SELECT statement over one or two recordsets but I don't know
whether it is possible or not, and if yes, I don't know how.

in short, I need to work with those persited xml files asif they were tables
that can be queried and joined.

I appreciate any help from your side as i am totally lost

 

[Stefan Hoffmann]

hi,

I have this situation. I am developing a system where i am Persisting the
data retrieved from a SQL server locally in xml files to be used offline. I
open the ADO recordsets from these files smoothly but i am trying to query
the data in these files with no success. I thought of opening a connection to
the local files but i couldn't find a provider for XML files.

I have to guess, as you don't have posted any code...

http://msdn.microsoft.com/en-us/library/bb407304(VS.80).aspx
http://www.freevbcode.com/ShowCode.Asp?ID=1204
http://support.microsoft.com/kb/262450


mfG
--> stefan <--