求助asp访问sql server
我是sql server菜鸟,请帮忙解决以下问题:
错误:
Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'
/iisHelp/common/500-100.asp,行242
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e4d'
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'administrator'. Reason: Not associated with a trusted SQL Server connection.
/sqlservertest.asp,行6
源代码:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
db="datasys/webdata_Data.MDF"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Driver={SQL Server}; Server=JXKJ-WWG; Database=webdata; UID=administrator; PWD=iloveyou"
conn.Open connstr
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
StrCnn = "Driver={SQL Server};Server=ahui;UID=sa;PWD=;Database=enterprise"
Cnn.Open SrtCnn
</body>
</html>