>>>tried that:
>>>
>>>m.whatever='arbitrary string'
>>>SQLPREPARE(gnhandle,"update vizkeys set crypt_key=?m.whatever where realkey='one of my keys' ","real")
>>>SQLEXEC(gnhandle)
>>>
>>>and the SQLEXEC line still stopped and asked for the value of m.whatever...
>>
>
>
>>m.whatever='arbitrary name'
>>SQLPrepare(lnhandle,"update Northwind.dbo.employees"+;
>> " set LastName=?m.whatever where FirstName='Later'","real")
>>SQLEXEC(lnhandle)
>
>
>am I missing something? Your syntax appears identical to mine. Or are you simply suggesting I try the sample to see if I get the same problem?
>
>also, I'm interested to know more about the [trusted_connection="Yes"]
>
>what constitutes "trusted" in this context? and what is the effect of that parameter?
>
>Cheers
>
>Harry
Yes try it. I can't reproduce your problem.
Trusted_connection = "Yes"
is identical to
Integrated Security = SSPI
SQL server has 2 authentication modes, windows and sql server (you might use one or mixed mode). Windows mode uses NT security rather than using UID,PWD. I have it in mixed mode and using my NT security.
PS: Modify servername.
Cetin