Microsoft OLE DB Provider for SQL Server error "80040e14"
am 26.07.2005 21:04:02 von TimI've been coding a website for several weeks now using SQL Server 2000 with
SP3 installed. Everything was working fine for the last several weeks.
This week, when I went to view my front page, I was greeted with a
half-rendered page and this error at the bottom:
Microsoft OLE DB Provider for SQL Server error '80040e14'
A floating point exception occurred in the user process. Current transaction
is canceled.
The error also provided a line # in my ASP code which was for a query to my
database. Oddly enough, the tables being queried don't even contain one
single floating point number:
objRS.Open "SELECT DISTINCT TOP 1 Users.Nickname, Users.Email, Users.UserID,
Permissions.ModifyProducts, Permissions.WebAccessible FROM Users INNER JOIN
Permissions ON Users.PermissionsID = Permissions.PermissionsID WHERE
(Users.Email = '" & Request.Form("Email") & "') AND (Password = '" &
Request.Form("Password") & "')", objConn
This code only runs when Len(Request.Form("Email"))>0 And
Len(Request.Form("Password"))>0
Furthermore, the error does not always occur. I can use the page
sucessfully several times before getting this error. The table Users
contains a few integers and a tinyint and the Permissions table has 2
tinyints and several boolean fields.