Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e07'

来源：百度知道 编辑：UC知道 时间：2024/06/20 05:47:18
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e07'
[Microsoft][ODBC SQL Server Driver][SQL Server]从 char 数据类型到 datetime 数据类型的转换导致 datetime 值越界。

/vido/webvod/webmedia/admin/customer/customer_nouse.asp，行 75

<%
if szDBType = "MSSQLSERVER" then
szSQL = "SELECT * FROM v_userinfo WHERE AvailDate<DateAdd(d,1,'" & now & "') ORDER BY CusTomer_ID DESC"
else
szSQL = "SELECT * FROM v_userinfo WHERE AvailDate<DateAdd('d',1,DateValue('" & now & "')) ORDER BY CusTomer_ID DESC"
end if
rsData.PageSize = iPageAdmin
rsData.Open szSQL,con,1,3
%>
<!--#include file="../../common/pagedeal.inc.asp" -->
<%
if not rsData.EOF then
for i = 1 to rsData.PageSize
if rsData.EOF then exit for

if rsData("Status") = 1 then
szColor = "blue"
else
szCol

如zyhomepage所说，把下面该以下应该就ok了

szSQL = "SELECT * FROM v_userinfo WHERE AvailDate<DateAdd('d',1,DateValue('" & now & "')) ORDER BY CusTomer_ID DESC"

改成

szSQL = "SELECT * FROM v_userinfo WHERE AvailDate<DateAdd('d',1,DateValue(Cstr（Now)) ORDER BY CusTomer_ID DESC"

MSSQL数据库的吧？
把那两个now改成getdate()。

'" & now & "'改为" & now & "不加单引号就好了；或者now改为now(),应该就好了！