Jet OLE DB Error

Afternoon.

We have a text file that contains MSSearch noise words that our developers bring into the application. We have this process on many other SP3a servers and it works just fine.

We just installed SQL Server 2000 SP3a on a new server and now we get the error of :

Server: Msg 7357, Level 16, State 2, Line 13
Could not process object 'select * from noise.enu'. The OLE DB provider 'Microsoft.Jet.OLEDB.4.0' indicates that the object has no columns.
OLE DB error trace [Non-interface error: OLE DB provider unable to process object, since the object has no columnsProviderName='Microsoft.Jet.OLEDB.4.0', Query=select * from noise.enu'].

When we execute the following code:

select distinct [NoiseWord] = x.[F1]
from openrowset
(
'Microsoft.Jet.OLEDB.4.0',
'Text;HDR=no;Database=C:\Program Files\Common Files\System\MSSearch\Data\Config\',
'select * from noise.enu'
) as x
where x.[F1] is not NULL

The Noise.enu file is the default file that installed with SQL Server. No modifications have been made. We even copied this file to a server that was working and it too worked. Then we even copied the enu file from a working server to the new server and received the same error.

Any help would be greatly appriciated.

Thanks ALL!



Answer this question

Jet OLE DB Error

  • Jet OLE DB Error