About
Pricing
Community
Teams
Start Free Trial
Log in
Allan
asked on
12/2/2011
DB Connection Issue
Hi Experts!
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?
.NET Programming
Visual Basic.NET
Microsoft SQL Server 2008
5
2
Last Comment
Allan
8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
vasto
12/2/2011
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Allan
12/2/2011
ASKER
yes. Thanks!
SOLUTION
Nasir Razzaq
12/2/2011
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Allan
12/2/2011
ASKER
I think I figured it out; it's running under a different AD account. bummers.
Trying to get it to work under the right account. Thanks!
Allan
12/5/2011
ASKER
We'll; it looks like an account issue; I'll split points. Thanks!
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23