Options

SQL database connection problem

doubtfiredoubtfire Member Posts: 60
I am doing a small project switching from database connection from MS-Access to SQL. (syntax is fine) I got the following message and do not know where to solve it.
"The call to member Execute failed. Microsoft OLE DB Provider for SQL Server returned the following message: Invalid column name 'C'."
I have searched everywhere and compare all tables involved, and do not see difference among tables design.
Please help ! Thank you. :(

Comments

  • Options
    doubtfiredoubtfire Member Posts: 60
    Any luck or guys out there give me a hand. Thank you !
  • Options
    sendohsendoh Member Posts: 207
    hi ontario,
    "The call to member Execute failed. Microsoft OLE DB Provider for SQL Server returned the following message: Invalid column name 'C'."

    Look at your query the error message is descriptive, i think this is refer to the column name of the table. . post some of your code here.and try to figure out what's wrong.
    Sendoh
    be smart before being a clever.
  • Options
    doubtfiredoubtfire Member Posts: 60
    Thank you for the tip. It is something to do with the punctuation. :)
Sign In or Register to comment.