我的数据库是ACCESS,用的ODBC连接浏览的时候出现以下错误。:MicrosoftOLEDBProviderforODBCDriverserror'80004005'[Microsoft][ODBCDriverManager]Datasourcenamenotfoundandnodefau...
我的数据库是ACCESS,用的ODBC连接
浏览的时候出现以下错误。:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/fittings.asp, line 10
在本地测试时都正常,但传到服务器上就会出现上面的错误代码。
我的CONN里面的参数:
' FileName="Connection_odbc_conn_dsn.htm"
' Type="ADO"
' DesigntimeType="ADO"
' HTTP="false"
' Catalog=""
' Schema=""
Dim MM_wall_STRING
MM_wall_STRING = "dsn=wall;"
%>
网页里的代码如下:
Dim rsfittings
Dim rsfittings_numRows
Set rsfittings = Server.CreateObject("ADODB.Recordset")
rsfittings.ActiveConnection = MM_wall_STRING
rsfittings.Source = "SELECT * FROM fittings"
rsfittings.CursorType = 0
rsfittings.CursorLocation = 2
rsfittings.LockType = 1
rsfittings.Open()
rsfittings_numRows = 0
%>
请哪位高人给指点一下,现在这里谢谢大家了!
展开