RoboTask forum

I think I'm in need of a "SQL in Robotask" primer.As part of my monitoring system, I need to run queries against a couple of Microsoft SQL servers. In the first, I need to query a table for the number of records containing NULL is a specific field. I have the SQL query worked out, so I'm not too worried about that.What's unclear to me now, is how Robotask connects to the SQL server. Do I need to set up an ODBC connection first?  Do I need to install a SQL driver on the Robotask computer? What steps do I need to carry out to enable Robotask to talk to my SQL server?

Actually I've got this figured out. It was just the nomenclature that was messing me up.If anyone needs this solution, picking "Connection String" will open a dialogue box where you can enter all of your server, database and account information. I had expected the need to type this in and I didn't know the syntax, so this was a pleasant surprise.Caveats-I needed to create a new account on my SQL server with data-reader permissions before the SQL server would allow things to work. This is expected behavior.Also, for some reason, robotask fails to login to SQL if I enter the user and password on the "general" screen. If I go to the "authentication" screen, click the checkbox and enter the information there, then it works.