Re: Databases connections not working more with all web sites
From: Mark Schupp (notvalid_at_email.net)
Date: 10/27/04
- Next message: gm: "Is there NO ONE that can help with this error?"
- Previous message: Astra: "superimposing a pic on a pic when the data is dynamic"
- In reply to: Andrew Zamkovoy: "Databases connections not working more with all web sites"
- Next in thread: Andrew Zamkovoy: "Re: Databases connections not working more with all web sites"
- Reply: Andrew Zamkovoy: "Re: Databases connections not working more with all web sites"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 27 Oct 2004 08:10:13 -0700
First check for permission problems. Temporarily set the anonymous user
account for one of the sites with a problem to an account with administrator
rights (not sure is you need to re-boot but I would just to make sure). If
the site works then you have a permission problem that you need to track
down.
See http://www.aspfaq.com/show.asp?id=2009
--
--Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com
"Andrew Zamkovoy" <zam@parks.lv> wrote in message
news:uF1yF26uEHA.3276@TK2MSFTNGP15.phx.gbl...
> Hello World,
>
> MS NT 2000 Server (+with all latest SP).
> asp.dll version: 5.0.2195.6672
> jet.dll version: 5.0.2134.1
>
> All usually working before well, but accidentally crashed by undetermined
> reason:
>
> Databases connections, both, for MS SQL Server 2000 (SP1) and MS Access
> 2000
> databases stop working under all web sites on web server.
>
> Affect only IIS applications.
>
> if trying to open MS Access 2000 databases:
>
> Microsoft JET Database Engine error '80004005'
> Unspecified error
>
> In connection string, while try to work with MS Access db:
> Set XXX = Server.CreateObject ("ADODB.Connection")
> XXX.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=XXXXX"
> XXX.CursorLocation = 3 // could be vary
> XXX.CommandTimeout = 60
> XXX.Open <-- ERROR HERE
>
>
> if trying to open MS SQL Server 2000 and MS Access 2000 databases:
>
> ADODB.Connection error '800a0e7a'
> Provider cannot be found. It may not be properly installed
>
> Set XXX = Server.CreateObject ("ADODB.Connection")
> XXX.Open "DSN=XXXXXXXX;uid=XXXXX;pwd=XXXXXXX;" <-- ERROR HERE
>
>
>
> ADO and JET testing from WIN32 Application indicate that they are working
> and installed well
> - Jet 4 installed
> - ADO version 2.7
> - MDAC version 2.7.9040.2
>
>
> Reinstalling of Microsoft Data Access Components (MDAC) 2.8 are not help.
> Reinstalling of IIS are not help.
>
>
>
>
>
- Next message: gm: "Is there NO ONE that can help with this error?"
- Previous message: Astra: "superimposing a pic on a pic when the data is dynamic"
- In reply to: Andrew Zamkovoy: "Databases connections not working more with all web sites"
- Next in thread: Andrew Zamkovoy: "Re: Databases connections not working more with all web sites"
- Reply: Andrew Zamkovoy: "Re: Databases connections not working more with all web sites"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
