[AccessD] Which SQL engines support SHAPE?

Gustav Brock gustav at cactus.dk
Thu May 1 08:05:43 CDT 2003


Hi Martin and Jim

Thanks!

To put it in other words, just to be sure:
Does this mean that SHAPE is "pseudo SQL" - a syntax of ADO, which
transforms the SHAPE sentence into normal SELECT queries which are
sent behind the scene to the engine via OLEDB? Thus any SQL engine
with an OLEDB driver can be used?

/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?



More information about the AccessD mailing list