access database with asp.net

  • Thread starter Thread starter Stephen Martinelli
  • Start date Start date
S

Stephen Martinelli

I have a asp app that works well on local host. The connection string is as
follows in the web.config
<appSettings>
<add key="cs" value="Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:\databases\sfleet.mdb"/>
</appSettings>

I moved the app to a 2000 server that i just installed to test it and cant
get the connection to work. Is there a difference running on a XP localhost
and a 2000 server? I set the server up as a member of a workgroup...

Im stumped
 
Hello Stephen,

When you say "cant get the connection to work" what error do you get? There
shouldn't be a need to change the connection string assuming your database
is still at the same path (c:\databases\sfleet.mdb).

Martin.
 
this is the error i keep getting
ExecuteReader requires an open and available Connection. The connection's
current state is Closed.

it has to be a permissions problem?
 
Hello Stephen,

Are you using the latest MDAC components etc.? If your not sure run windows
update
 
Hi... I installed this server at home yesterday and ran windows update ...
got everything out there that was to be had
 
Martin

The 2000 server is running mdac 2.5 sp3
the xp pro maching i used to develope the app is mcad 2.8 sp1

so what to do?
 
Martin..... thank you.... MDCA has to be updated seperately.... i figured it
out using the mdca checker on the microdoft site and downloaded the
approperate update...

Again...thank you
 
Back
Top