Using:
oconn=CREATEOBJECT('adodb.connection')
oconn.Open("Driver=SQL Server;Server=a;Database=b;UID=c;pwd=d;")
I get a good object oconn, but the open method gets an error:
The login for user x failed due to: Not associated with a trusted SQL Server connection.

Does anyone know how I would fix this?

Thanks.