Menu
    KNOWLEDGE BASE

    Error "Incorrect syntax near the keyword ... Statement(s) could not be prepared" Creating Extract

    Published: 07 Nov 2013
    Last Modified Date: 19 Nov 2017

    Issue

    When creating an extract of a Microsoft SQL Server data source, the following error might occur:

    [Microsoft][ODBC SQL Server Driver][SQL Server] Incorrect syntax near the keyword 'on'.
    [Microsoft][ODBC SQL Server Driver][SQL Server] Incorrect syntax near 'TableauSQL'.
    [Microsoft][ODBC SQL Server Driver][SQL Server] Statement(s) could not be prepared

    Environment

    • Tableau Desktop
    • Microsoft SQL Server
    • ODBC Driver

    Resolution

    1. Upgrade Microsoft SQL Server driver to current version.
    2. Use native Microsoft SQL Server connector instead of using ODBC connector.
    Did this article resolve the issue?    
    PRINT THIS PAGE
    Related Links
    Attachments

    All Support

    SUPPORT BY PRODUCT
    TOOLS & DOWNLOADS
    INFORMATION
    ASSISTANCE