首页 > 数据库技术 > 详细

vbs连接sql server

时间:2015-05-13 19:34:20      阅读:393      评论:0      收藏:0      [点我收藏+]

 

Function connMMSQL(ip,user,pwd,database,strsql)
	Dim conn,Re,arr(2)
	set conn = CreateObject("ADODB.Connection")
	conn.ConnectionString="Provider=SQLOLEDB.1;Password="+pwd+";Persist Security Info=True;User ID="+user+";Initial Catalog="+database+";Data source="+ip   
	conn.Open
	If conn.state=0 Then
		arr(0) = -1  
	    connMMSQL = arr
	ElseIf conn.state=1 Then
	   set Re =  conn.execute(strSql)
	   If Re.EOF = False Then 
	   	arr(0) = 1
	   	arr(1) = Re.GetRows
	   	connMMSQL = arr
	   ElseIf Re.EOF = True Then 
	   	arr(0) = 0
	   	connMMSQL = arr
	   End If 	   	
	End If
	conn.close
	Set conn = Nothing
End Function 

 

  

 

vbs连接sql server

原文:http://www.cnblogs.com/Tester-ABX/p/4501101.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!