Limit data amount in response to SELECT query

Hi, I need to limit the amount of data (rows) that I get when issuing a
SELECT query to an Exchange Server.

I'm using ADO with ExOLEDB to populate a recordset with e-mails.
Unfortunately, when the user has a lot of e-mails stored on the server
it takes a veeery long time to get them all.

I'm sure there has to be a way to do this... in WebDAV there is a
'range' header you can set, and in regular SQL you can 'select top 10',
but how to do something similar here?


Thanks for any help!

.

Relevant Pages

  • Delete Data from Exchange
    ... I'm trying to delete data from the exchange server per ado, exoledb or ... what can I do with vb-Script. ...
    (microsoft.public.exchange.development)
  • Re: Query an Exchange server
    ... SQL queries are available with the ExOleDB provider and WebDAV. ... Latter is more suited for managed code and the only option in your scenario when you want to connect to the Exchange Server remotely. ... With ExOleDB, you'll use ADO. ... I want to know if it's possible to query an Exchange Server like we can ...
    (microsoft.public.exchange.development)
  • Re: Bug in msdaipp.dso Provider
    ... but we are trying to query the Exchange server ... Is there some way to use the EXOLEDB provider remotely? ... be able to query the Exchange server safely from remote machines. ...
    (microsoft.public.exchange.development)
  • Re: Add contacts to Public folder VBscript
    ... Exchange Server you can use ExOleDB with ADO: ... WebDAV is another opportnunity: ...
    (microsoft.public.exchange2000.development)
  • Disable Windows Server 2003 DNS Fallback Behavior??
    ... I'm having a strange issue with an Exchange Server which I ... It appears that every now and then a query ... mail.swartzcampbell.com Microsoft ESMTP MAIL Service, ... Unsuccessful query, fallback to A record behavior, NDRs: ...
    (microsoft.public.exchange.admin)