ConnStringa = "DRIVER=SQL Server,SERVER=BILL-VAIO\\SQL2008FULL,DATABASE=safesignature,UID = myuid; PWD = mypw"

ConnStringb ="Driver=SQL Server;Server=BILL-VAIO\SQL2008FULL;Database=safesignature;Integrated Security=SSPI"

myuid and mypw belong to a SQL administrator will full rights to the DB.

When I try gnHandle = SQLStringConnect(lcConnStringa)

I get "myid is not at trusted connection"


When I try gnHandle = SQLStringConnect(lcConnStringb)
I connect fine.
myuid and mypw work fine with a DSN.

Any suggestions?