错误类型:Microsoft OLE DB Provider for SQL Server (0x80004005)
悬赏分:20 -
解决时间:2007-8-7 11:09错误类型:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server 不存在或拒绝访问。
代码如下
<%
dim mycon,mysql,constr
constr="provider=SQLOLEDB;data source=local;initial catalog=northwind;user id=sa;password=;"
set mycon=Server.CreateObject("ADODB.Connection")
mycon.connectionstring=constr
mycon.open
mysql="insert into register(id,name,sex,birth,diploma) values ('100,'mary','girl','1978-1-1','本科')"
mycon.execute (mysql)
mycon.close
%>