.NET SQLClient Data Provider: Timeout expired when running a ODBC connection from a Win7 to Win2008R2 SQL2008R2 DB. Connection establishes on basic ODBC but continually times out.
What I have tried:
1) Adding "Connection Timeout=0" and "context connection=true" in ODBC string
2) Setting SQL connection to 0
3) Trying different ODBC connection types
sp and query runs fine on SQL with no issues, it just takes about 5 minutes to complete interpolation.