ODBC - FMTONLY

Hot Topic

can't start mssqlserver
Parameters in Client Report Builder
FOR XML streamed?
Missing labels in chart bar the X axis
Error 6522 Trying to Run Assembly from database
sorting the packages in the solution explorer window
Changing page size
Empty Source So there is no data in the pipleline
SQL Express on Win XP Pro 64
Update SQL Server 2005 Install files

SQL Server

Problem with Simple ScriptTask
Table control causes pdf Format skipping pages
Report's Parameter : From Date to Date
How to access NS remotly?
Performance considerations in storing a measure (such as ext sales amt from qty * sales price) vs calculated member?
Best Practices Analyzer
Materialized View Doesn't Materialize. (and queries on MVs ignore index hints)
memory could not be read
An issue with ReplicationUser
Time Intelligence Wizard script shortcomings

ODBC - FMTONLY

Hi There

I need to know if the "perform translation for character data" odbc connection option is responsible for SET FMTONLY statements, i think it is but i cannot find 100% confirmation from knowledge base articles or various searches.

Secondly if this option is unchecked will it stop FMTONLY statements completely.

Thirdly if it is enabled, what is responsible for FMTONLY statements not having a where clause the odbc driver or the application using the odbc connection, i am sure it is the application but once again , i need confirmation.

Thank You


Answer this question

ODBC - FMTONLY

  • Billr17

    The following looks as though it may be related to your problem

    http://support.microsoft.com/kb/836830/

    FMTONLY is used by ODBC and OLE DB to get metadata for a query qithout actually executing the query. Sometimes the query would get executed and this would explain the long execution times you are seeing.

    What versions of software are you using

  • Glenn Qiu

    Hi Chris

    That is my issue.Millions of set fmtonly statements are being generated.
    So this is directly application related
    My issue is that no FMTONLY statements have where clauses, is this also application responsible

    I have issues where sometimes a FMTONLY statements that normally takes 0 Duration takes 60-90 seconds, if you know about this please check out the TSQL forum for my question.

    Do you have a good link or article about ODBC and specifically FTMONLY

    Thank You

  • !Leonardo

    No, the two are seperate. 'SET FMTONLY' is used when the driver needs metadata before a statement has been executed. The driver turns FMTONLY OFF as soon as it has the metadata. You can check what's happening with SQL Profiler. The driver uses FMTONLY internally inresponse to some sequences of ODBC calls. An application could also execute SET FMTONLY statements itself. An ODBC trace would show if the application is doing this.

  • ODBC - FMTONLY
Answer this question