Several functions may not work. Have you tried going to Start and typing in "iexplore -extoff" (without the quotes) and pressing Enter? I've got a lot of special software installed so I don't want to reinstall. Using the site is easy and fun.
Not sure how the permissions got changed but I guess they did. You can do this in VBScript/ASP by saying: sql = "INSERT ... Which would translate in ASP as: Microsoft OLE DB Provider for SQL Server error '80040e57' String or binary data would be truncated. Windows update is current. http://www.sitepoint.com/forums/showthread.php?342133-error-80040e57
No intentes impresionarnos con lo profundo de tu angustia; mejor usa ese preciado espacio para una descripción lo más concisa posible del problema. #2 (permalink) 03/06/2003, 17:12 maestro Reply With Quote 11-27-03,07:41 #3 ranjan View Profile View Forum Posts Registered User Join Date Aug 2002 Location india Posts 41 Originally posted by rokslide basically,... Problem is that some people are putting more than 7000 characters into the description field and are getting the error below.
but I don't see that happening here). BTW, datatype should be VARCHAR, not CHAR. Problem is that some people are putting more than 7000 characters into the description field and are getting the error below. sometimes when a user enters data in, an error message [Microsoft][ODBC SQL Server Driver] string data, right truncation(#0) comes.
You may have to register before you can post: click the register link above to proceed. String Or Binary Data Would Be Truncated. WebCityTech View Public Profile View Extended RPG Stats Challenge This User To Battle Find all posts by WebCityTech Find all threads by WebCityTech Add WebCityTech to Your Buddy List #2 Edited by usasma, 09 October 2008 - 09:30 AM. - John Microsoft MVP - Windows Experience ( http://www.carrona.org/ ) **If you need a more detailed explanation, please ask for it. http://www.dbforums.com/showthread.php?972222-ERROR-String-or-binary-data-would-be-truncated Top Viewed Articles Microsoft VBScript runtime error '800a0046' Permission denied FileSystemObject The backup set holds a backup of a database other than the existing ADODB.Parameters error '800a0e7c' Parameter object is improperly
Get 1:1 Help Now Advertise Here Enjoyed your answer? Odds are that one of the fields you're trying to insert is too long for its matching database column's size (for example, sending a 35-character value to a database column that My name is Ed. I will leave a recommendation in the Cleanup topic area that this question is: To be deleted and points forfeited Please leave any comments here within the next seven days.
Latest Tweets Tweets by @cffkb Recent Articles CDO.Message.1 error '80040605' Unknown Error Compiler Error Message: BC30277: Type character '&' does not match declared data type 'String'. The SitePoint Forums have moved. I'd guess that something was installed/modified so that it interferes with both the web pages and the ACDSee program. Forgot your password?
Check each OLE DB > status value, if available. All rights reserved. The time now is 02:44 AM. I have the Knack. ** If I haven't replied in 48 hours, please send me a message.
I set the lenght to > 7000 characters and the datatype to char on the description field. > Problem is that some people are putting more than 7000 characters into > By littlelamb in forum ASP Replies: 6 Last Post: September 9th, 10:03 AM Question Microsoft OLE DB Provider for ODBC Drivers error '80040e21' By Unregistered in forum Brainstorming Area Replies: 0 SQL Server message isn't very specific....
eg you field is a varchar(10) and you are tyring to put "Help me get this right" in there..... SitePoint Sponsor User Tag List Results 1 to 2 of 2 Thread: error 80040e57? Register a free account to unlock additional features at BleepingComputer.com Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Kalyani View Public Profile View Extended RPG Stats Challenge This User To Battle Send a private message to Kalyani Find all posts by Kalyani Find all threads by Kalyani Add Kalyani
Your cache administrator is webmaster. The statement has been terminated. I've checked the DCOM settings, etc. I set the lenght to 7000 characters and the datatype to char on the description field.
DS Cluster - Follow our Sitemap
Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We Join Now For immediate help use Live now! Test-LoadGEDCOM-DB2.asp, line 39 Line 39 says: conn.Execute(TreeText) TreeText is the INSERT INTO clause above. [Person Birthplace Address] is defined in the Access db as Text 120 chars. If this is your first visit, be sure to check out the FAQ by clicking the link above.
No work was done. /kb/kb/submitadd.asp, line 80 Arnaldo Cabral Guest April 13th,05:29 PM #2 Re: SQL error '80040e21' when adding more text than the Field can handle >I have a field How can I resolve this? I'm running Windows Vista Home Premium on an HP Pavillion dv6000. Quick Navigation Classic ASP Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums Forums Home Forums Community Center News & Announcements General Discussions Introductions Talk With The Experts Website
I'd bet on Person Surname or Person Deathplace Address. You will have to inspect the table's schema (list of fields and field types and field sizes) to find the culprit.