sql server odbc: Contractor built a .Net app (ASP.Net/VB.net) app for us.
One function reads an Excel spreadsheet. This
function "works on their machine", but not in our Server
environment - unable to read the file. Other DB related
functionality works. Found a message somewhere indicating
that for Excel access the Jet Engine (4.0) is needed. Of
course we do not have Office or Access loaded on this web
server. How do I get the JetDB engine to load on this

First, go to msdn.microsoft.com/downloads to get the Jet engine. It
doesn't come with MDAC any more. Then you will need to make sure that
the aspnet worker process account has read, write and delete file
system permissions to the share on which the mdb and the mdw live if
you have an actual Jet database in play. If its not an actual database
you're using but only xls files, then ditto on the permissions issue.
I must say your contractors weren't very helpful. Part of what they're
supposed to do is make sure that whatever they build works on their
client's machine (or so I've been told :-)

-- Mary
MCW Technologies
http://www.mcwtech.com

On Fri, 24 Oct 2003 14:27:22 -0700, "glennf" <gfroemming@yahoo.com>
[quoted text, click to view]