I would look into ODBC driver and it settings.
>We're using Informix SE 7 and VFP6, all workstations are NT4 with SP6 and installed the same ODBC drivers. One more thing is that it could run the commands like: sqlexec, sqlsetprop. I will try to test with all sql* commands and look for a new driver today. Any ideas ?
>
>Thank you for your help.
>
>>What is the backend DB? Do you have latest ODBC driver installed?
>>
>>>Dear all,
>>>
>>>I've added a function that use SQLCOLUMN to get the table structure from the remote server recently.
>>>Some PCs got an error ".. Not enough memory ...". But I think it's not the memory issue because some PCs with less memory could run it properly. The code like:
>>>
>>>IF SQLCOLUMNS(nTest,'table1','FOXPRO','tmp_cols') > 0
>>>....
>>>
>>>
>>>Any clues ?
>>>Thank you. Wilfred
--sb--