Sounds like SQL Server is setup for only trusted connections.
Ahh.,. nevermind that. Didn't see that it works for with DSN.
>
>
>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?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer