XML

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
Hi,
If I convert my dataset (8000 rows) to an XML file is it possible to pass
Click to expand...
sql query against this file at different intervals or as long as the file
exists?
 
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 said:
Hi,
I have a progress database on a unix server and a database on sql 2000
Click to expand...
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.
 
Back
Top