This is a discussion on System resource exceeded within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Recently the error message below started appearing when running a query against simple Excel spreadsheets. In the past this ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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::Initialize returned 0x80004005: ]. Query: SELECT * FROM OpenRowset ('MSDASQL', 'Driver=Microsoft Excel Driver (*.xls);DBQ=c:\Temp\Test', 'SELECT * FROM [Plan1$]') Any tips? Thanx in advance, Philip |