dim pgDBHost, pgDBInst, pgDBName, pgDBUser, pgDBPass

' The SQL server hostname
pgDBHost = "sqlserv01\payglobal"

' The SQL database name
pgDBName = "PGprod"

' The user name
pgDBUser = "FABRIKAM\sa-recruitment"

' The password
pgDBPass = "passw0rd!"

set conn = CreateObject("ADODB.Connection")
wscript.echo "provider"
conn.Provider = "SQLOLEDB"
wscript.echo "conn string"
conn.ConnectionString = "Server="&pgDBHost&";Database="&pgDBName&";User ID="&pgDBUser&";Password="&pgDBPass&";"
wscript.echo "cursor location"
conn.CursorLocation = 3
wscript.echo "open sesame!"
conn.Open
wscript.echo "we're in!"
conn.close