100% CPU-Load when reading from sql-Database

[MariusTu-Berlin]

Hello to everyone,

I'm having trouble with the NI Application webserver. I'm having a Restful-Webservice whith serveral globar variables, that can be set an read by typing a url into the browser. In the main-programm (which controlls a coupled pendula) it performs an SQL-Select query. The first time, this is performed, the NI Application Webserver gets a CPU-Load of 100%, causing the whole program to work properly. Even stopping has no effect on the cpu load. If i don't include the sql-query everthing runs just fine. 

I'm running Labview 2010 with the Database Connectivity Toolkit on WinXP. Here's a screenshot from the sub-vi which causes the webserver to hang;

Thank you for your help!

edit: The image became smaller as i excepted, so i put the vi in the Attachement

[RavensFan]

Why are you concatenating an empty string to all of your strings?

You don't need to have multiple index arrays.  Use one index array and resize the bottom of it downward.  You won't need to wire up any indices either.  By default, the top one will be index zero, and each one below that will be +1 the one above.

How does it behave when you run it with highlight execution?  Does that give you an idea where it is hanging?

Also, your connection string as several backward apostrophe accent characters rather than regular apostrophes.  See here.