SQL Server permissions problem
From: Mihaela M. (mihaela.mesaros_at_s-concept.net)
Date: 08/04/04
- Next message: Kevin McDonnell [MSFT]: "RE: SSL SQL Server & ASP.NET"
- Previous message: sourappletart: "RE: in need of knowledge"
- Next in thread: Manoj Gadhia: "SQL Server permissions problem"
- Reply: Manoj Gadhia: "SQL Server permissions problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 4 Aug 2004 22:57:41 +0300
Hello.
Here is my problem.
I have a CSV file on a server, let's say "server1".
I have also a stored procedure, into a SQL Server database, which is located
on another server, let's say "server2".
These 2 servers are in the same network.
I need to connect from the stored procedure to the CSV file, using
OPENDATASOURCE, like this:
OPENDATASOURCE(''Microsoft.Jet.OLEDB.4.0'',''Data
Source=\\Idd1\test_files_import\1_files;Extended
Properties="text;HDR=Yes;FMT=Delimited"'')...CLASSES#CSV
It gives the following error:
Microsoft OLE DB Provider for SQL Server error '80040e14'
[OLE/DB provider returned message: '\\Idd1\test_files_import\1_files' is not
a valid path. Make sure that the path name is spelled correctly and that you
are connected to the server on which the file resides.]
The path is valid, I'm sure about it. Maybe it is a users permissions
problem.
Shouldn't I set permissions for SQL Server user for this folder?
But what user SQL Server uses?
Thanks for any help!
- Next message: Kevin McDonnell [MSFT]: "RE: SSL SQL Server & ASP.NET"
- Previous message: sourappletart: "RE: in need of knowledge"
- Next in thread: Manoj Gadhia: "SQL Server permissions problem"
- Reply: Manoj Gadhia: "SQL Server permissions problem"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
