access to access db stop

[Trapulo]

I've a server (W2K Server SP4) where my sites can access to Access db.
Sometimes, starts this error:

Microsoft JET Database Engine error '80004005'

Unspecified error

/news.asp, line 65



If I restart the server all goes ok.



What can be?



thanks

[Ray at]

What's your code?
What does your query look like?
What does your connection string look like?

Ray at work

"Trapulo" <nonscrivermi@qui.it> wrote in message
news:ud4ww%23jmDHA.2772@TK2MSFTNGP10.phx.gbl...

> I've a server (W2K Server SP4) where my sites can access to Access db.
> Sometimes, starts this error:
>
> Microsoft JET Database Engine error '80004005'
>
> Unspecified error
>
> /news.asp, line 65
>
>
>
> If I restart the server all goes ok.
>
>
>
> What can be?
>
>
>
> thanks
>
>
>
>

[Trapulo]

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:Og$c6KkmDHA.2616@TK2MSFTNGP11.phx.gbl...

> What's your code?
> What does your query look like?

sql="select * from news where lingua like 1 order by id desc

> What does your connection string look like?
>

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath("Database/dati.mdb")
Set RS=conn.Execute(sql)

Error on conn.open

thanks

[Bob Barrows]

Trapulo wrote:

> I've a server (W2K Server SP4) where my sites can access to Access db.
> Sometimes, starts this error:
>
> Microsoft JET Database Engine error '80004005'
>
> Unspecified error
>
> /news.asp, line 65
>
>
>
> If I restart the server all goes ok.
>

If you Repair/Compact the database, permissions for the new database
resulting from the repair/compact process may not be assigned. Remember,
IUSR needs Change permissions for the database file

HTH,
Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Ray at]

You could try doing "select * from [news] where [lingua]=1 order by [id]
desc"

Also, with your database in that location, anyone in the world can download
it. Read here.
[url]http://www.aspfaq.com/2454[/url]

Also, you may want to read this and consider it after you get things worked
out.
[url]http://www.aspfaq.com/2096[/url]

Ray at work

"Trapulo" <nonscrivermi@qui.it> wrote in message
news:eYC%23HNkmDHA.3732@tk2msftngp13.phx.gbl...

>
> "Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
> news:Og$c6KkmDHA.2616@TK2MSFTNGP11.phx.gbl...

> > What's your code?
> > What does your query look like?

>
> sql="select * from news where lingua like 1 order by id desc
>

> > What does your connection string look like?
> >

>
> Set conn = Server.CreateObject("ADODB.Connection")
> conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
> Server.MapPath("Database/dati.mdb")
> Set RS=conn.Execute(sql)
>
> Error on conn.open
>
> thanks
>
>

[Tom Kaminski [MVP]]

"Trapulo" <nonscrivermi@qui.it> wrote in message
news:ud4ww%23jmDHA.2772@TK2MSFTNGP10.phx.gbl...

> I've a server (W2K Server SP4) where my sites can access to Access db.
> Sometimes, starts this error:
>
> Microsoft JET Database Engine error '80004005'
> Unspecified error
> /news.asp, line 65
>
> If I restart the server all goes ok.
> What can be?

[url]http://www.aspfaq.com/show.asp?id=2009[/url]

--
Tom Kaminski IIS MVP
[url]http://www.iistoolshed.com/[/url] - tools, scripts, and utilities for running IIS
[url]http://mvp.support.microsoft.com/[/url]
[url]http://www.microsoft.com/windowsserver2003/community/centers/iis/[/url]

[Trapulo]

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:eNMvGSkmDHA.988@TK2MSFTNGP10.phx.gbl...

> You could try doing "select * from [news] where [lingua]=1 order by [id]
> desc"
>

I'll try, but the problem is not with sql statement. I have the error
opening the connection! And not always.. only after some days the server is
running...

> Also, with your database in that location, anyone in the world can

download

> it. Read here.
> [url]http://www.aspfaq.com/2454[/url]

no, I have locked reading attribute in IIS

>
> Also, you may want to read this and consider it after you get things

worked

> out.
> [url]http://www.aspfaq.com/2096[/url]
>

Sorry, I think this is not realted to my problem...


thanks

[Trapulo]

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:eN4R%23SkmDHA.3688@TK2MSFTNGP11.phx.gbl...

> Trapulo wrote:

> >
> > If I restart the server all goes ok.
> >

>
> If you Repair/Compact the database, permissions for the new database
> resulting from the repair/compact process may not be assigned. Remember,
> IUSR needs Change permissions for the database file
>

Interesting point. However I have not opened the db from access, neither
made a repar/compat, so I think this is not the problem (however you
remainded me to try with a reapair...).
The IUSR has change on all directory....

thanks

[Trapulo]

"Tom Kaminski [MVP]" <tomk (A@T) mvps (D.O.T) org> wrote in message
news:bnbjbk$2e646@kcweb01.netnews.att.com...

> "Trapulo" <nonscrivermi@qui.it> wrote in message
> news:ud4ww%23jmDHA.2772@TK2MSFTNGP10.phx.gbl...

> > I've a server (W2K Server SP4) where my sites can access to Access db.
> > Sometimes, starts this error:
> >
> > Microsoft JET Database Engine error '80004005'
> > Unspecified error
> > /news.asp, line 65
> >
> > If I restart the server all goes ok.
> > What can be?

>
> [url]http://www.aspfaq.com/show.asp?id=2009[/url]
>
> --

