Solved

Could not find installable ISAM. Excel 2007

Posted on 2009-04-06
9
2,104 Views
Last Modified: 2012-05-06
I have seen the solutions to this problem, but I can't get any of them to work.

I have an asp page that works when I run the page through my localhost, but as soon as I try to run it on my web server it fails.

On a side note, I have tried both of the following:
Microsoft.Jet.OLEDB.4.0
Microsoft.ACE.OLEDB.12.0

I also modified the registry entry for: HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Jet/4.0/Engines/Excel to point to C:\WINDOWS\System32\msexcel40.dll like my localhost is setup.



strWDir = "//mefspr01/groups/everyone/acct/AMS Working/Automation_Commission.xls"
 
set conExcel = Server.CreateObject("ADODB.Connection")
strConnectionExcel = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strWDir & ";Extended Properties=""Excel 8.0; HDR=Yes;"""
conExcel.Open strConnectionExcel
 
  
' Load ADO Recordset with Excel Data
set rsExcel = Server.CreateObject("ADODB.Recordset")
rsExcel.Open ("SELECT * FROM [Sheet1$]"), strConnectionExcel

Open in new window

0
Comment
Question by:michd
  • 6
  • 3
9 Comments
 
LVL 46

Assisted Solution

by:tbsgadi
tbsgadi earned 100 total points
ID: 24077183
0
 

Author Comment

by:michd
ID: 24077230
That is what I installed to load the Microsoft.ACE.OLEDB.12.0 Provider.
0
 

Author Comment

by:michd
ID: 24077262
I also updated the Excel 8.0 to Excel 12.0...

from this:
strConnectionExcel = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strWDir & ";Extended Properties=""Excel 8.0; HDR=Yes;"""

to this:
strConnectionExcel = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strWDir & ";Extended Properties=""Excel 12.0; HDR=Yes;"""
0
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 46

Expert Comment

by:tbsgadi
ID: 24077459
Have you tried using an xlsx file instead?

Also try writing the full path in one line like

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\TestWorkbook.xlsx;Extended Properties="Excel 12.0;HDR=YES;"
0
 

Author Comment

by:michd
ID: 24077879
Tried that and that too did not work.  I am currently looking at the drivers that both computers have.
0
 

Author Comment

by:michd
ID: 24086228
Well I got the Microsoft Drivers to be the same on both boxes, but I am still getting the ISAM error when I try to run this through a web server browser versus my local box.

set conExcel = Server.CreateObject("ADODB.Connection")
strConnExcel = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=//mefspr01/groups/everyone/acct/AMS Working/Automation_Commission.xlsx;Extended Properties=""Excel 12.0; HDR=Yes;"""
            conExcel.Open strConnExcel

0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 24086339
Can you try mapping a drive?
0
 

Author Comment

by:michd
ID: 24086592
Man this stinks!!!  Still doesn't work.  I am about to see if I can switch to csv vs xls.

set conExcel = Server.CreateObject("ADODB.Connection")
strConnExcel = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=I:\Everyone\Acct\AMS Working\Automation_Commission.xls;Extended Properties=""Excel 12.0; HDR=Yes;"""
conExcel.Open strConnExcel
0
 

Accepted Solution

by:
michd earned 0 total points
ID: 24096967
Any other thoughts?  I have postings out at Microsoft and nothing I try is working.  

I have tried re-registering the dll, checked the registry, and reload MDAC.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question