Any chance to replace the Seek method by converting from DAO to ADO ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Oscar - 27 Aug 2004 12:12 GMT

I am trying to port a VB -Access-DAO application to a SQL Server 2K-ADO
environment.
Is there any chance to replace the DAO Seek method with a SQL-Server 2K ADO
method ? I've tried some cursorsettings but the DBengine still reports that
the seek method isn't supported by the provider.
It would take a very long while to replace each .Seek method with a "SELECT
* FROM ... WHERE ...." as it can't be automated.

Oscar

Reply to this Message

Veign - 27 Aug 2004 15:57 GMT

Would the Find method or Filter method work for you?

Signature

Chris Hanscom
MVP (Visual Basic)
http://www.veign.com
--

> I am trying to port a VB -Access-DAO application to a SQL Server 2K-ADO
> environment.
[quoted text clipped - 5 lines]
>
> Oscar

Reply to this Message

Paul Clement - 30 Aug 2004 19:51 GMT

¤ I am trying to port a VB -Access-DAO application to a SQL Server 2K-ADO
¤ environment.
¤ Is there any chance to replace the DAO Seek method with a SQL-Server 2K ADO
¤ method ? I've tried some cursorsettings but the DBengine still reports that
¤ the seek method isn't supported by the provider.
¤ It would take a very long while to replace each .Seek method with a "SELECT
¤ * FROM ... WHERE ...." as it can't be automated.

Haven't tried Seek with SQL Server but you would also need to specify the adCmdTableDirect option in
the Recordset Open statement in addition to using a server-side cursor.

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Reply to this Message

Veign - 30 Aug 2004 20:02 GMT

I read that SQL Server does not support the Seek Method. Seek method must
be supported by the provider.

Signature

Chris Hanscom
MVP (Visual Basic)
http://www.veign.com
--

> ¤ I am trying to port a VB -Access-DAO application to a SQL Server 2K-ADO
> ¤ environment.
[quoted text clipped - 9 lines]
> Paul ~~~ pclement@ameritech.net
> Microsoft MVP (Visual Basic)

Reply to this Message

Paul Clement - 31 Aug 2004 15:52 GMT

¤ I read that SQL Server does not support the Seek Method. Seek method must
¤ be supported by the provider.
¤
¤ --
¤ Chris Hanscom
¤ MVP (Visual Basic)
¤ http://www.veign.com

Yeah, I tried the SQL Server OLEDB Provider and it indicated that the interface does not support
indexes. It appears to be supported only in ADOCE and SQL Server CE.

Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)

Reply to this Message

VB Forum / Database Access / August 2004

Any chance to replace the Seek method by converting from DAO to ADO ?