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

V

Veronika

Hi; I get the following error message when trying to get to my
2nd/subsequent asp.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

When I refresh, I get the following error:

Provider error '80004005'

Unspecified error

/Annron2005/top2.asp, line 4

Line 1 <% Language="VBScript"
Line 2 DSN_Name = Session("DSN_Name")
Line 3 set Connection = Server.CreateObject("ADODB.Connection")
Line 4 Connection.Open DSN_Name
Line 5 %>


I have no problem running this web site on ISP or on my old laptop. My new
laptop is running Windows Media Center as oppose to Window XP Pro on my old
laptop. This web site was created with StoreFront 2000. To me it appears
that my server is not releasing something. If I wait long enough, I can
refresh the first asp page. This site was published to my laptop from ISP.
My other web sites with database work fine on my new laptop. Other database
web sites were created just with my sql statement.

Any suggestions?

Veronika
 
S

Stefan B Rusynko

Close your DB connection at the bottom of each page
- make sure it has been opened before you try to close it

<%
Connection.Close
Set Connection = Nothing
%>

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Hi; I get the following error message when trying to get to my
| 2nd/subsequent asp.
| Microsoft OLE DB Provider for ODBC Drivers error '80004005'
|
| [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file
| already in use.
|
| When I refresh, I get the following error:
|
| Provider error '80004005'
|
| Unspecified error
|
| /Annron2005/top2.asp, line 4
|
| Line 1 <% Language="VBScript"
| Line 2 DSN_Name = Session("DSN_Name")
| Line 3 set Connection = Server.CreateObject("ADODB.Connection")
| Line 4 Connection.Open DSN_Name
| Line 5 %>
|
|
| I have no problem running this web site on ISP or on my old laptop. My new
| laptop is running Windows Media Center as oppose to Window XP Pro on my old
| laptop. This web site was created with StoreFront 2000. To me it appears
| that my server is not releasing something. If I wait long enough, I can
| refresh the first asp page. This site was published to my laptop from ISP.
| My other web sites with database work fine on my new laptop. Other database
| web sites were created just with my sql statement.
|
| Any suggestions?
|
| Veronika
|
|
 
S

Stefan B Rusynko

PS
The reason you are getting the errors only when running under Localhost is IIS (for both Win XPpro & Win MC) are limited to 10
connections (that is not 10 users, but 10 server connections)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Close your DB connection at the bottom of each page
| - make sure it has been opened before you try to close it
|
| <%
| Connection.Close
| Set Connection = Nothing
| %>
|
| --
|
| _____________________________________________
| SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| "Warning - Using the F1 Key will not break anything!" (-;
| _____________________________________________
|
|
|| Hi; I get the following error message when trying to get to my
|| 2nd/subsequent asp.
|| Microsoft OLE DB Provider for ODBC Drivers error '80004005'
||
|| [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file
|| already in use.
||
|| When I refresh, I get the following error:
||
|| Provider error '80004005'
||
|| Unspecified error
||
|| /Annron2005/top2.asp, line 4
||
|| Line 1 <% Language="VBScript"
|| Line 2 DSN_Name = Session("DSN_Name")
|| Line 3 set Connection = Server.CreateObject("ADODB.Connection")
|| Line 4 Connection.Open DSN_Name
|| Line 5 %>
||
||
|| I have no problem running this web site on ISP or on my old laptop. My new
|| laptop is running Windows Media Center as oppose to Window XP Pro on my old
|| laptop. This web site was created with StoreFront 2000. To me it appears
|| that my server is not releasing something. If I wait long enough, I can
|| refresh the first asp page. This site was published to my laptop from ISP.
|| My other web sites with database work fine on my new laptop. Other database
|| web sites were created just with my sql statement.
||
|| Any suggestions?
||
|| Veronika
||
||
|
|
 
V

Veronika

Thanks I will try it. However this web site is working fine on my old
laptop..... why it that??
 
D

David Berry

There must be something set up differently on your new laptop. Check the
ODBC connection and IIS and compare it to your other laptop


Veronika said:
Thanks I will try it. However this web site is working fine on my old
laptop..... why it that??

Stefan B Rusynko said:
PS
The reason you are getting the errors only when running under Localhost
is IIS (for both Win XPpro & Win MC) are limited to 10
connections (that is not 10 users, but 10 server connections)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Close your DB connection at the bottom of each page
| - make sure it has been opened before you try to close it
|
| <%
| Connection.Close
| Set Connection = Nothing
| %>
|
| --
|
| _____________________________________________
| SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| "Warning - Using the F1 Key will not break anything!" (-;
| _____________________________________________
|
|
|| Hi; I get the following error message when trying to get to my
|| 2nd/subsequent asp.
|| Microsoft OLE DB Provider for ODBC Drivers error '80004005'
||
|| [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)';
file
|| already in use.
||
|| When I refresh, I get the following error:
||
|| Provider error '80004005'
||
|| Unspecified error
||
|| /Annron2005/top2.asp, line 4
||
|| Line 1 <% Language="VBScript"
|| Line 2 DSN_Name = Session("DSN_Name")
|| Line 3 set Connection = Server.CreateObject("ADODB.Connection")
|| Line 4 Connection.Open DSN_Name
|| Line 5 %>
||
||
|| I have no problem running this web site on ISP or on my old laptop. My
new
|| laptop is running Windows Media Center as oppose to Window XP Pro on
my old
|| laptop. This web site was created with StoreFront 2000. To me it
appears
|| that my server is not releasing something. If I wait long enough, I
can
|| refresh the first asp page. This site was published to my laptop from
ISP.
|| My other web sites with database work fine on my new laptop. Other
database
|| web sites were created just with my sql statement.
||
|| Any suggestions?
||
|| Veronika
||
||
|
|
Click to expand...
Click to expand...
 
V

Veronika

ODBC connection works, I get at least one asp page to open on this web. Most
times it takes time in between tries (like an hour!), but at least I know it
correct set-up.


David Berry said:
There must be something set up differently on your new laptop. Check the
ODBC connection and IIS and compare it to your other laptop


Veronika said:
Thanks I will try it. However this web site is working fine on my old
laptop..... why it that??

Stefan B Rusynko said:
PS
The reason you are getting the errors only when running under Localhost
is IIS (for both Win XPpro & Win MC) are limited to 10
connections (that is not 10 users, but 10 server connections)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Close your DB connection at the bottom of each page
| - make sure it has been opened before you try to close it
|
| <%
| Connection.Close
| Set Connection = Nothing
| %>
|
| --
|
| _____________________________________________
| SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| "Warning - Using the F1 Key will not break anything!" (-;
| _____________________________________________
|
|
|| Hi; I get the following error message when trying to get to my
|| 2nd/subsequent asp.
|| Microsoft OLE DB Provider for ODBC Drivers error '80004005'
||
|| [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)';
file
|| already in use.
||
|| When I refresh, I get the following error:
||
|| Provider error '80004005'
||
|| Unspecified error
||
|| /Annron2005/top2.asp, line 4
||
|| Line 1 <% Language="VBScript"
|| Line 2 DSN_Name = Session("DSN_Name")
|| Line 3 set Connection = Server.CreateObject("ADODB.Connection")
|| Line 4 Connection.Open DSN_Name
|| Line 5 %>
||
||
|| I have no problem running this web site on ISP or on my old laptop.
My new
|| laptop is running Windows Media Center as oppose to Window XP Pro on
my old
|| laptop. This web site was created with StoreFront 2000. To me it
appears
|| that my server is not releasing something. If I wait long enough, I
can
|| refresh the first asp page. This site was published to my laptop from
ISP.
|| My other web sites with database work fine on my new laptop. Other
database
|| web sites were created just with my sql statement.
||
|| Any suggestions?
||
|| Veronika
||
||
|
|
Click to expand...
Click to expand...
Click to expand...
 
B

Bob Lehmann

This is likely a permmissions issues.

The IUSR_<machine name> user needs write permissions on the db and the
folder which contains the db.

Bob Lehmann

Veronika said:
ODBC connection works, I get at least one asp page to open on this web. Most
times it takes time in between tries (like an hour!), but at least I know it
correct set-up.


David Berry said:
There must be something set up differently on your new laptop. Check the
ODBC connection and IIS and compare it to your other laptop


Veronika said:
Thanks I will try it. However this web site is working fine on my old
laptop..... why it that??

PS
The reason you are getting the errors only when running under Localhost
is IIS (for both Win XPpro & Win MC) are limited to 10
connections (that is not 10 users, but 10 server connections)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Close your DB connection at the bottom of each page
| - make sure it has been opened before you try to close it
|
| <%
| Connection.Close
| Set Connection = Nothing
| %>
|
| --
|
| _____________________________________________
| SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| "Warning - Using the F1 Key will not break anything!" (-;
| _____________________________________________
|
|
|| Hi; I get the following error message when trying to get to my
|| 2nd/subsequent asp.
|| Microsoft OLE DB Provider for ODBC Drivers error '80004005'
||
|| [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)';
file
|| already in use.
||
|| When I refresh, I get the following error:
||
|| Provider error '80004005'
||
|| Unspecified error
||
|| /Annron2005/top2.asp, line 4
||
|| Line 1 <% Language="VBScript"
|| Line 2 DSN_Name = Session("DSN_Name")
|| Line 3 set Connection = Server.CreateObject("ADODB.Connection")
|| Line 4 Connection.Open DSN_Name
|| Line 5 %>
||
||
|| I have no problem running this web site on ISP or on my old laptop.
My new
|| laptop is running Windows Media Center as oppose to Window XP Pro on
my old
|| laptop. This web site was created with StoreFront 2000. To me it
appears
|| that my server is not releasing something. If I wait long enough, I
can
|| refresh the first asp page. This site was published to my laptop from
ISP.
|| My other web sites with database work fine on my new laptop. Other
database
|| web sites were created just with my sql statement.
||
|| Any suggestions?
||
|| Veronika
||
||
|
|
Click to expand...
Click to expand...
Click to expand...
 
V

Veronika

I actually gave permission to read/write to all the possibilities listed on
my laptop..
Still no help

Bob Lehmann said:
This is likely a permmissions issues.

The IUSR_<machine name> user needs write permissions on the db and the
folder which contains the db.

Bob Lehmann

Veronika said:
ODBC connection works, I get at least one asp page to open on this web. Most
times it takes time in between tries (like an hour!), but at least I know it
correct set-up.


David Berry said:
There must be something set up differently on your new laptop. Check the
ODBC connection and IIS and compare it to your other laptop


Thanks I will try it. However this web site is working fine on my old
laptop..... why it that??

PS
The reason you are getting the errors only when running under Localhost
is IIS (for both Win XPpro & Win MC) are limited to 10
connections (that is not 10 users, but 10 server connections)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Close your DB connection at the bottom of each page
| - make sure it has been opened before you try to close it
|
| <%
| Connection.Close
| Set Connection = Nothing
| %>
|
| --
|
| _____________________________________________
| SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| "Warning - Using the F1 Key will not break anything!" (-;
| _____________________________________________
|
|
|| Hi; I get the following error message when trying to get to my
|| 2nd/subsequent asp.
|| Microsoft OLE DB Provider for ODBC Drivers error '80004005'
||
|| [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)';
file
|| already in use.
||
|| When I refresh, I get the following error:
||
|| Provider error '80004005'
||
|| Unspecified error
||
|| /Annron2005/top2.asp, line 4
||
|| Line 1 <% Language="VBScript"
|| Line 2 DSN_Name = Session("DSN_Name")
|| Line 3 set Connection = Server.CreateObject("ADODB.Connection")
|| Line 4 Connection.Open DSN_Name
|| Line 5 %>
||
||
|| I have no problem running this web site on ISP or on my old
laptop.
My new
|| laptop is running Windows Media Center as oppose to Window XP Pro on
my old
|| laptop. This web site was created with StoreFront 2000. To me it
appears
|| that my server is not releasing something. If I wait long enough,
I
can
|| refresh the first asp page. This site was published to my laptop from
ISP.
|| My other web sites with database work fine on my new laptop. Other
database
|| web sites were created just with my sql statement.
||
|| Any suggestions?
||
|| Veronika
||
||
|
|
Click to expand...
Click to expand...
Click to expand...
 
S

Stefan B Rusynko

Doesn't matter
Your WMC and WXP OS may be running other processes which are consuming some of your 10 connections to the local server

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I actually gave permission to read/write to all the possibilities listed on
| my laptop..
| Still no help
|
| | > This is likely a permmissions issues.
| >
| > The IUSR_<machine name> user needs write permissions on the db and the
| > folder which contains the db.
| >
| > Bob Lehmann
| >
| > | >> ODBC connection works, I get at least one asp page to open on this web.
| > Most
| >> times it takes time in between tries (like an hour!), but at least I know
| > it
| >> correct set-up.
| >>
| >>
| >> | >> > There must be something set up differently on your new laptop. Check
| > the
| >> > ODBC connection and IIS and compare it to your other laptop
| >> >
| >> >
| >> > | >> >> Thanks I will try it. However this web site is working fine on my old
| >> >> laptop..... why it that??
| >> >>
| >> >> | >> >>> PS
| >> >>> The reason you are getting the errors only when running under
| > Localhost
| >> >>> is IIS (for both Win XPpro & Win MC) are limited to 10
| >> >>> connections (that is not 10 users, but 10 server connections)
| >> >>>
| >> >>> --
| >> >>>
| >> >>> _____________________________________________
| >> >>> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| >> >>> "Warning - Using the F1 Key will not break anything!" (-;
| >> >>> _____________________________________________
| >> >>>
| >> >>>
| >> >>> | >> >>> | Close your DB connection at the bottom of each page
| >> >>> | - make sure it has been opened before you try to close it
| >> >>> |
| >> >>> | <%
| >> >>> | Connection.Close
| >> >>> | Set Connection = Nothing
| >> >>> | %>
| >> >>> |
| >> >>> | --
| >> >>> |
| >> >>> | _____________________________________________
| >> >>> | SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| >> >>> | "Warning - Using the F1 Key will not break anything!" (-;
| >> >>> | _____________________________________________
| >> >>> |
| >> >>> |
| >> >>> | >> >>> || Hi; I get the following error message when trying to get to my
| >> >>> || 2nd/subsequent asp.
| >> >>> || Microsoft OLE DB Provider for ODBC Drivers error '80004005'
| >> >>> ||
| >> >>> || [Microsoft][ODBC Microsoft Access Driver] Could not use
| > '(unknown)';
| >> >>> file
| >> >>> || already in use.
| >> >>> ||
| >> >>> || When I refresh, I get the following error:
| >> >>> ||
| >> >>> || Provider error '80004005'
| >> >>> ||
| >> >>> || Unspecified error
| >> >>> ||
| >> >>> || /Annron2005/top2.asp, line 4
| >> >>> ||
| >> >>> || Line 1 <% Language="VBScript"
| >> >>> || Line 2 DSN_Name = Session("DSN_Name")
| >> >>> || Line 3 set Connection = Server.CreateObject("ADODB.Connection")
| >> >>> || Line 4 Connection.Open DSN_Name
| >> >>> || Line 5 %>
| >> >>> ||
| >> >>> ||
| >> >>> || I have no problem running this web site on ISP or on my old
| >> >>> laptop.
| >> >>> My new
| >> >>> || laptop is running Windows Media Center as oppose to Window XP Pro
| > on
| >> >>> my old
| >> >>> || laptop. This web site was created with StoreFront 2000. To me it
| >> >>> appears
| >> >>> || that my server is not releasing something. If I wait long enough,
| >> >>> I
| >> >>> can
| >> >>> || refresh the first asp page. This site was published to my laptop
| > from
| >> >>> ISP.
| >> >>> || My other web sites with database work fine on my new laptop. Other
| >> >>> database
| >> >>> || web sites were created just with my sql statement.
| >> >>> ||
| >> >>> || Any suggestions?
| >> >>> ||
| >> >>> || Veronika
| >> >>> ||
| >> >>> ||
| >> >>> |
| >> >>> |
| >> >>>
| >> >>>
| >> >>
| >> >>
| >> >
| >> >
| >>
| >>
| >
| >
|
|
 
B

Bob Lehmann

80004005 errors -
http://support.microsoft.com/kb/306518

Bob Lehmann


Veronika said:
I actually gave permission to read/write to all the possibilities listed on
my laptop..
Still no help

Bob Lehmann said:
This is likely a permmissions issues.

The IUSR_<machine name> user needs write permissions on the db and the
folder which contains the db.

Bob Lehmann

Veronika said:
ODBC connection works, I get at least one asp page to open on this web. Most
times it takes time in between tries (like an hour!), but at least I
Click to expand...
know
it
correct set-up.


There must be something set up differently on your new laptop. Check the
ODBC connection and IIS and compare it to your other laptop


Thanks I will try it. However this web site is working fine on my old
laptop..... why it that??

PS
The reason you are getting the errors only when running under Localhost
is IIS (for both Win XPpro & Win MC) are limited to 10
connections (that is not 10 users, but 10 server connections)

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Close your DB connection at the bottom of each page
| - make sure it has been opened before you try to close it
|
| <%
| Connection.Close
| Set Connection = Nothing
| %>
|
| --
|
| _____________________________________________
| SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| "Warning - Using the F1 Key will not break anything!" (-;
| _____________________________________________
|
|
|| Hi; I get the following error message when trying to get to my
|| 2nd/subsequent asp.
|| Microsoft OLE DB Provider for ODBC Drivers error '80004005'
||
|| [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)';
file
|| already in use.
||
|| When I refresh, I get the following error:
||
|| Provider error '80004005'
||
|| Unspecified error
||
|| /Annron2005/top2.asp, line 4
||
|| Line 1 <% Language="VBScript"
|| Line 2 DSN_Name = Session("DSN_Name")
|| Line 3 set Connection = Server.CreateObject("ADODB.Connection")
|| Line 4 Connection.Open DSN_Name
|| Line 5 %>
||
||
|| I have no problem running this web site on ISP or on my old
laptop.
My new
|| laptop is running Windows Media Center as oppose to Window XP
Click to expand...
Pro
on
my old
|| laptop. This web site was created with StoreFront 2000. To me it
appears
|| that my server is not releasing something. If I wait long enough,
I
can
|| refresh the first asp page. This site was published to my laptop from
ISP.
|| My other web sites with database work fine on my new laptop. Other
database
|| web sites were created just with my sql statement.
||
|| Any suggestions?
||
|| Veronika
||
||
|
|
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 3
The Microsoft Jet database engine cannot open the file '(unknown)'. 7
odbc errors 2
[Microsoft][ODBC Microsoft Access Driver] Could not find installableISAM. 2
Vista - [ODBC Microsoft Access Driver]'(unknown)' 1
ODBC Microsoft Access Driver 1
ODBC microsoft access driver 5
OLE DB Provider for ODBC error 1

Top