I'm getting this provider error :

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file
already in use.

/Cannes/restaurantResult.asp, line 29

Which line 29 always points to the :

<%
set rsQueryRestaurant = Server.CreateObject("ADODB.Recordset"
rsQueryRestaurant.ActiveConnection = "dsn=Azuriviera;"
.
%>

According to my provider it's due to a piece of code missing which one
leaves the Access Database open. If it's the case that UD omits the code to
close the database then how do I fix that?

I've added <% rsMyRecordset.Close() %> but it still gives me errors.

I'm using UD4, Access DB, VBscript, ASP on a Windows 2000 platform, IIS 5.

Thank you for your help.

Jean-François

(Sorry Waldo for the wrong place posting)

I have the same prob, my friend.

The error is this or a 80004005
driver not found ... :-(

It's driving me MAAAAAAAAAD

-b

again read this tutorial - it might help:

www.basic-ultradev.com/articles/ADOConnections/

Greetings,
George Petrov
www.UDzone.com

George,

Is there really such a difference.
UD4 closes the recordset at the bottom of
my pages :

<%
Recordset1.Close()
%>

The tut says you can close it with this code :

<%
Recordsetname.close
set Recordsetname = nothing
%>

Does setting the recordname to nothing
make such a difference ?

-b
<font size=1><i>(aka the asp-newbie, asking silly q's)</i></font id=size1>

No there is no big difference ... both works ok.
They say that assigning Recordsetname = nothing clears up more resourses - but they are different opinions about this one.

Greetings,
George Petrov
www.UDzone.com

hmmm,
was hoping you'd say : YEEEzz there is a big difference ! :-)

For now everything works fine,
but this error will strike again,
i'm sure. i already checked everything
(permissions, global.asa, dsn, ..)

I even remade the complete page from scratch
Nothing seems to work ...

keeping my finger crossed,

-b

Hi George and Jezter,

Well the way I fixed it for now and it works is that I removed the second recordset from each page. I know, I know it's not the best way to do this but it works. It seems like my provider has a configuration that doesn't allow 2 recordset on the same page.

Regarding the closing ASP tag I personaly like to place it right before the &lt;/html&gt; tag at the bottom of the page to make sure it is read.

Just like this.

&lt;%
rsHotel.Close()
%&gt;
&lt;/html&gt;

So I'm certain that when the browser reads the page it will complete the closing tag before leaving to another page.

I'm still working on this error 80004005 and until I find it or if you do please let me know.

Thank you all for your help.

Jean-François

Hi Jean-F, George, ppl,

At home I have a dual boot machine. Win ME (games) and Win2000 for the other things in life :-)

Well here comes the pain ...

- WinMe had absolutely no 80004005 problem
- Win2000 can't get enough of that particular error.

Yes, I gave everybody FULL control on the database, ... hell, I gave everybody FULL control on the machine ... Global.asa seems to work fine, ... but out of nowhere ... BLAM, kaput, finito, game over, ...

I'm starting to think it's me ...

-b

PS : some OT great news ... Opeth is coming to EuroRock (Belgium) ... <img src=icon_smile_evil.gif border=0 align=middle>