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' The multi-part identifier

    • 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:
    118
  • Date Created
    Sunday, March 13, 2011
  • This Article Has been Viewed
    2542 times
  • Short Desc
    When you are writing your SQL Statements, make sure that your table names are spelled correctely and your columns names exist.
  • Details
    When you are writing your SQL Statement (or) have changed your table names (or) have removed a table from your database and have not updated your SQL Statements, you will encounter the following error.


     
    Microsoft OLE DB Provider for SQL Server error '80040e14'
    The multi-part identifier "Table3.Column1" could not be bound.
    /Control.asp, line 29
  • Recreate Issue
    To recreate this issue.

    sql.commandtext="select table1.Column1, table2.column1, table3.column1"

    In the example above, the table3 no longer exist in the database, there for, it cannot be accessed by our SQL Statement.
  • Resolve Issue
    To resolve the issue:

    sql.commandtext="select table1.Column1, table2.column1"

    Only use the tables that are available to you in your SQL Statements.

Recent Articles

All Topics

  • Coming Soon - Knowledge Exchange

Trending Articles