$SQL_Server = "0.0.0.0"
$SQL_Database = "database"
$SQL_User = "sqluserid"
$SQL_Pass = "password"

Break On




$cnstring = "Driver={SQL Server};Server=$SQL_Server;database=$SQL_Database;uid=$SQL_User;pwd=$SQL_Pass" 
																			
$cn = CreateObject("adodb.connection") 
$cmd = CreateObject("adodb.command") 
$rs = CreateObject("adodb.recordset") 
																					
$cn.connectionstring = $cnstring
$cn.Open
																					
$cmd.activeconnection = $cn
$rs.cursortype = 1
$rs.locktype = 3
$rs.activecommand = $cmd
																					
$cmdtext = "Select * from lkp_Departments Order By Department "
			
$cmd.commandtext = $cmdtext
$rs.Open($cmd)

	Do While Not $rs.EOF
		? "Entry: " + $rs.fields.item("Department").value
	
		$rs.MoveNext
	Loop

$rs.Close($cmd)
	
? "done"