ASP与SQL Server连接怎么写语句？

kinny_ke 2004-04-14 02:56:33

各位好！偶正在做公司网站可否告诉我ASP与SQL Server连接怎么写语句？谢谢！

...全文

24 5 打赏收藏转发到动态举报

写回复

用AI写文章

5 条回复

切换为时间正序

请发表友善的回复…

发表回复

Newrocky 2004-04-14

打赏
举报

[连接SQL数据库]
set dcnDB = server.createobject("ADODB.CONNECTION")
dcnDB.open "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=帐号;pwd=密码;Initial Catalog=表名;Data Source=数据库IP(localhost本地)"
set rsDB = server.createobject("ADODB.RECORDSET")

ngj 2004-04-14

打赏
举报

Set objCon = Server.CreateObject("ADODB.Connection")
objCon.Open "DBName","DBID","DBPASS"

Set Rs = Server.CreateObject("ADODB.Recordset")
Sql = "SELECT * FROM TABLEX"
Rs.Open Sql,objCon,adOpenStatic

swich 2004-04-14

打赏
举报

http://www.connectionstrings.com/

wdj79 2004-04-14

打赏
举报

<%connstr="driver={sql server};server=EANDA-SERVER;uid=sa;pwd=eanda02;database=do"
set conn=server.CreateObject("ADODB.connection")
conn.open connstr
%>

server="这里是服务器的名字"
database=“这里是数据库的名字”

bybee 2004-04-14

打赏
举报

set connect=server.CreateObject("ADODB.connection")
strconn="PROVIDER=SQLOLEDB;DATA SOURCE=192.168.0.79;UID=sa;PWD=;DATABASE=icbc"
connect.Open strconn