Re: BULK INSERT from a mapped drive
From: Marc (newsgroups_at_ris-nospam-web.net)
Date: 04/29/04
- Next message: JRE: "Newbee password question"
- Previous message: Tibor Karaszi: "Re: BULK INSERT from a mapped drive"
- In reply to: Tibor Karaszi: "Re: BULK INSERT from a mapped drive"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 29 Apr 2004 22:19:47 +0200
Tibor,
Thank's for your help....
Marc
"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> schrieb
im Newsbeitrag news:uoy$WViLEHA.1388@TK2MSFTNGP09.phx.gbl...
> Hmm, then I can only assume that there's some new stuff in W2K3 that I
haven't heard about before. Perhaps
> post this to a Windows forum as a general question ("service accessing
share through mapped drive")?
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
>
>
> "Marc" <newsgroups@ris-nospam-web.net> wrote in message
news:40914a26$0$704$5402220f@news.sunrise.ch...
> > Tibor,
> >
> > Yes, the mapped drive is visible & accessible by the Account.
> >
> > Marc
> >
> > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com>
schrieb
> > im Newsbeitrag news:O0QxpUhLEHA.1388@TK2MSFTNGP09.phx.gbl...
> > > Fist thing to try would be to log in as the SQL Server service account
as
> > see if the mapping exists for that
> > > account.
> > >
> > > --
> > > Tibor Karaszi, SQL Server MVP
> > > http://www.karaszi.com/sqlserver/default.asp
> > >
> > >
> > > "Marc" <newsgroups@ris-nospam-web.net> wrote in message
> > news:409143a0$0$713$5402220f@news.sunrise.ch...
> > > > Hi
> > > >
> > > > I'm trying to BULK INSERT some data from a simple text file,
residing on
> > a
> > > > mapped drive (F:\)
> > > > Well, I know, it's better to use UNC-Paths, but it was "programmed"
in
> > that
> > > > manner some years ago. (Some dozens of stored procs which I don't
want
> > to
> > > > change)
> > > >
> > > > This problem persists since we upgraded from NT/2000 to Server2003
> > (still
> > > > using SQL 2000):
> > > > while trying to bulk insert, I get an error, that the file can't be
> > > > found/accessed. (Path is correct)
> > > >
> > > > MSDTC is configured running as a Domain-Account, and accessing the
> > network
> > > > (COM-Configuration)
> > > > MSSQLSERVER-service is also configured as a Domain-Account.
> > > > Could this be a setting in Server2003 which I didn't found yet ???
> > > >
> > > > Any help would be appreciated
> > > > Many thanks & regards,
> > > > Marc
> > > >
> > > >
> > >
> > >
> >
> >
>
>
- Next message: JRE: "Newbee password question"
- Previous message: Tibor Karaszi: "Re: BULK INSERT from a mapped drive"
- In reply to: Tibor Karaszi: "Re: BULK INSERT from a mapped drive"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
