62,242
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
CTdonner 2004-01-29
- 打赏
- 举报
用odbc联就是了看你的sql认证是用什么方式认证的一般都是用混合身份认证的
wkzjl 2004-01-29
- 打赏
- 举报
那Windows身份验证的语句是什么？
LiSDN 2004-01-29
- 打赏
- 举报
http://www.csdn.net/develop/Read_Article.asp?Id=23115
风中飘扬的柳絮 2004-01-29
- 打赏
- 举报
Session("ConnectionString") = "Provider=SQLOLEDB;Server=DBServerName;Database=pubs;Uid=sa;Pwd=sa"
reaperwu 2004-01-29
- 打赏
- 举报
Const adOpenStatic = 3
Const adLockReadOnly = 1
Const adCmdText = &H0001
Const adStateOpen = &H00000001
Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;Password=password;User ID=User;Initial Catalog=NewTCMIS1118;Data Source=IP108"
conn.Open
SQL = "SELECT * FROM Table"
Set RS = Server.CreateObject("ADODB.Recordset")
RS.Open SQL, conn, adOpenStatic, adLockReadOnly, adCmdText
Const adLockReadOnly = 1
Const adCmdText = &H0001
Const adStateOpen = &H00000001
Set conn = Server.CreateObject("ADODB.Connection")
conn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;Password=password;User ID=User;Initial Catalog=NewTCMIS1118;Data Source=IP108"
conn.Open
SQL = "SELECT * FROM Table"
Set RS = Server.CreateObject("ADODB.Recordset")
RS.Open SQL, conn, adOpenStatic, adLockReadOnly, adCmdText
