Perhaps the trigger is failing. And in the process, the trigger may be raising an error. Are you sure you are providing all of the required data for all of the columns? i.e., are you leaving a column null in which nulls are not allowed.

My suggestion is to try and insert a record from Query Analyzer. If there is an error, using QA will bring you closer to the problem...


>Hi All!
>
>This problem related to VFP6 and SQL 7.
>
>I am executing an INSERT INTO via SQLEXEC(). I am getting an error ("The server did not return a result set")
>
>Some more details.
>
>The insert is very simple. INSERT INTO PATIENTS (field list...) VALUES (value list...)
>
>The table has an insert trigger on it that adds records to other tables when a patient is added.
>
>That's about all the information I have... have any of you seen this? Any way around this without modifying the SQL Server Trigger? (I am doing a data conversion, I did not write either application and cannot touch the code for the new application.)
>
>TIA,
>
>Menachem