I'm using SQL Server 2005 Express edition as the Database and Microsoft VB.NET 2005 as the programming language for my project. At the moment I'm having a problem of inserting data into one of the tables in my database through my VB.NET application. I did successfully inserted data through my application to 5 tables in my database. But in this particular table only I get the error: "String or binary data would be turncated. The Statement has been terminated". This message is coming from the .NET SqlClient data provider. I then tried to insert the same data through SQL server Management Studio query editor and it worked without any problems. What might be the reason for this problem?
I also re-ran the other parts of my application where I successfully inserted data into the 5 tables and they worked fine. Please help!!!!
Software/Hardware used: Micorsoft Visual Studio 2005/VB.NET 2005, Microsoft SQL Server 2005 Express edition.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!