Hi Sergey

They belong to an accounting package called Sage (line50) I am not 100% sure what they are but as I said earlier I can access them via MSQuery so I should be able to access them from VFP. My problem is that I don't know what settings I can change to get around this error.

Strangely enough, I now appear to be retreiving my data (tables are created), even though I am still getting the error (-1 returned). This may be because I ran a MSQuery. I will reboot and try again.

Regards
Geoff

>Are they free tables or belongs to DBC?
>
>>

?SQLGETPROP(gnConnHandle,"ConnectString")
>>
>>"DSN=SageLine50v8;UID=manager;PWD=;"

>>
>>Sorry, misunderstood
>>
>>>>Hi Sergey
>>>>
>>>>>Can you post connection string? You can use SQLGETPROP(gnConnHandle,"ConnectString") to get it. Did you try with another table?
>>>>
>>>>yes, yes and now yes
>>>>
>>>>all three sqlexec and the sqltables return the same error
>>>>
>>><snip>
>>>
>>>So, where is connection string?