>I tried that but the inserts did not work.
whenever SqlExec() returns less than zero, it helps to stop your code (at least in development), and copy your SQL statement into _cliptext, then try it out in Query Analyzer, SSMS, Toad or what have you. If your command had too many question-mark-prefixed parameters, then the SQL Profiler will help - you can catch your command as it was received at the server, and then copy it and try it in QA, SSMS, Toad. That will also help you to understand what's VFP doing behind your back (ie. how does it automate those parameters).
>But now I have an even bigger problem
>yesterday i could connect to sqlserver just fine. today it times out
>
>
>strConnectionString = [Driver={SQL Server};Server=OTT-LT1026;Database=kba_sql;Uid=sa;pwd=]
>strConnectionString = [Driver={SQL Server};Server=OTT-LT1026;Database=kba_sql;Trusted Connection]
This should be a [...;Trusted_Connection=yes]