XLink and SQL 2000 Query

XLink and SQL 2000 Query

Post by XMLVikin » Sun, 25 Jun 2000 04:00:00



Hello all,

I'm jumping to conclusions but how exactly robust is the new URI interface
for SQL queries?  I mean can you use an href or URI to submit a query into
the SQL2000 database? And if so could you use the Extended XLink to
aggregate data sources?

I'm just rambiling but could you effectivly draw from multiple data sources
and aggregate the data identified from separate namespaces that infer a said
users data requirements?

Thanks if this is at all possible I would be very....very e*d.  The
ramifications for data feeds would be immense!..

Thank,

Eric

 
 
 

XLink and SQL 2000 Query

Post by Frank Mante » Mon, 26 Jun 2000 04:00:00


Yes, this is exactly what is possible. There are some drawbacks though:

a) if you do it clientside, you have to be really really carefull about
security
b) if you do it serverside you could run into the wininet server issue, but
assuming you use a 3rd party socket library you are fine.

Regards

Frank Mantek
Microsoft

Quote:> Hello all,

> I'm jumping to conclusions but how exactly robust is the new URI interface
> for SQL queries?  I mean can you use an href or URI to submit a query into
> the SQL2000 database? And if so could you use the Extended XLink to
> aggregate data sources?

> I'm just rambiling but could you effectivly draw from multiple data
sources
> and aggregate the data identified from separate namespaces that infer a
said
> users data requirements?

> Thanks if this is at all possible I would be very....very e*d.  The
> ramifications for data feeds would be immense!..

> Thank,

> Eric


 
 
 

XLink and SQL 2000 Query

Post by XMLVikin » Mon, 26 Jun 2000 04:00:00


Outstanding!

So tell me Frank have you come across any good code examples of use of XLink
in this fashion?

I have this nifty book VB and XML and it has shown me the XML "Light" and
well there are inferences to the future potential of this technology but
refuses to give any 'real' examples of possible implementation of such a
plan.

I have kind of jumped the gun here but...is anyone out there doing this kind
of thing...(the XLink with SQL2000 xml query interfaces to aggregate
datasources)


This is fascinating stuff and I would love to start implementing this if
it's possible.

Thanks a Million!

Eric

> Yes, this is exactly what is possible. There are some drawbacks though:

> a) if you do it clientside, you have to be really really carefull about
> security
> b) if you do it serverside you could run into the wininet server issue,
but
> assuming you use a 3rd party socket library you are fine.

> Regards

> Frank Mantek
> Microsoft


> > Hello all,

> > I'm jumping to conclusions but how exactly robust is the new URI
interface
> > for SQL queries?  I mean can you use an href or URI to submit a query
into
> > the SQL2000 database? And if so could you use the Extended XLink to
> > aggregate data sources?

> > I'm just rambiling but could you effectivly draw from multiple data
> sources
> > and aggregate the data identified from separate namespaces that infer a
> said
> > users data requirements?

> > Thanks if this is at all possible I would be very....very e*d.  The
> > ramifications for data feeds would be immense!..

> > Thank,

> > Eric