There are quite a few topics in the SQL Server 2000 BOL that deal with encryption. Look up "encryption" in the index.
-Mike
>When I create a connection from my vfp exe, is the data traveling across the lan from the queries encrypted?
>
>Here is the code I use to create the connection:
>
>
>= SQLSetProp(0, "displogin", 3)
>lcDSNLess=[DRIVER={SQL SERVER};SERVER=]+ALLTRIM(gcDataSer)+[;UID=ctore;pwd=DB1ACC!23;Network=DBMSSOCN;database=CTORE;]
>gcConnString=lcDSNLess
>
>gnConnHandle=SQLSTRINGCONNECT(lcDSNless)
>if gnConnHandle < 0
> =SQLERROR(program(),program(),transform(lineno()))
> return
>endif
>
>
>
>If not, is there a way to create an excrypted connection?
>
>Thanks
>
>Kirk