Thank you, but I didn't find any solution, because my problem is not "fix".
The application works well, but after some days it stops...

[Ray at]

"Trapulo" <nonscrivermi@qui.it> wrote in message
news:emEU78kmDHA.1408@TK2MSFTNGP11.phx.gbl...

> > out.
> > [url]http://www.aspfaq.com/2096[/url]
> >

>
> Sorry, I think this is not realted to my problem...

I don't think so either. I was just suggesting reading it after your
problem is solved.

Try [re]installing the latest version of MDAC and/or run a compact/repair on
the database.

Ray at work

[Jacob Yang [MSFT]]

Hi Trapulo,

Thank you for posting to the MSDN Managed newsgroups. We are acknowledging
your post and you should receive response from the community within 2
business days of your post.

If you have any concerns, please feel free to let us know.

Best regards,

Jacob Yang
Microsoft Online Partner Support
Get Secure! ¨C [url]www.microsoft.com/security[/url]
This posting is provided "as is" with no warranties and confers no rights.

[MSFT]

Hello Trapulo,

With JET engine, we only can create less than 64 connections to the
database. You may check if there are too many connections when the error
occurred, and if you call conn.Close after you open it every time. After
the problem occurr, you may replace it with a new blank database, and test
again to see if the appliaction can open it.


Luke
Microsoft Online Support

Get Secure! [url]www.microsoft.com/security[/url]
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[Trapulo]

"MSFT" <lukezhan@online.microsoft.com> wrote in message
news:L$$PMEDnDHA.724@cpmsftngxa06.phx.gbl...

> Hello Trapulo,
>
> With JET engine, we only can create less than 64 connections to the
> database. You may check if there are too many connections when the error
> occurred,

Now I've the error (4 days from the last time).
How can I check this? However performance monitor for this site reports only
17 "total isapi extension request"...

>and if you call conn.Close after you open it every time.

yes I do

After

> the problem occurr, you may replace it with a new blank database, and test
> again to see if the appliaction can open it.
>

I've tried to download the db, open with access, make a compact and repair,
upload over the old, and the application still not running with

Microsoft JET Database Engine error '80004005'

Unspecified error



Regards,

[Trapulo]

"MSFT" <lukezhan@online.microsoft.com> wrote in message
news:L$$PMEDnDHA.724@cpmsftngxa06.phx.gbl...

> Hello Trapulo,
>
> With JET engine, we only can create less than 64 connections to the
> database. You may check if there are too many connections when the error
> occurred, and if you call conn.Close after you open it every time. After
> the problem occurr, you may replace it with a new blank database, and test
> again to see if the appliaction can open it.
>

I verified the problem is with ALL Access db on this server!
So I'm sure this problem is not db-related, but jet-related.... :(

[MSFT]

When the error occurred, you may check the .ldb file in the same folder as
.mdb, to see if there are too many user open the database at same time.
Anyway, Access is just a desktop database, and may not be suitable for ASP
server side database. You may consider SQL server, or Even MSDE instead.

Luke
Microsoft Online Support

Get Secure! [url]www.microsoft.com/security[/url]
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[Trapulo]

"MSFT" <lukezhan@online.microsoft.com> wrote in message
news:5HPpcGgnDHA.2828@cpmsftngxa06.phx.gbl...

> When the error occurred, you may check the .ldb file in the same folder as
> mdb, to see if there are too many user open the database at same time.

When you open mdb from IIS there is not the ldb file

> Anyway, Access is just a desktop database, and may not be suitable for ASP
> server side database. You may consider SQL server, or Even MSDE instead.

I use SQL server. This site is hosted, and there are no more 2 users/week
accessing it, so this is not a performance problem!

However I resolved the problem. It was a strange behavior of IWAM user, with
a local profile. No configuration error, no performance problem, no
database-related problem. A bug of system installer, or a strange behavior
of IIS.

[Bob Barrows]

Trapulo wrote:

> "MSFT" <lukezhan@online.microsoft.com> wrote in message
> news:5HPpcGgnDHA.2828@cpmsftngxa06.phx.gbl...

>> When the error occurred, you may check the .ldb file in the same
>> folder as mdb, to see if there are too many user open the database
>> at same time.

>
> When you open mdb from IIS there is not the ldb file

There should be. The fact that there isn't means that the account that IIS
is using to connect to the database does not have sufficient rights for the
folder containing the database. You need to grant Change permissions on the
folder to both the IUSR and IWAM accounts.

Bob Barrows
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Trapulo]

"Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
news:%23NnP2qlnDHA.2188@TK2MSFTNGP11.phx.gbl...

> Trapulo wrote:

> > "MSFT" <lukezhan@online.microsoft.com> wrote in message
> > news:5HPpcGgnDHA.2828@cpmsftngxa06.phx.gbl...

> >> When the error occurred, you may check the .ldb file in the same
> >> folder as mdb, to see if there are too many user open the database
> >> at same time.

> >
> > When you open mdb from IIS there is not the ldb file

>
> There should be. The fact that there isn't means that the account that IIS
> is using to connect to the database does not have sufficient rights for

the

> folder containing the database. You need to grant Change permissions on

the

> folder to both the IUSR and IWAM accounts.

I know, but if I have a wrong setting the application doesn't start. On my
server, it satrtst and then stops random.

However, as I said,I resolved and the problem was not here. But I don't
understand why my W2K and IIS IWAM user was running in that way.

bye