Re: local ACCESS db connection
From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 09/29/04
- Next message: William \(Bill\) Vaughn: "Re: Calling SP from ADO and passing parameters"
- Previous message: JerryScott: "local ACCESS db connection"
- In reply to: JerryScott: "local ACCESS db connection"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 29 Sep 2004 11:00:53 -0700
Ah, the code you execute in an ASP page executes on the server. It has no
idea what system the request comes from. You told it to look on the local C:
drive... it did. In order to open a local file, you would have to somehow
address that file. Assuming you have sufficient rights (and you probably
don't) your ASP application would use something like
"yourClientSystem\yourSharedDrive\yourAccessFilePath.mdb". But consider the
way a JET database works. It does physical IO over this connection. You
really don't want to do this for a dozen reasons.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"JerryScott" <JerryScott@discussions.microsoft.com> wrote in message
news:4A2C1DCC-0CD8-4C5F-8980-C43D61BE9E4C@microsoft.com...
>I posted this elsewhere but this seems to be more approapriate.
> I have a webserver running 2000 Advanced Server and SQL 7 Server. These
> work
> fine, but I need to connect to an ACCESS database on my desktop using an
> ASP
> page. The path to the local database is: "C:\Program
> Files\NEAT\Data\dbSPAM3000.mdb".
> I put that in:
> dbPath = "C:\Program Files\NEAT\data\dbSPAM3000.mdb"
> Set cnl = Server.CreateObject("ADODB.Connection")
> cnl.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=" & dbPath
>
> but it tells me that path doesn't exist. I have added the "\\" to the
> front
> of the path like we "used" to have to do for local paths, still doesn't
> work.
>
> It seems it is opening that path on the Server, NOT on my local desktop.
> This database was created with a Visual Basic application and works fine,
> BUT, I need this functionallity from an ASP page on my webserver and NOT
> having any luck.
> Thanks.
- Next message: William \(Bill\) Vaughn: "Re: Calling SP from ADO and passing parameters"
- Previous message: JerryScott: "local ACCESS db connection"
- In reply to: JerryScott: "local ACCESS db connection"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
