SQL primer

stevefromdodge · Post by **stevefromdodge** » Mon Jul 18, 2011 6:34 pm

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?

stevefromdodge · Post by **stevefromdodge** » Mon Jul 18, 2011 7:29 pm

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.