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

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 08/30/04 

Date: Mon, 30 Aug 2004 13:51:38 -0500

On Fri, 27 Aug 2004 13:12:25 +0200, "Oscar" <oku@xs4all.nl> wrote:

¤ 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)

Relevant Pages

  • Any chance to replace the Seek method by converting from DAO to ADO ?
    ... 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 ...
    (microsoft.public.vb.database.ado)
  • Re: Attempt to initiate a new SQL Server operation with results pending.
    ... >your example code will not work unless you force a server-side cursor (see ... >I would seriously suggest you try and avoid multiple active statements - there ... be mortified, but I don't have too much to do with SQL server, so I'll ... just create lots of $dbh things and ->finish all the statements and hope ...
    (perl.dbi.users)
  • Re: Cannot insert or update columns from multiple tables (post #2) Need help please
    ... Provider for SQL Server) to update records from a dataset on a multi-tables ... I am using a server-side cursor ... But if I change the SQL driver to use an ODBD DataSource (Microsoft OLE DB ... Provider for ODBC Driver), is it working. ...
    (borland.public.delphi.database.ado)
  • Re: TADOQuery slow inserts in Oracle
    ... Use server-side cursor - you do not need row cache if you do only inserts on ... http://www.oledbdirect.com - The fastest way to access MS SQL Server, ... > I've used ADO before with Oracle, but never had such slow effects as I'm ... What can I do with my TADOQuery to speed up the .Post? ...
    (borland.public.delphi.database.ado)
  • Re: What is the fastest way to add a large number of records ?
    ... Try open recordset with server-side cursor and append rows without SQL - on ... If you still need speed improvement, on MS SQL Server the fastest inserts ... Server OLEDB provider and is not accessible from ADO. ...
    (borland.public.delphi.database.ado)