Thanks for reading this.
Have a Win console that reads a table on SQL Sever.
Ran it locally and it works.
Ran it on the DEV server (Win 2008) and we have this error:
ExecuteReader requires an open and available Connection. The connection's current state is closed.
On the DEV server there's an ODBC instance (SomeDB)
Here's the connectionstring for console app:
<add key="SQLConnection" value="Data Source=SeverA\DB1;Initial Catalog=SomeDB;Integrated Security=SSPI" />
*SomeDB = a db name that the table resides
Any ideas what's causing the issue?