SQL连接问题

Question

给你个小例子
<%
Set conn = Server.CreateObject("ADODB.Connection")
DSNtemp="DRIVER={SQL Server};SERVER=zb;UID=sa;PWD=7890;DATABASE=northwind"
conn.open DSNtemp
strSQL = "SELECT FirstName, LastName FROM employees"
Set rsCustomers = Server.CreateObject("ADODB.Recordset")
rsCustomers.Open strSQL, conn
Set objFirstName = rsCustomers("FirstName")
Set objLastName = rsCustomers("LastName")
Do Until rsCustomers.EOF
Response.Write objFirstName & " " & objLastName & "<BR>"
rsCustomers.MoveNext
Loop
%>

Answer 1

你用的是oledb，
用这个
CreateObject ("SQLOLE.SQLServer")

Answer 2

"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=数据库名;Data Source=主机名"
用这个连接字符串试试

Answer 3

"Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password="password"Initial Catalog=数据库名;Data Source=主机名"
用这个连接字符串试试

Answer 4

应该不用写PROVIDER=SQLOLEDB。而且你如果用的UID＝SA，那么也不用写PASSWORD了。如果用别的UID登陆时，PASSWORD＝后面千万不要有空格！！！

Answer 5

MyConnString = "server=localhost;database=GSM;user id=sa;password=234;";

Answer 6

<%
dim conn
set conn=server.createobject("ADODB.connection") 
set conn.connect="PROVIDER=SQLOLEDB;DATA SOURCE=机器名;UID=sa;PWD=sa;DATABASE=数据库名"
conn.open
%>