Thanks for your reply.
I was able to create the connection with a username, then delete the username from the database so it does not exist. I then use the following code to submit.
Set oNetwork = CreateObject(''WScript.Network'')
sUserName = oNetwork.UserName
Password = Inputbox(''Password'',''Ferguson Password'','''')
strConn = ...