SQL database connection problem

doubtfire

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.

doubtfire

Any luck or guys out there give me a hand. Thank you !

sendoh

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.

doubtfire

Thank you for the tip. It is something to do with the punctuation.