473,320 Members | 2,110 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

error 80004005

hi,

in an ASP page, I coonect to a MSACCESS database and the first load of the
page is correct but, when I immediately refresh the same page, I get an
80004005 error...

Thanks for any idea...

Here is the code :
Set Conn = Server.CreateObject("ADODB.Connection")
str = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(".")
&"\Ficli_data.mdb"
Conn.Open str

Set rs2 = Server.CreateObject("ADODB.Recordset")
SQL1 = "select * from TSites order by nom_int"
rs2.Open SQL1, Conn
continuer = 1
nb = 0
do while ((not rs2.eof) And (nb <= nbrep))
nb = nb + 1
if (nb=1) then response.write("<b>")
response.write("<br>" & rs2("toto"))
if (nb=1) then response.write("</b>")
rs2.movenext
Loop
rs2.close
set rs2=nothing

Conn.close
set Conn=nothing


Jul 19 '05 #1
5 2386
As most people probably do not have the error description memorized for each
error number, it's generally best to include the actual error message when
posting. Also indicate the line on which the error occurs. But here are
the most common causes for an 80004005 error.
http://www.aspfaq.com/show.asp?id=2009
Ray at home
"Christophe Cerbourg" <so*****@some.where> wrote in message
news:c0**********@news-reader4.wanadoo.fr...
hi,

in an ASP page, I coonect to a MSACCESS database and the first load of the
page is correct but, when I immediately refresh the same page, I get an
80004005 error...

Thanks for any idea...

Here is the code :
Set Conn = Server.CreateObject("ADODB.Connection")
str = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(".") &"\Ficli_data.mdb"
Conn.Open str

Set rs2 = Server.CreateObject("ADODB.Recordset")
SQL1 = "select * from TSites order by nom_int"
rs2.Open SQL1, Conn
continuer = 1
nb = 0
do while ((not rs2.eof) And (nb <= nbrep))
nb = nb + 1
if (nb=1) then response.write("<b>")
response.write("<br>" & rs2("toto"))
if (nb=1) then response.write("</b>")
rs2.movenext
Loop
rs2.close
set rs2=nothing

Conn.close
set Conn=nothing


Jul 19 '05 #2
sorry for I didn't give you enough informations.

The exact message is :
Provider (0x80004005)
Erreur non spécifiée (which means "not specified error"
/test/fdcli.asp, line 24 (the line of the CONNECT statement)

also thanks for the FAQ but I've already check the permissions of IUSR... on
the folder, the database is on my computer for test and I'm the only user.

What I wonder is why it works the first time, then not work again if I
refresh the page, then works again after about one minute ???

Thanks for any help
Jul 19 '05 #3
Christophe Cerbourg wrote:
hi,

in an ASP page, I coonect to a MSACCESS database and the first load
of the page is correct but, when I immediately refresh the same page,
I get an 80004005 error...

Thanks for any idea...

Here is the code :
Set Conn = Server.CreateObject("ADODB.Connection")
str = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath(".") &"\Ficli_data.mdb"
Conn.Open str

Set rs2 = Server.CreateObject("ADODB.Recordset")
SQL1 = "select * from TSites order by nom_int"
rs2.Open SQL1, Conn
continuer = 1
nb = 0
do while ((not rs2.eof) And (nb <= nbrep))
nb = nb + 1
if (nb=1) then response.write("<b>")
response.write("<br>" & rs2("toto"))
if (nb=1) then response.write("</b>")
rs2.movenext
Loop
rs2.close
set rs2=nothing

Conn.close
set Conn=nothing

Since you say you have already verified IUSR permissions to the folder
containing the database, I suggest you switch to the native Jet OLEDB
Provider instead of using the obsolete ODBC driver:

str = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
Data Source=" & Server.MapPath(".\Ficli_data.mdb")

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"
Jul 19 '05 #4
thanks Bob for answering.
Is this driver already installed or should I look for it somewhere ?
If so, thanks for any link.
"Bob Barrows" <re******@NOyahoo.SPAMcom> a écrit dans le message de
news:O8*************@tk2msftngp13.phx.gbl...
Christophe Cerbourg wrote:
hi,

in an ASP page, I coonect to a MSACCESS database and the first load
of the page is correct but, when I immediately refresh the same page,
I get an 80004005 error...

Thanks for any idea...

Here is the code :
Set Conn = Server.CreateObject("ADODB.Connection")
str = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath(".") &"\Ficli_data.mdb"
Conn.Open str

Set rs2 = Server.CreateObject("ADODB.Recordset")
SQL1 = "select * from TSites order by nom_int"
rs2.Open SQL1, Conn
continuer = 1
nb = 0
do while ((not rs2.eof) And (nb <= nbrep))
nb = nb + 1
if (nb=1) then response.write("<b>")
response.write("<br>" & rs2("toto"))
if (nb=1) then response.write("</b>")
rs2.movenext
Loop
rs2.close
set rs2=nothing

Conn.close
set Conn=nothing

Since you say you have already verified IUSR permissions to the folder
containing the database, I suggest you switch to the native Jet OLEDB
Provider instead of using the obsolete ODBC driver:

str = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
Data Source=" & Server.MapPath(".\Ficli_data.mdb")

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"

Jul 19 '05 #5
Christophe Cerbourg wrote:
thanks Bob for answering.
Is this driver already installed or should I look for it somewhere ?
If so, thanks for any link.


Yes, it is installed as part of the MDAC installation. If it fails on you,
go to www.microsoft.com/data and get the separate Jet engine download.

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"
Jul 19 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Richard | last post by:
I have been programming in Access and HTML for several years and have decided to put these together by adding ecommerce to my site in ASP. I bought a template from ecommercetemplates and just need...
15
by: M P | last post by:
What does this mean? I am accessing an ASP page that queries Access Database thru fileDSN. I'm using IIS 5.0 Win2K SP4 Microsoft OLE DB Provider for ODBC Drivers error '80004005' General...
7
by: A P | last post by:
I receive an error like this: Server.MapPath() error 'ASP 0172 : 80004005' Invalid Path /conn.asp, line 2 The Path parameter for the MapPath method must be a virtual path. A physical path...
2
by: Maurizio Amoroso | last post by:
.... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_4 DTSRun OnStart:...
6
by: Rowan | last post by:
Hello, I have been trying to solve this problem for a couple of weeks now with no progress. I created a package that works when it runs from my computer but when it runs as a scheduled job, it...
9
by: Luc Dal | last post by:
Hello, I've serious problem using ASP under WindowsXP sp2. I get the following reply (sorry it's in french) Erreur de compilation Microsoft VBScript error '800a0401' Fin d'instruction...
2
by: ago | last post by:
I am trying to make the win32com HelloWorld server work with a VBA client but I get: Run-time error '-2147467259(80004005)': Automation error Unspecified error I googled for the error but...
7
by: samah | last post by:
I have a package i used it for 3 days ago and then i got these 2 error Run Time Error unspecified error ( 80004005) and Run Time Error Could not lock file ( 80004005) and these are my codes...
0
by: andy3381 | last post by:
Hi, I am having a scheduled job running DTS packages on my production environment. My production server server is having Window 2003 Sp2 installed on it. Before rebuilding the server I was...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.