BINGO!
Thanks for the hawkeye catch, Craig.
>There is a \\ between the server and instance name on connStringA.
>
>
>>
>>
>>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?
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.