sql execute hangs when running

[mweel]

I am trying to log data. I have a program that collects some data points then tries to save them to a database. 

We have been using this program for 10 years but it is suddenly giving us problems. 

When I have my list of data points to save I try to save it to the database via the "ADO Connection Execute.vi" program. This program contains only a invoke node that is calling an activex object. The first time this program runs it hangs for about 20s then continues without giving an error. Then the rest of the calls run without incident. As far as I can tell the inputs to the program are correct.

I was wondering if anyone has encountered this. We haven't changed our program recently so I don't know what might have caused this. I was wondering if there was some windows update or something that is making the activeX  stuff act funny. 

Any ideas of where to look for the problem would be appreciated. 

[aputman]

This sounds more like a hardware issue than a software one.  It almost sounds like the database computer is asleep when the first call is made.  And if it takes too long for the computer to come alive, the Connection VI will error out.  However, after it has been awoke, everything functions normally.  Has anyone messed with the Power Saver Windows options?

[mikeporter]

Yes, where is the database being hosted? This sounds like a remote-host/network problem.

Mike...