SQLClient, SSPI, Username and Password!
I cannot believe that I just now discovered that you can have a connection string from a PPC to a "network" SQL 2000 that uses
SSPI
with a USERNAME and PASSWORD...
And that it actually does WINDOWS AUTHENTICATION with this un/pw!!!!!!!
I just died and went to heaven!
Re: SQLClient, SSPI, Username and Password!
Confirmation that this does in fact work!
http://msdn2.microsoft.com/en-us/lib...3(SQL.80).aspx
This is so great - PPC with windows authentication.
And I can use the PASSWORD that's entered on the PPC by the user to not only make the network SQL connection but also to encrypt the SQL CE database on the pocket pc!