Automatic sp_prepare statement

From: Mario (mcsjr_at_ig.com.br)
Date: 09/28/04

  • Next message: Eduardo Martinez: "Diference between ADO and BDE" 
    Date: Tue, 28 Sep 2004 11:43:18 -0300

    Hi everybody,

    I have an application built in Delphi, that makes a connection to SQL Server
    2000 using ADO. In the SQL Server Profiler, the querys apear to be executed
    with the sp_prepare statement. Does the Delphi, or de ADO used by Delphi,
    puts the sp_prepare automatically when I run a query?

    Tks,

    Mario

  • Next message: Eduardo Martinez: "Diference between ADO and BDE"

    Relevant Pages

    • Re: sp_prepare statement
      ... >I have an application built in Delphi, that makes a connection to SQL Server ... the querys apear to be executed ... Does the Delphi, or de ADO used by Delphi, ...
      (borland.public.delphi.database.ado)
    • sp_prepare statement
      ... I have an application built in Delphi, that makes a connection to SQL Server ... the querys apear to be executed ... Does the Delphi, or de ADO used by Delphi, ...
      (borland.public.delphi.database.ado)
    • Re: dbExpress or ADO?
      ... dbExpress or ADO? ... >Does the answer change for Delphi 2005? ... I would use ADO it is optimized for Microsoft's SQL server and Access. ...
      (borland.public.delphi.database.ado)
    • delphi 7 ADO application and sql server 2005
      ... I have to upgrade a database from 2000 to sql server 2005. ... Will my delphi 7 ado application still work properly? ... I'm just talking about delphi's ado components compatability with SQL server 2005. ...
      (borland.public.delphi.non-technical)
    • Transaction isolation leven
      ... Why I need to set transaction isolation leven for each query using ADO? ... I´m using Delphi 5 and SQL Server 2000. ... Cleiber. ...
      (borland.public.delphi.database.ado)