HTTP 500错误的解决方法
我在本机测试ASP网页是正常的,但上传到虚拟主机后就出现以下情况:Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'
[Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
/index.asp,行 8
网页第8行为:Recordset1.ActiveConnection = MM_db1_STRING
该问题要怎么样解决?
代码如下:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="Connections/db1.asp" -->
<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_db1_STRING (该句要怎么样写?)
Recordset1.Source = "SELECT * FROM 综合表"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
以下是:DB1.asp的代码:
<%
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_DB1_STRING
MM_DB1_STRING = "dsn=Microsoft Access;uid=本机帐户;pwd=本机密码;"
%>
[ 本帖最后由 lujk0865cn 于 2010-5-19 22:39 编辑 ]