Did you try changing it from Named Pipes to TCP/IP in the ODBC connection?  Sometimes that is the only way I've been able to connect through some older apps that...

One of the lower end tools that is pretty slick is Xcelsius

http://www.xcelsius.com/

It allows you to connect to a data source and develop dashboard, reporting, etc using common objects (charts,...