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
    1658 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.
  • Article 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