求教:打开SQL Server的问题!

[boyeexie]

我用如下方法打开SQL Server:

db="database/CIU_WEB.dsn" '数据库文件的位置
Set conn = Server.CreateObject("ADODB.Connection")
connstr="FileDSN=" & Server.MapPath(db)
conn.Open connstr

出现如下错误：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]用户 'XIE\IUSR_XIE' 登录失败。
/inc/conn.asp, 第 8 行

请教原因!急等!谢谢!

[tjficcbw]

<%
Dim myconn_STRING
myconn_STRING = "driver={SQL server};server=(local);uid=用户名;pwd=密码;database=tjdtt;"
set conn=server.createobject("adodb.connection")
conn.open myconn_STRING
Set rs = Server.CreateObject("ADODB.Recordset")
SQL = "SELECT forumID FROM bbs ORDER BY id DESC"
rs.Open SQL,conn,2,3
%>

这样可以了

[tjficcbw]

tjdtt为你的数据库名

[boyeexie]

tjficcbw(津津):
你好!
我用你的方法试了!还是不行
是这样的:
<%
dim conn
dim connstr
Set conn = Server.CreateObject("ADODB.Connection")
connstr="driver={SQL server};server=XIE\CIU;database=CIU_WEB;"
conn.Open connstr
%>

其中,计算机名:XIE;SQL服务器名:CIU;没有用户名和密码,数据库名:CIU_WEB

还是有如下错误:

错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D)
[Microsoft][ODBC SQL Server Driver][SQL Server]用户 'XIE\IUSR_XIE' 登录失败。
/inc/conn.asp, 第 7 行

请教问题出在哪?怎样解决?

急盼答复!忘大家帮忙!

[wanghongtaoleifeng]

没有用户和密码是不是要写上为空啊 不太清楚 还没有试过没有名字和密码的 你试验一下

[hqppp]

SQL没有名字?不可能吧!最少也要有个sa
Dim ConnStr
Set Conn=Server.CreateObject("ADODB.Connection")
ConnStr="Driver={SQL Server};Server=(local);UID=sa;PWD=;Database=shop"
Conn.ConnectionString=ConnStr
Conn.Open

[李尸尸]

你首先看你错误地方，是登录失败，见楼上，如果是空密码的话，用楼上的，有密码你在PWD后跟上密码就可以了！
Dim ConnStr
Set Conn=Server.CreateObject("ADODB.Connection")
ConnStr="Driver={SQL Server};Server=(local或127.0.0.1或服务器名);UID=sa;PWD=密码;Database=数据名"
Conn.ConnectionString=ConnStr
Conn.Open

[liuyangxuan]

原因一：可能是您的密码或用户错误。
ODBC


Standard Security:

"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asdasd;"



Trusted connection:

"Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connection=yes;"



Prompt for username and password:

oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;"



OLE DB, OleDbConnection (.NET)


Standard Security:

"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=asdasd;"



Trusted Connection:

"Provider=sqloledb;Data Source=Aron1;Initial Catalog=pubs;Integrated Security=SSPI;"
(use serverName\instanceName as Data Source to use an specifik SQLServer instance, only SQLServer2000)
Prompt for username and password:

oConn.Provider = "sqloledb"
oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Data Source=Aron1;Initial Catalog=pubs;"



Connect via an IP address:

"Provider=sqloledb;Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=pubs;User ID=sa;Password=asdasd;"
(DBMSSOCN=TCP/IP instead of Named Pipes, at the end of the Data Source is the port to use (1433 is the default))