Skip to content

Instantly share code, notes, and snippets.

@cx20
Created June 10, 2012 14:11
Show Gist options
  • Save cx20/2905817 to your computer and use it in GitHub Desktop.
Save cx20/2905817 to your computer and use it in GitHub Desktop.
Hello, ADO World! (VBScript + ADO + ODBC + SQL Server)
Option Explicit
Call Main()
Sub Main()
Dim cn
Dim rs
Set cn = CreateObject("ADODB.Connection")
cn.Open "PROVIDER=MSDASQL;Driver={SQL Server};" & _
"SERVER=(local);DATABASE=master;", _
"sa", "P@ssW0rd"
Set rs = cn.Execute("SELECT 'Hello, ADO World!' AS Message")
While Not rs.EOF
WScript.Echo rs(0).Name
WScript.Echo "-------------------"
WScript.Echo rs(0).Value
rs.MoveNext
Wend
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment