CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

 CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.
  • Breadrumbs:

  • Microsoft OLE DB Provider for SQL Server error '80040e14' Incorrect syntax near '@P14'.

    • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • Article ID:
    205
  • Date Created
    Saturday, January 11, 2014
  • Last Updated
    Wednesday, February 26, 2014
  • This Article Has been Viewed
    1604 times
  • Short Desc
    SQL Server Error 80040e14 is a common error, however, when you deal with the sql statements, and invalid characters, it can cause you to look for something that is not there.
  • Details
    when writing out your sql statements, you have to make sure that you type everything out properly. If not, then you could have an issue, such as the one that this article is about.

     
    Microsoft OLE DB Provider for SQL Server error '80040e14'
    Incorrect syntax near '@P14'.
    /File.asp, line 295
  • Recreate Issue
    Recreate this issue

    <%
    sql.commandtext="insert into table1 (col1, col2, col3, col4)values(?,?,?.?)"
    %>


    As you can see in this demonstration, there is a period below the last question mark in our statement. This will cause the error.
  • Resolve Issue
    Resolve this issue.

    <%
    sql.commandtext="insert into table1 (col1, col2, col3, col4)values(?,?,?,?)"
    %>


    Make sure that you do not have any objects that do no properly belong in your statement.

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles