UC知道如何用asp代码实现商品分类显示
来源：百度知道 编辑：UC知道 时间：2024/05/25 20:38:29
我在Dreamweaver中使用控制面板添加了一段商品分类显示代码：<%
Dim rs1__MMColParam
rs1__MMColParam = "1"
If (Request.QueryString("catalogID") <> "") Then
rs1__MMColParam = Request.QueryString("catalogID")
End If
%>
<%
Dim rs1
Dim rs1_numRows
Set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.ActiveConnection = MM_db_STRING
rs1.Source = "SELECT * FROM products WHERE catalogID = " + Replace(rs1__MMColParam, "'", "''") + ""
rs1.CursorType = 0
rs1.CursorLocation = 2
rs1.LockType = 1
rs1.Open()
rs1_numRows = 0
%>
在IIS测试没问题，可上传到网站服务器中，却出错，提示：“Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Selected collating sequence not supported by the operating system.
/product_categories_en.asp, line 27
”
其
Dim rs1__MMColParam
rs1__MMColParam = "1"
If (Request.QueryString("catalogID") <> "") Then
rs1__MMColParam = Request.QueryString("catalogID")
End If
%>
<%
Dim rs1
Dim rs1_numRows
Set rs1 = Server.CreateObject("ADODB.Recordset")
rs1.ActiveConnection = MM_db_STRING
rs1.Source = "SELECT * FROM products WHERE catalogID = " + Replace(rs1__MMColParam, "'", "''") + ""
rs1.CursorType = 0
rs1.CursorLocation = 2
rs1.LockType = 1
rs1.Open()
rs1_numRows = 0
%>
在IIS测试没问题，可上传到网站服务器中，却出错，提示：“Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Selected collating sequence not supported by the operating system.
/product_categories_en.asp, line 27
”
其
很多问题，你如果会用百度，应该能够解决的。
我刚刚在百度帮你搜索了一下：“解决Access错误 Selected collating sequence not supported by the operating system”
找到这篇文章：http://hi.baidu.com/ortec/blog/item/d313c5341ec8e5b4d0a2d3c1.html
大概意思是你的服务器使用的是英文版的操作系统。
相信对你会有用处。
非常感谢！