Finally got it working! The checkPass SQL statement needed to be changed to:
PHP Code
$conf['auth']['mysql']['checkPass'] =
	   "SELECT USER_PASSWORD AS pass
		FROM ubbt_USERS
		WHERE USER_LOGIN_NAME='%{user}'";  
I now have DokuWiki authenticating against my UBB.threads installation!