MS SQL Server ODBC - System resource exceeded

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

System resource exceeded

Philip McComish

2005-06-29, 9:23 am

Recently the error message below started appearing when running a query
against simple Excel spreadsheets.
In the past this worked perfectly. Don´t know if the recently applied SP4
might have anything to do with it.

System:
SQL Server 2000 SP4 on Windows 2000 SP4

Error:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Excel Driver] System
resource exceeded.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initi
alize
returned 0x80004005: ].

Query:
SELECT * FROM OpenRowset
('MSDASQL', 'Driver=Microsoft Excel Driver (*. xls);DBQ=c:\Temp\Tes
t',
'SELECT * FROM [Plan1$]')

Any tips?

Thanx in advance,

Philip

Sponsored Links