Since you're on the inside of a string (objCommand.CommandText takes a string) you need to concatenate the computer name inside it, so something like:
Quote:
objCommand.CommandText = _
"Select ADsPath from " &_
"'LDAP://DC=Domain,DC=com,DC=au' where objectClass='computer'" &_
" and name = " & sAssetTag & " "
|
[ 06-26-2007, 05:47 AM: Message edited by: dplax ]