Welcome to WebmasterWorld Guest from 54.198.143.210

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)

New User

10+ Year Member

joined:Apr 25, 2005
posts:9
votes: 0


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.
 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members