OPENDATASOURCE & Could not find installable ISAM

Question

OPENDATASOURCE & Could not find installable ISAM

allen davidson

SSCertifiable

Points: 7042
More actions
October 23, 2006 at 8:18 am

#121006

Hi, I am using this query to read Excel data
          SELECT
                   CAST([Campaign Name] AS VARCHAR(255)),
                   CAST([Campaign Name] AS VARCHAR(255)),
                   CAST([Country Code] AS VARCHAR(255))
           FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0','Data Source="C:\Temp\DE.xls";User ID=Admin;Password=;Extended properties=''Excel 8.0;HDR=YES;IMEX=1''')...nrCampaign
And getting this error:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Could not find installable ISAM.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005:   ].
The query used to work (honest the dog has not eaten my homework).
MDAC is 2.8 , msexcl40.dll is version 4.00.8618.0, the registry points to this file.
Any suggestions gratefully received.
Allen

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

allen davidson SSCertifiable Points: 7042 More actions · Answer 1

Oh dear - it just worked fine twice in a row and has now failed again! I think I shall bounce the server. Still failing on my desktop though!

IanMGSmith Ten Centuries Points: 1286 More actions · Answer 2

Hi Allen,

From limited experience, this error can be caused by a number of things.

You have no doubt looked at http://support.microsoft.com/kb/209805

All I can suggest is that you map out the architecture together with the flow of credentials and permissions to, within and beyond SQL Server.

i.e. If SQL Server runs on service account and if you are connecting with SQL logon then service account credentials will be presented to the (foreign resource) file server.

This may explain problem on desktop however, assuming absolutely nothing changes between tests, the erratic behavior on server is beyond me.

Sorry, not much help.

Kind regards,

Ian

PS: may be away and unable to respond further.

Kindest Regards,

Ian Smith

allen davidson SSCertifiable Points: 7042 More actions · Answer 3

Thanks Ian,

Well I fnally ran out of ideas - bounced the server and hey ho all is working again.