$cnstring = "DRIVER={SQL Server};SERVER=sqlserver;UID=username;PWD=password;DATABASE=dbname"

	$cn = CreateObject("ADODB.Connection")
	$cmd= CreateObject("ADODB.Command")
	$rs = CreateObject("ADODB.RecordSet")

	$cn.connectionstring = $cnstring
	$cn.open
	$cmd.activeconnection = $cn
	$rs.cursortype = 3
	$rs.locktype = 3
	$rs.activecommand = $cmd

	$cmdtxt = "select * from dbo._tbl_Main where SerialNumber = '$serNo'"
		$cmd.commandtext = $cmdtxt 
		$rs.open ($cmd)			;? 'Error = '+@ERROR+' - '+@SERROR
			$serNo 	  = $rs.fields.item("SerialNumber").value
			$wksta    = $rs.fields.item("ComputerName").value 
			$assigned = $rs.fields.item("AssignedTo").value 
			$network  = $rs.fields.item("NetworkID").value 
			$ip 	  = $rs.fields.item("IPAddress").value 
			$date 	  = $rs.fields.item("InvDate").value 
		$rs.close