General information
Forum:
Microsoft SQL Server
Hi All,
Not sure if this should go here or up in VFP area, but I am working with VFP8SP2 and SQL Server 2005. I have code that goes into sql server through OLEdb and creates temporary tables for querys on. It works good on a small data set, but I am working on a big dataset (file size ~1.5GB) and either it will time out just going into my program part, or just after, depending on the commandtimeout setting. I have put it to 10 and 10000. On 10, it does not get very far in my prog, before erroring out. on 10000, it gets through my code and starts other code before erroring out. I found the blog about setting the designers timeout options to a high number and unchecking it, but still get the timeout after my code.
Any ideas on how to fix this?
TIA
Beth
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only