tags:

views:

133

answers:

3
Q: 

Need JET 4.0 Drivers

I am using an ExcelProvider with Microsoft.Jet.OLEDB.4.0 and am getting the Cannot Find Installable ISAM from the production machine. Windows Server 2003.

I've searched and search for this download. I've Office installed on the Dev machine, so I'm sure that's why it works fine on my end. But I can't install Office on the Production machine.

A: 

Are you certain that the Jet provider is not already on the machine? The error message most often occurs as a result of a badly formatted connection string rather than the absence of the driver. Check for typos in the connection string.

MikeB  2009-10-11 18:14:45
A: 

Check out this support article: link text

Miha Markic  2009-10-11 18:25:05
That article is way out of date. Jet 4 is included as part of the OS from Windows 2000 on, which is exactly why there was no longer any utility in including Jet in the MDAC. Many people misread this as deprecation of Jet, but it's just common sense not to include in the MDAC components that 99% of users already have installed on their computers.
David-W-Fenton  2009-10-11 20:12:03
I think the official line is that Jet 4.0 is deprecated in favour of ACE except for applications that already use Jet 4.0... something similarly vague and all-encompassing, anyhow. Ditto DAO vs ACEDAO.
onedaywhen  2009-10-12 12:17:40
A: 

I removed IMEX=1; from the string and it worked fine. Weird, at one time it worked fine with this on there. Maybe it has something to do with the versioning, I don't know.

hmcclungiii  2009-10-11 22:20:25

related questions

How do I query raw data from a Proficy Historian?
Reading Excel in .NET, how to get row number?
Persuade Access 2007 to use a .UDL file/oledb connection?
OLEDB Driver Bit?
OLEDB v/s ODBC
How in .Net do I Import Values from a CSV in the format I want using OleDB?
Ignored columns using vb6 to extract from excel
System.Data.OleDb.OleDbException: Invalid internet address. How do you connect to excel files located on a webserver using OleDb
How to determine MS Access field size via OleDb
From SPSS, import data from SQL Server Analysis Services
oledb/ado.net: Get the command's text, with all parameters replaced
Import Text File into generic Database using SQL
Oracle instant client with OraOLE DB provider?
Case Sensitivity when querying SQL Server 2005 from .NET using OleDB
Good .NET ORM Framework that supports OleDb and Stored Procedures?
What is the OleDb equivalent for INFORMATION_SCHEMA
When reading a CSV file using a DataReader and the OLEDB Jet data provider, how can I control column data types?
How to check if an OLEDB driver is installed on the system?
what is the difference between OLE DB and ODBC data sources?
Writing into excel file with OLEDB
Managed OleDB provider written in C#
Is there anything wrong with this query?
Performance issues regarding Access 2003 and the OLE Object data type
What is this 'Multiple-step OLE DB' error?
VFP .NET OLEdb provider does not work in Win 64-Bits. Help