I cannot get the Web reports to show any of the software updates.
I cannot get the Web reports to show any of the software updates. I have followed the install procedure exactly and get [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [-2147467259]
Check your SQL security and make sure it is set to SQL security or Mixed security. There is a way to get Web Reports to use NT security, but that workaround isn't supported. See the workaround here: http://www.myitforum.com/articles/1/view.asp?id=2037
This was first published in April 2004