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

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.
Who is Participating?
etmendzConnect With a Mentor Commented:
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.
Hi Jerry_Pang,

can you post the connection string ?

Jerry_PangAuthor Commented:
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?
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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 )

Jerry_PangAuthor Commented:
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?
Jerry_PangAuthor Commented:
it needs the latest mdac.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.