ADO Seek command 1

[sheykc]

I am trying to use ADO's seek command against data that I returned from a Sybase SQL server via a stored procedure.

When I issue the seek command, I get a VB error that says "Object or provider is not capable of performing requested operation". The provider I'm using is MSDASQL.

Any suggestions?

 

[LazyMe]

From the MDAC SDK:

Use the Seek method in conjunction with the Index property if the underlying provider supports indexes on the Recordset object. Use the Supports(adSeek) method to determine whether the underlying provider supports Seek, and the Supports(adIndex) method to determine whether the provider supports indexes. (For example, the OLE DB Provider for Microsoft Jet supports Seek and Index.)

If Seek does not find the desired row, no error occurs, and the row is positioned at the end of the Recordset. Set the Index property to the desired index before executing this method.

This method is supported only with server-side cursors. Seek is not supported when the Recordset object's CursorLocation property value is adUseClient.

This method can only be used when the Recordset object has been opened with a CommandTypeEnum value of adCmdTableDirect.


Greetings,
Rick

 

[sheykc]

I would like to use the seek method, but apparently I don't have the right kind of provider. Does anyone know which provider to use for Sybase 12?

 

[CCLINT]

Can you not use the Find method? [/b][/i][/u]_{*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!}

 

[sheykc]

I am using the find method, but I'm also working with 250K records. From what I've read, the seek command is faster, so that's why I wanted to use it.