Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error occuried with SQLcolumn
Message
 
 
To
17/04/2002 22:35:42
Wilfred Chan
Bnp Paribas Hong Kong Branch
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00645807
Message ID:
00646161
Views:
14
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform