Hi
If I convert my dataset (8000 rows) to an XML file is it possible to pass sql query against this file at different intervals or as long as the file exists

Thanks

Chris:

You can persist your dataset to XML, and then deserialize when you need it.
When you need to search, filter, edit etc, you'll be using the DataSet
object or one of hte XML objects. With that said, what is the ultimate
goal you are getting at?
"Chris" <(E-Mail Removed)> wrote in message
news:46405284-5AA5-4315-B805-(E-Mail Removed)...
> Hi,
> If I convert my dataset (8000 rows) to an XML file is it possible to pass
sql query against this file at different intervals or as long as the file
exists?
>
> Thanks

Hi
I have a progress database on a unix server and a database on sql 2000 server. I have related data in both databases. Example primary keys in one database are foreign keys in the other database. I need to query both databases at the same with single nested queries. I tried creating a link server in sql 2000 to the progress database... no luck there. I have no ideas. Can I use web services (soap) to get the data from the progress database? What would you recommend

Thanks

You can use Web Services which is a very good option. What problem are you
having with Linked Servers? If possible, that would probably be the easiest
thing to do. Or, depending on your needs, run a DTS package to move the
data to SQL Server and query from there.

However, you can query both db's, and just use different data adapters to
update your different datasources. I'd probably go with this or using a Web
Service if I couldn't get the linked server to work.

HTH,

Bill
"Chris" <(E-Mail Removed)> wrote in message
news:996827AA-50DC-4152-AE8D-(E-Mail Removed)...
> Hi,
> I have a progress database on a unix server and a database on sql 2000
server. I have related data in both databases. Example primary keys in one
database are foreign keys in the other database. I need to query both
databases at the same with single nested queries. I tried creating a link
server in sql 2000 to the progress database... no luck there. I have no
ideas. Can I use web services (soap) to get the data from the progress
database? What would you recommend.
>
> Thanks