Post reply

connection problems

  • October 7, 2008 at 2:35 am

    #213718

    I am running an ASP.NET application. Quite often I am getting random error like the below:

    # Column col does not belong to table Table

    # Cannot find table 0

    # Cannot find column col

    Environment details:

    Windows 2003 Enterprise Edition

    SQL Server 2005 Enterprise Edition (Service Pack 2.0 installed)

    .NET Framework 2.0

    Driver used: SqlClient

    Please, I'm desperate with this one and don't know what to do,

    somebody help me out please

    Thanks in advance!

  • October 7, 2008 at 3:07 am

    #881494

    Hi

    How can your table name is "Table"?

    Or the table name is anything else?

    Correct your Table name...

    Thanks

  • October 7, 2008 at 3:35 am

    #881508

    guptaajay1985 (10/7/2008)

    Hi

    How can your table name is "Table"?

    Or the table name is anything else?

    Correct your Table name...

    the message is like that exactly!

  • March 2, 2012 at 5:56 am

    #1454108

    i am facing a same problem.

    please update post if you find a solution

    Thanks

  • March 2, 2012 at 6:04 am

    #1454109

    Hello,

    Post the exact SQL code which you are using.

    Regards
    Durai Nagarajan

  • March 2, 2012 at 6:39 am

    #1454126

    patrickdrd (10/7/2008)

    I am running an ASP.NET application. Quite often I am getting random error like the below:

    # Column col does not belong to table Table

    # Cannot find table 0

    # Cannot find column col

    Environment details:

    Windows 2003 Enterprise Edition

    SQL Server 2005 Enterprise Edition (Service Pack 2.0 installed)

    .NET Framework 2.0

    Driver used: SqlClient

    Please, I'm desperate with this one and don't know what to do,

    somebody help me out please

    Thanks in advance!

    The error you posted is not related to SQL but it is related to .Net actully. You are creating a DataSource & then you are referring this DataSet to get the data stored in it. However, you are not initializing it properly.

    If the DataAdapter encounters multiple result sets, it will create multiple tables in the DataSet. The tables will be given an incremental default name of TableN, starting with "Table" for Table0. If a table name is passed as an argument to the Fill method, the tables will be given an incremental default name of TableNameN, starting with "TableName" for TableName0.

    Are you sure you have defined a DataAdapter & you have called the fill method??

    Sujeet Singh

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply