Solved

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

Posted on 2004-10-14
7
4,867 Views
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.
0
Comment
Question by:Jerry_Pang
  • 3
  • 3
7 Comments
 
LVL 28

Expert Comment

by:mmarinov
ID: 12306114
Hi Jerry_Pang,

can you post the connection string ?

Regards!
B..M
0
 
LVL 9

Author Comment

by:Jerry_Pang
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?
0
 
LVL 6

Accepted Solution

by:
etmendz earned 200 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.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 28

Expert Comment

by:mmarinov
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 )

B..M
0
 
LVL 9

Author Comment

by:Jerry_Pang
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?

http://www.microsoft.com/downloads/details.aspx?familyid=1e268b39-533e-48b0-b8d7-1781befde1f8&displaylang=en
is the download for the Jet4.0

what do you think?
0
 
LVL 28

Assisted Solution

by:mmarinov
mmarinov earned 50 total points
ID: 12306348
0
 
LVL 9

Author Comment

by:Jerry_Pang
ID: 12366785
it needs the latest mdac.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Redacting a row in Excel based on a term. 17 53
I need help exporting info from a dataset to Excel in my VB.Net application 7 50
SQL Login 17 37
Variable Event ? 3 19
Welcome my friends to the second instalment and follow-up to our Minify and Concatenate Your Scripts and Stylesheets (http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/A_4334-Minify-and-Concatenate-Your-Scripts-and-Stylesheets.html)…
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 demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

943 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now