OK,
Set DORKMODE OFF
the reason my code failed was a simple misspelling when setting the variable before the SQLPREPARE line


>
>Yes try it. I can't reproduce your problem.

and now we know why!


>
>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

ah so.

Many Thanks Cetin. I've learned more from your postings in the last 24 hours than much headbanging in the last couple of weeks.

Regards

Harry