I am getting really issues when in VSTA I try to connect to a SQL 2008 DB and I get the following error:
Unable to add dataconnection. Failed to retrieve data for this request. The SQL Server version (10.0) is not supported.
When I try to connect to SQL 2005 it say the connection string is incorrect.
COuld someone please assist. Thanks