| Guran Baksh 2006-12-06, 7:12 pm |
| 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::Initi
alize
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::Initi
alize
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!
*** Sent via Developersdex http://www.droptable.com ***
|