Welcome to WebmasterWorld Guest from 54.204.100.232

Forum Moderators: open

Message Too Old, No Replies

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

Microsoft OLE DB Provider for ODBC Drivers error '80040e07'

   
9:49 am on Sep 13, 2005 (gmt 0)

10+ Year Member



Hi
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.