Permission problem with OPENROWSET

[gbaksh]

I was hoping to get some help. I'm using SQL server 2000 (on Windows 2000 server)

I have the following code in my stored proc:

SELECT IDENTITY(INT, 1,1) AS excel_row_num, *
INTO #dc_raw
FROM OPENROWSET
('MSDASQL','Driver={Microsoft Text Driver (*.txt; *.csv)};
DEFAULTDIR=E:\DCCSV\;Extensions=CSV;',
'SELECT * FROM DCCSV.csv')

When the Domain users other than myself (I'm part of the local Administrators Group @ OS level) logon to SQL server via Query Analyzer and run the proc, they get the following error while running stored procedure:



Server: Msg 7399, Level 16, State 1, Procedure pr_Get_DC_Exception_Report, Line 12
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Text Driver] Disk or network error.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ].



Soon after they get this error message, I start to get the following error message:

Server: Msg 7399, Level 16, State 1, Procedure pr_Get_DC_Exception_Report, Line 12
OLE DB provider 'MSDASQL' reported an error. The provider did not give any information about the error.
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: The provider did not give any information about the error.].

Can anyone guide me please? Just as a note, the E:\DCCSV\ is a folder located on the physical disk of the SQL server box and has full access rights to Everyone.

Thanks!