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