关于连不上数据库的问题,急~~在线
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC 驱动程序管理器] 未发现数据源名称并且未指定默认驱动程序
<%
Set conn = Server.CreateObject("ADODB.Connection")
DBPath = Server.MapPath("material.mdb")
conn.Open "driver = {Microsoft Access Driver (*.mdb)};dbq=" & DBPath
Set rs = Server.Createobject("ADODB.recordset")
sql = "materials"
rs.Open sql,conn,adOpenStatic
rs.AbsolutePosition = 1
Response.write rs(1)
%>
好奇怪哦,我用最简单的来做测试居然也通不过。
下面是用SQL来连,居然也通不过,请各位帮忙啊
<%
Set MyConn = Server.CreateObject("ADODB.Connection")
Set MyCommand = Server.CreateObject("ADODB.Command")
MyConn.Open "driver = {SQL Server};datebase = mrc;server = mrc; uid =Gavin; pwd=123456"
Set MyCommand.CommandType = adCMdStoreProc
MyCommand.CommandText = "test"
Set MyParam = MyCommand.CreateParameter("RetVal",adInteger,adParamReturnValue)
MyCommand.Parameters.Append MyParam
MyCommand.Execute
%>
There are <% = MyCommand("RetVal") %> records
<%
MyConn.Close
%>
我的test存储进程很简单 就一个(SELECT COUNT(*) From material)
谁帮我解释下啊