If I were dealing with asp.net I would change to full trust but I'm not sure how to handle this for the console application. Any suggestions. I have done a fair amount of searching on this error with no luck for my exact use case.

androtheos:You comment prompted me to remove a try catch block from the code. After doing this the debugger pointed out the exact issue.The connection string was not being passed to the SqlConnection constructor. Weird error for that though. Anyway problem solved. T