Re: FMTONLY problems

Bob wrote:
Hi

I'm connecting to SQL Server 2005 using ADO 2.8
I'm capturing the data using SQL Server Profiler

Some of my queries are calling the database with FMTONLY every time
they are executed.
I expect this is because there is an error each time, as only part of
the query is being passed to the db.

You failed to provide the ADO code that is causing this behavior.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Re: Access and processor usage
    ... "increased bandwidth" using ADO. ... bottleneck - need to step up to Sql Server. ... If the data fits into a 2 GB database file, ...
    (comp.databases.ms-access)
  • Re: How to access the SQL server express from mfc application?
    ... There are different ways to do this via MFC. ... You could certainly try ADO, ... the entire contents of the database to a SQL Server Standard Server. ...
    (microsoft.public.vc.mfc)
  • Re: Connecting to a SQL Server 2005 using VBA and ADO
    ... dao should work just fine.... ... the above example when using sql server, or a plan Jane un-split database, ... I would not use findfirst even when not using sql server unless the data set ... Microsoft since they now seem to be favoring ADO. ...
    (microsoft.public.access.formscoding)
  • Re: How to access the SQL server express from mfc application?
    ... There are different ways to do this via MFC. ... You could certainly try ADO, ... the entire contents of the database to a SQL Server Standard Server. ...
    (microsoft.public.vc.mfc)
  • Re: Access and processor usage
    ... developers to get together and develop reproducible test scenarios, ... See http://www.QBuilt.com for all your database needs. ... "increased bandwidth" using ADO. ... bottleneck - need to step up to Sql Server. ...
    (comp.databases.ms-access)