AutoIT connect SQL Server

2521阅读 0评论2011-11-15 huhuegg
分类:Python/Ruby

$conn = ObjCreate( "ADODB.Connection" ) 

$DSN = "DRIVER={SQL Server};SERVER=MySvr;DATABASE=MyDB;UID=MyUser;PWD=MyPwd;"

$conn.Open($DSN) 

$rs = ObjCreate( "ADODB.RecordSet" ) 

$rs.Open( "SELECT @@VERSION AS myVersion", $conn ) 

MsgBox(0, "AutoIT-SQL Result", "Value = " & $rs.Fields( "myVersion" ).Value ) 

$conn.close

上一篇:Autoit3 Mysql UDF
下一篇:Perl CPAN 设置