Posted on 2004-10-15
I have a windows service that runs queries on a database using OleDb. I prepare a sql command and then execute the command. Every so often, the program will start cutting off the sql commands. A command such as "Select * from tbCustomers;" might get cut off to "Select * from tbCust". The sql execution fails and all subsequent attempts to run any sql commands also fail. The program then needs to be shut down and restarted.
So I switched to using System.Text.StringBuilder, but the same problems occurs.
Any ideas as to why this may be occurring? Any help would be greatly appreciated.