Then aerror() should give you the error message. What is the error message?

>>"But, cannot seem to execute any SQL statements through Foxpro."
>>Do you get any error? Or sqlexec() returns -1? What does aerror() give you?
>>
>SQLPrepare() returns a -1. Never gets to SQLExec() because of that.
>The connection does still exist at the point of issuing SQLPrepare.
>
>Steve
>
>>
>>>Hi,
>>>
>>>Have a box with WinME on it using VFP 7. Have SQL-Server loaded on an older P-II with WinNT 4.0 SP6. The connection is established to the server box and I can even issue a SQLCONNECT() and get a valid connection. But, cannot seem to execute any SQL statements through Foxpro.
>>>
>>>Not even sure what to look for at this point. I'll take any suggestions.
>>>
>>>Thanks,
>>>Steve