Welcome to WebmasterWorld Guest from 34.238.194.166

Forum Moderators: ocean10000

Message Too Old, No Replies

Microsoft JET Database Engine error '80040e57'

     
2:15 am on Sep 6, 2009 (gmt 0)

New User

5+ Year Member

joined:Sept 6, 2009
posts: 1
votes: 0


Hi,

I run an online store and getting the follow error when you connect to it. If you refresh it, you are able to go into my online store.

Microsoft JET Database Engine error '80040e57'

The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.

/inc/globals.asp, line 409

I went to globals.asp line 409 and this is what it says

'ensure not search engine before logging visitor
if isSearchEngine() = false then
' Log user info to DB
SQLQuery = "INSERT INTO tblVisitors (sessionID, visitorIP, visitorBrowser, visitorDateTime, referrer, entryPage, searchCount, abandonedCart) VALUES ('" & session("eCartsessionID") & "','" & request.servervariables("REMOTE_ADDR") & "','" & prepString(request.serverVariables("HTTP_USER_AGENT")) & "'," & prepDate(now()) & ",'" & prepString(left(session("referrer"), 255)) & "','" & prepString(request.serverVariables("SCRIPT_NAME")) & "', 0, " & prepBoolean("false") & ");"
objConn.Execute(SQLQuery)
end if

objConn.close
set objConn = nothing

' Number of checkout customer lookups
session("lookupCount") = 0
' Number of items in cart
session("noItemsInCart") = 0
end if
end sub

How do i fix this problem?

5:03 am on Sept 6, 2009 (gmt 0)

Administrator

WebmasterWorld Administrator 10+ Year Member Top Contributors Of The Month

joined:Jan 14, 2004
posts:864
votes: 3


what is the size of the visitorBrowser Field? User-Agent string sizes can vary a great deal. And sometimes User-Agents will vary on the first page view vs second page views.