I'm trying to insert the value into the SQL database and i got the error of:
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting the nvarchar value 'Y' to a column of data type int.
Actually, (the column of data type int that mention in above error) the column in my database field name is nvarchar. But why i can't insert this value into it.
I tried this SQL statement
"insert into #*$! select * from xxx" . Then i got the error.
But when i tried to insert in sql query analyzer like this
"insert into xxx(col1,col2) values ('Y' , 'nnn') and it works.If anybody has an idea, please let me know. Thank you.