ExecuteReader requires an open and available Connection. The connection's current state is Closed.

Posted on 2004-10-14
Medium Priority
Last Modified: 2011-09-20
ExecuteReader requires an open and available Connection. The connection's current state is Closed.

My asp code works fine on my server and 3 other computers.
except for the production server!
now why is that?

the only difference is that the production server does not have msoffice,
is that required?

what do i need?

im using OLEDB to connect to msaccess, do i need that file?

what to do next?

2 possibility i think
1 - it cant find the DB
2 - a file or dll is needed.
Question by:Jerry_Pang
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
LVL 28

Expert Comment

ID: 12306114
Hi Jerry_Pang,

can you post the connection string ?


Author Comment

ID: 12306194
Me.pvtDbPath gets data from webconfig.
i put my database in d:\database\database.mdb
app_db in webconfig is already "d:\database\database.mdb"

        Private Sub BuildString()
            Me.pvtConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;" _
                      & "User ID=" & Me.pvtUID & ";" _
                      & "Data Source=" & Me.pvtDbPath & ";" _
                      & "Jet OLEDB:Database Password=" & Me.pvtPwd & ";"
        End Sub

this connectstring is working in any computer except on our production server.
mdac version in production server is 2.53.6200.1
this computer that im using(currently my application works) is 2.80.1022.0

does that matter?

Accepted Solution

etmendz earned 800 total points
ID: 12306294
MDAC version matters. So make then match.

Check also if D:\database has access rights to the account used by ASP (MACHINENAME\IUSR_MACHINENAME and INTERACTIVE if the former is not enough). Do the same to the Temp directories. In Windows Explorer, right click on a folder, Properties, Security tab...

Have fun.
The Orion Papers

Are you interested in becoming an AWS Certified Solutions Architect?

Discover a new interactive way of training for the exam.

LVL 28

Expert Comment

ID: 12306298
first - check if the aspnet user has permissions on the database ( not group everyone, aspnet user )
second, check where do you receive the error ( on wich line )


Author Comment

ID: 12306307
here's what i think is happening.

my app is using OLEDB Jet 4.0

i  dont think that the server has support for Jet4.0

how do i make sure that it does not?

is the download for the Jet4.0

what do you think?
LVL 28

Assisted Solution

mmarinov earned 200 total points
ID: 12306348

Author Comment

ID: 12366785
it needs the latest mdac.

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes relatively difficult and non-obvious issues that are likely to arise when creating COM class in Visual Studio and deploying it by professional MSI-authoring tools. It is assumed that the reader is already familiar with the cla…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question