VB & Database, Seek - Index. ADO 2.1

Seek - Index. ADO 2.1

Author	Message
Juan Lui #1 / 4	Seek - Index. ADO 2.1 Two new methods have been incorporated in ADO2.1. I am talking about seek and index. I have tried these methods with MSJET4.0 and MSDE (SQL Server 7 for Access). The two data providers returns me that these methods aren't supported. I have used all kinds of recorsets in any variants of them. Anyone knows anything about this? What's happening? Microsoft does not support his own methods? What data provider should i use to manage this methods? Any help will be appreciated. Thanks in advance.
Tue, 02 Oct 2001 03:00:00 GMT

SITAR #2 / 4	Seek - Index. ADO 2.1 I am new to VB (first week).. and using ObjGen1.1 (www.ewsystems.com) to generate code for ADO embedded sql access to an ODBC connected Access .mdb database. I tried to use SEEK and NOMATCH today and got an error. i DISCOVERED that the code which ObjGen generated is a SNAPSHOT type, which is a static cursor, and therefore... i quess, does not support the SEEK command (being a newbe i could be totally wrong here), but I realized that I could execute a REQUery AGAINST the underlying table, and product different recordsets with the record or range of records that I want, and that this served the same purpose as a SEEK.... so I gave up for now trying SEEK and NOMATCH and i am playing with REQUERY ..... but i have emailed my questions to one more knowledgable that I.. and I await their criticisms and advice... hope this helps email me ... sitaram at xxxaol.com (remove xxx) if anyone has suggestions to help me thanks
Tue, 02 Oct 2001 03:00:00 GMT

André Obelink, Obisof #3 / 4	Seek - Index. ADO 2.1 Hi, Quote: >Two new methods have been incorporated in ADO2.1. I am talking about seek >and index. >I have tried these methods with MSJET4.0 and MSDE (SQL Server 7 for Access). >The two data >providers returns me that these methods aren't supported. I have used all >kinds of recorsets in >any variants of them. >Anyone knows anything about this? What's happening? Microsoft does not >support his own methods? >What data provider should i use to manage this methods? >Any help will be appreciated. Thanks in advance. Have you set the references to ADO 2.1. When I installed ADO 2.1 I had the same problemen. Look your references are they still referencing to ADO 2.0... Andr Obelink, VBG
Wed, 03 Oct 2001 03:00:00 GMT

Juan Lui #4 / 4	Seek - Index. ADO 2.1 These are the references: Reference=...#Microsoft ADO Ext. 2.1 for DDL and Security Reference=...#Microsoft Jet and Replication Objects 2.1 Library Reference=...#Microsoft ActiveX Data Objects 2.1 Library Reference=...#Microsoft ActiveX Data Objects Recordset 2.1 Library Quote: > Hi, > >Two new methods have been incorporated in ADO2.1. I am talking about seek > >and index. > >I have tried these methods with MSJET4.0 and MSDE (SQL Server 7 for > Access). > >The two data > >providers returns me that these methods aren't supported. I have used all > >kinds of recorsets in > >any variants of them. > >Anyone knows anything about this? What's happening? Microsoft does not > >support his own methods? > >What data provider should i use to manage this methods? > >Any help will be appreciated. Thanks in advance. > Have you set the references to ADO 2.1. When I installed ADO 2.1 I had the > same problemen. Look your references are they still referencing to ADO > 2.0... > Andr Obelink, VBG
Fri, 05 Oct 2001 03:00:00 GMT

Page 1 of 1

[ 4 post ]