Re: Recommended Procedure for Importing From Access Across LAN
From: Stefan Berglund (keepit_at_in.thegroups)
Date: 03/25/04
- Next message: Vadim Rapp: "Re: Can I refer to a local recordset or client-side table after the FROM clause ?"
- Previous message: Ayaz Ahmed: "Re: Backup/Restore question"
- In reply to: Hari: "Re: Recommended Procedure for Importing From Access Across LAN"
- Next in thread: Stefan Berglund: "Re: Recommended Procedure for Importing From Access Across LAN"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 24 Mar 2004 22:02:20 -0800
On Thu, 25 Mar 2004 10:27:14 +0530, "Hari"
<hari_prasad_k@hotmail.com> wrote:
in <#k8RjWiEEHA.3676@TK2MSFTNGP09.phx.gbl>
>HI,
>
>Preliminary prerequisite for copying a file from diffrent server is
>Permission. For this the SQL server Service startup account should be
>a domain account with read only permission in the folder where the file
>resides and should have Write permission in local server.
>If you start SQL server in Local system account you cant copy the file
>directly.
>
>Syntax for copying the file from Query ANalyzer:
>
>xp_cmdshell 'copy
>\\stefs-chrysler\MyDocuments\ShowTime\Test\Arbutus_0313.mde C:\ '
>
>
>Thanks
>Hari
>MCDBA
The server is a clone of the client with MSDE installed on it.
When I run the above command I get:
The network path was not found.
NULL
after restarting all SQL Service services to run in the
Administrator account which exists on both boxes (it's a
workgroup not a domain). Can you tell me what I'm doing wrong?
--- Stefan Berglund first shift-minus last a t m s n d o t c o m
- Next message: Vadim Rapp: "Re: Can I refer to a local recordset or client-side table after the FROM clause ?"
- Previous message: Ayaz Ahmed: "Re: Backup/Restore question"
- In reply to: Hari: "Re: Recommended Procedure for Importing From Access Across LAN"
- Next in thread: Stefan Berglund: "Re: Recommended Procedure for Importing From Access Across LAN"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
