Re: PROBLEM CONNECTION ON REMOTE ACCESS DATABASE

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bob Barrows (reb01501_at_NOyahoo.SPAMcom)
Date: 03/25/04 

Date: Wed, 24 Mar 2004 20:24:59 -0500

YERVANT wrote:
> I have a problem with my connection.
>
> My computer is a customer Windows 2000 Professional, I
> Installed IIS into my computer.
> I want use a connection with a remote database into the
> server or other computer (The server is Windows 2000
> Server).
>
> When I put the database into a folder in my computer like
> this (C:\toto\cli_sat.mdb)
> The web site connection function in all of the computers
> in the network.
>
> Here it's the code :
>
> DSN_BASE="Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=C:\toto\cli_sat.mdb;"
>
>
> But When I want use a remote database into the other
> computer (in the same network) like this :
> (\\Srv\Bd\cli_sat.mdb)
>
> The web site connection function only in my computer and
> not in the other computer connected in the same network :
>
> Here it's the code :
>
> DSN_BASE="Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=\\Srv\Bd\cli_sat.mdb;"
>
> And here it's the error message that I see in the other
> computer:
>
> Error Type:
> Microsoft JET Database Engine (0x80004005)
> The Microsoft Jet database engine cannot open the
> file '\\Srv\Bd\cli_sat.mdb'. It is already opened
> exclusively by another user, or you need permission to
> view its data.
> /cli_sat/_connexion.asp, line 10
>
> What I must do if I want that function in all the network
> computer?
>
> Somebody could help me please?
> Thanks.

Please read this article carefully and follow all related links. Your
solution is in there:
http://www.aspfaq.com/show.asp?id=2009

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"

Relevant Pages

  • Re: Connection Problem
    ... >>least I think I have because a) the connection tested okay and b) when I ... >> Private Sub Page_Load(ByVal sender As System.Object, ...
    (microsoft.public.dotnet.framework.aspnet)
  • PROBLEM CONNECTION ON REMOTE ACCESS DATABASE
    ... I have a problem with my connection. ... My computer is a customer Windows 2000 Professional, ... computer (in the same network) like this: ... The Microsoft Jet database engine cannot open the ...
    (microsoft.public.inetserver.asp.db)
  • Dial up networking and MS Jet Database
    ... Resently my computer show an error message when I disconnect my dial up ... connection. ... "The Microsoft Jet database engine stopped the process because you and ...
    (microsoft.public.windowsxp.network_web)
  • Re: Connection String
    ... >I am making a asp page that will run on my computer by iis. ... > work for it though here his the connection and the error. ... Microsoft JET Database Engine ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Problems with Permissions
    ... And SBS server is only take ... the role of an internal server. ... they are all configured to connected to internal network. ... g. Run the Configure Email and Internet Connection Wizard on SBS server. ...
    (microsoft.public.windows.server.sbs)