Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement