这个问题原因？

2003-10-26 04:20:58 82 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

Cartographer全局重定位优化：无初始位姿约束的2万平工厂秒级定位实践本文深入解析了Cartographer在2万平工业场景中的全局重定位优化实践，通过分支定界优化、子图动态加载和多传感器融合等关键技术，实现了无初始位姿约束下的秒级重定位。特别针对大场景下的快速重定位需求，优化后的系统在RK3588平台上表现出色，定位耗时从47秒降至1.8秒，成功率提升至91%，为工业自动化提供了高效解决方案。阅读详情

错误提示：错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC 驱动程序不支持所需的属性。
/线路工作票/first/write_1.asp, 第 212 行

浏览器类型：
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.0.3705)

网页：
显示是好的，但当我查询是出错：
代码：
dim bgcolor
set rs3=server.createobject("adodb.recordset")
if WorkGroup="" then
if TicketState="" then
if PlanBeginWorkTime_1="" and PlanEndWorkTime_1="" then
SQL ="select * from WorkTicketInfo where TicketClass=1 order by ID desc"
elseif PlanBeginWorkTime_1<>"" and PlanEndWorkTime_1<>"" then
SQL ="select * from WorkTicketInfo where TicketClass=1 and PlanBeginWorkTime between " & "#" & PlanBeginWorkTime_1 & "# and #" & PlanEndWorkTime_1 & "# order by ID desc"
end if
elseif TicketState<>"" then
if PlanBeginWorkTime_1="" and PlanEndWorkTime_1="" then
SQL ="select * from WorkTicketInfo where TicketClass=1 and TicketState="&TicketState&" order by ID desc"
elseif PlanBeginWorkTime_1<>"" and PlanEndWorkTime_1<>"" then
SQL ="select * from WorkTicketInfo where TicketState="&TicketState&"and TicketClass=1 and PlanBeginWorkTime between " & "#" & PlanBeginWorkTime_1 & "# and #" & PlanEndWorkTime_1 & "# order by ID desc"
end if
end if
elseif WorkGroup<>"" then
if TicketState="" then
if PlanBeginWorkTime_1="" and PlanEndWorkTime_1="" then
SQL ="select * from WorkTicketInfo where TicketClass=1 and WorkGroup='"&WorkGroup&"'order by ID desc"
elseif PlanBeginWorkTime_1<>"" and PlanEndWorkTime_1<>"" then
SQL ="select * from WorkTicketInfo where TicketClass=1 and WorkGroup='"&WorkGroup&"' and PlanBeginWorkTime between " & "#" & PlanBeginWorkTime_1 & "# and #" & PlanEndWorkTime_1 & "# order by ID desc"
end if
elseif TicketState<>"" then
if PlanBeginWorkTime_1="" and PlanEndWorkTime_1="" then
SQL ="select * from WorkTicketInfo where TicketClass=1 and TicketState="&TicketState&"and WorkGroup='"&WorkGroup&"'order by ID desc"
elseif PlanBeginWorkTime_1<>"" and PlanEndWorkTime_1<>"" then
SQL ="select * from WorkTicketInfo where TicketState="&TicketState&" and WorkGroup='"&WorkGroup&"'and TicketClass=1 and PlanBeginWorkTime between " & "#" & PlanBeginWorkTime_1 & "# and #" & PlanEndWorkTime_1 & "# order by ID desc"
end if
end if
end if
rs3.open sql,conn,1,1
用ACCESS数据库是好的，但改为SERVER SQL 就出错！帮我改一下！谢了！

...全文