Ado Error 80040e57
Contents |
80040e57? The SitePoint Forums have moved. You can now find them here. This forum is now closed to new posts, but you can browse
Microsoft Ole Db Provider For Odbc Drivers Error '80040e57'
existing content. You can find out more information about the move and how 80040e57 truncated to open a new account (if necessary) here. If you get stuck you can get support by emailing forums@sitepoint.com
String Or Binary Data Would Be Truncated.
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. SitePoint Sponsor User Tag List Results 1 to 2 of 2 Thread: error 80040e57? Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Jan 31, 2006,07:57 #1 jleggett View Profile View Forum Posts SitePoint Enthusiast Join Date Jul 2004 Location Baltimore Posts 64 Mentioned 0 Post(s) Tagged 0 Thread(s) error 80040e57? I am getting the following error message: Microsoft OLE DB Provider for ODBC Drivers error '80040e57' [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. /planroomproviders/form/confirmation.asp, line 34 I have gone through the code and commented out places to try to fix the problem, but I am not having any luck. And I readup on the error message from this site: http://www.aspfaq.com/show.asp?id=2289 , but still no luck. If anyone has any suggestions, I would be greatful, I am providing the code below: <%@ Language=VBScript %> <% Dim firstname, lastname, company, title, address1, address2, city, states, zip, country, phone, fax, email, web, clients, comments, dates Dim sConnString, connection, sSQL firstname = request.form("firstname") lastname = request.form("lastname") company = request.Form("company") title = request.form("title") address1 = request.form("address1") address2 = request.form("address2") city = request.form("city") state = request.form("state") zipcode = request.form("zipcode") country = request.form("country") phone = request.Form("phone") fax = request.form("fax") email = request.form("email") web = request.form("weburl") clients = request.form("clients") comments = request.form ("comments") dates = Now() 'SQL Connection sSQL =
in message news:3b3a0291_1@dnews... Quote> Hi All, > I am working with SQL Server and ADO on Delphi 6 with the MS OLE DB Provider > for SQL Server. > I am having some difficulty with errors from the OLE DB layer. > e.g. I have been testing with an update to a table with a value that is > larger than the field can hold. This of course generates an error but what I > get back from ADO is an EOLEException with message 'OLE error 80040e57'. > I trap this error http://www.sitepoint.com/forums/showthread.php?342133-error-80040e57 and iterate through the errors collection on the ADO > collection but do not get a description of the error that occurred. > I have also tested with a key violation error and get the same results. > Does anyone know how to get a description of the errors that can occur at > the OLE DB layer?? http://delphigroups.info/2/75/214520.html Is there a list of error codes to meaningful descriptions > anywhere? > Thanks > Joe Lippa. Brian Bushay Team Delphi Developer Tue, 16 Dec 2003 12:26:40 GMT Re:ADO Error codes Quote>I'm still confused as to why the errors collection on the ADO Connection >does not include an error description. I belive there is a bug in ADO 2.6 that loose error messages when the system locale set the same as the user Locale. -- Brian Bushay (TeamB) Bbus...@NMPLS.com Joe Delphi Developer Tue, 16 Dec 2003 14:29:27 GMT Re:ADO Error codes Thanks - I'll investigate this. Brian Bushay TeamB
Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job https://www.experts-exchange.com/questions/22712994/MSSQL-OLE-DB-Provider-for-SQL-Server-error-'80040e57'.html Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts http://www.aspmessageboard.com/showthread.php?86332-ODBC-Drivers-error-80040e57 Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > MSSQL OLE DB Provider for SQL Server error '80040e57' Want to Advertise Here? Solved MSSQL OLE DB Provider for SQL Server error '80040e57' Posted on 2007-07-22 Databases ASP MS SQL Server 3 Verified Solutions 5 Comments 1,446 Views Last ado error Modified: 2008-09-13 We're seeing an SQL error on our websites after yesterday's migration from WIN2K Server, SQL2000, IIS5 to a new WIN2003 Server Standard with IIS6, MSSQL Server 2005 . When we first access an asp page, we occasionally get the following SQL error: ------------------------------------------ Microsoft OLE DB Provider for SQL Server error '80040e57' String or binary data would be truncated. /inc/globals.asp, line 355 ------------------------------------------ Line 355 ado error 80040e57 of the "globals" file is: objConn.Execute(SQLQuery) The Code before that is: randomize session("ShopSessionID") = Session.sessionID & "_" & year(date()) & minDigits(month(date()), 2) & minDigits(day(date()), 2) & "_" & minDigits(hour(now()), 2) & minDigits(minute(now()), 2) & minDigits(second(now()), 2) & "_" & minDigits(int(((1000-1) * rnd) + 1), 4) ' Log user info to DB SQLQuery = "INSERT INTO tblVisitors (sessionID, visitorIP, visitorBrowser, visitorDateTime, referrer, entryPage, abandonedCart) VALUES ('" & session("ShopSessionID") & "','" & request.servervariables("REMOTE_ADDR") & "','" & prepString(request.serverVariables("HTTP_USER_AGENT")) & "'," & prepDate(now()) & ",'" & prepString(left(session("referrer"), 255)) & "','" & prepString(request.serverVariables("SCRIPT_NAME")) & "', " & prepBoolean("false") & ");" This worked with no problem on the old server. 0 Question by:lwork Facebook Twitter LinkedIn Google LVL 50 Best Solution byLowfatspread print the contents of SQLQuery.... how did you convert the database to sql 2005? show us the ddl of the tblvisitors Go to Solution 3 Comments LVL 50 Overall: Level 50 MS SQL Server 39 Databases 15 ASP 3 Message Accepted Solution by:Lowfatspread2007-07-22 print the contents of SQLQuery.... how did you convert the database to sql 2005? show us the ddl of the tblvisitors 0 LVL 29 Overall: Level 29 MS SQL Server 16 Databases 4 ASP 3 Messa
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 3 of 3 Thread: ODBC Drivers error 80040e57 Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 07-17-200105:12 PM #1 John Magnus Guest ODBC Drivers error 80040e57 I've got a really big problem (at least it's to me). I would really appreciate some help as I haven't got a clue why this doesn't work... I'm trying to fetch some specific data from my database, but the code I've written only works on my local machine (Access/PWS) not on the server (Access/IIS). I have no idea of what's going on... (Other functions works just fine!)
' ***COMMAND*** '
SqlCommand = _
& "SELECT * FROM News"_
& " WHERE Approved=True"_
& " AND Value1<" & TestValue_
& " AND Value2>" & TestValue_
& " ORDER BY Value1 ASC, Value2 DESC;"
Set dbCommand1 = Server.CreateObject ("ADODB.Recordset")
Set dbCommand1 = dbConnection.Execute (SqlCommand)
' ***ERROR*** '
Microsoft OLE DB Provider for ODBC Drivers error '80040e57'
[Microsoft][ODBC Microsoft Access Driver]Numeric value out of range (null)
/_inc/common.asp, line 105 Reply With Quote 07-17-200105:42 PM #2 Moshe View Profile View Forum Posts Senior Member Join Date Dec 1969 Posts 723 RE: ODBC Drivers error 80040e57 Do a "response.write SqlCommand" right after creating the SQL statement. I bet one of the values is null.
Also, WHERE approved=True should be WHERE approved='True' if approve is character field. Reply With Quote 07-17-200106:32 PM #3 John Magnus Guest RE: ODBC Drivers error 80040e57 Good tip! I tested it, and all variable