Method seek with objects ADO in sql server

P

Pierre-Yves

Hello,



We have a big application to pass access 2000 to sql server. We are going to
use objects ADO instead of objects DAO.



In the code, we use methods seek in order to search recordsets.



We tested this method seek accessing to sql server. This method isn't
possible with a provider

OLEDB1.



A solution consist in transform "method seek" in "select where" but this
operation is too long



What is the better solution?



Thank you
 
P

Perry

You cud consider to access a server side Stored Procedure
and see whether this will speed things up

Krgrds,
Perry
 
S

SA

Pierre:

Seek does generally work fine when run against SQL tables, make sure that
the last option when you open the recordset is acCmdTableDirect and that you
open a keyset and use a server side cursor.

Secondly, however, Seek on recordsets is painfully slow in general and you
should with good design be able to use Sprocs to select and update records
which are generally faster.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top