[AccessD] Which SQL engines support SHAPE?

Gustav

Send you an article of list.

Martin

----- Original Message -----
From: "Jim DeMarco" <Jdemarco at hshhp.org>
To: "accessd" <accessd at databaseadvisors.com>
Sent: Thursday, May 01, 2003 1:13 PM
Subject: RE: [AccessD] Which SQL engines support SHAPE?


> Gustav,
>
> I believe Shape is an ADO object introduced in ADO 2.0.  Here's some info
from help but it looks like it might work with any OLEDB compatible data
source.
>
> <help snip>
> The Microsoft Data Shaping Service for OLE DB service provider supports
the construction of hierarchical (shaped) Recordset objects from one or more
data providers.
>
> Provider Keyword
>
> To invoke the Data Shaping Service for OLE DB, specify the following
keyword and value in the connection string.
>
> "Provider=MSDataShape"
>
>
> </help snip>
>
> HTH,
>
> Jim DeMarco
> Director of Product Development
> HealthSource/Hudson Health Plan
>
>
> -----Original Message-----
> From: Gustav Brock [mailto:gustav at cactus.dk]
> Sent: Thursday, May 01, 2003 4:48 AM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] Which SQL engines support SHAPE?
>
>
> Hi all
>
> Is SHAPE (returning sub recordsets within a recordset) in SQL
> proprietary of Microsoft SQL Server?
>
> Or do some other SQL engines support this too?
>
> /gustav
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>
****************************************************************************
*******
> "This electronic message is intended to be for the use only of the named
recipient, and may contain information from Hudson Health Plan (HHP) that is
confidential or privileged.  If you are not the intended recipient, you are
hereby notified that any disclosure, copying, distribution or use of the
contents of this message is strictly prohibited.  If you have received this
message in error or are not the named recipient, please notify us
immediately, either by contacting the sender at the electronic mail address
noted above or calling HHP at (914) 631-1611. If you are not the intended
recipient, please do not forward this email to anyone, and delete and
destroy all copies of this message.  Thank You".
>
****************************************************************************
*******
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>