homepage Welcome to WebmasterWorld Guest from 54.196.63.93
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

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

5+ Year Member



 
Msg#: 29 posted 9:49 am on Sep 13, 2005 (gmt 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.

 

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved