Hello,
My VB application read and writes data from and to a MS Excel workbook,
using the Microsoft.Jet.OLEDB.4.0 provider. I have installed the MS ActiveX
Data Object 2.0 Library on my computer and everything works fine.
I have created a setup using the Package & Deployment Wizard. I thought,
let's make the setup a bit more up-to-date, so I included the mdac_type.exe
version 2.7.
However, after installing the setup on a different computer (that never had
the MS ActiveX Data Object 2.0 Library installed), the application cannot
open the MS Excel workbookbecause the provider cannot be found.
After a quick investigation on Microsoft's site, if saw that the Microsoft
Jet OLE DB Provider isn't provided in the mdac_type.exe version 2.7, so it's
clear why the application can't read the MS Excel workbook.
So, in the future, do I have to add the 'old' mdac_type.exe version 2.0 to
my setup instead of the most up-to-date version of mdac_type.exe? Of do I
have to change the way of opening Excel workbooks, instead of using the
Microsoft.Jet.OLEDB.4.0 provider?
Who can help me out?
5  18451 
"Geert-Pieter Hof" <g.*******@wbmt.tudelft.nl.blablabla> wrote in message
news:bi**********@azure.qinip.net... Hello,
My VB application read and writes data from and to a MS Excel workbook,
using the Microsoft.Jet.OLEDB.4.0 provider. I have installed the MS
ActiveX Data Object 2.0 Library on my computer and everything works fine.
I have created a setup using the Package & Deployment Wizard. I thought,
let's make the setup a bit more up-to-date, so I included the
mdac_type.exe version 2.7.
I am assuing this problem only exist on platform other than Windows 2000.
For 95/98/NT in addition to MDAC you also need to include the install of the
MSJet Engine. The latest I think is at http://www.microsoft.com/downloads/d...632-57f1-4959-
897f-263877c6a11a&displaylang=en
(all one line of course) for Jet40SP7_9xNT.exe
Beste wensen van New York.
> I am assuing this problem only exist on platform other than Windows 2000.
For 95/98/NT in addition to MDAC you also need to include the install of
the MSJet Engine. The latest I think is at
http://www.microsoft.com/downloads/d...632-57f1-4959- 897f-263877c6a11a&displaylang=en
(all one line of course) for Jet40SP7_9xNT.exe
Do you happen to know if I have to install the MSJet Engine in addition to
MDAC of can I install the MSJet Engine instead of the MDAC?
Thanks,
Geert-Pieter
"Geert-Pieter Hof" <g.*******@wbmt.tudelft.nl.blablabla> wrote in message
news:bi**********@azure.qinip.net... Do you happen to know if I have to install the MSJet Engine in addition to
MDAC of can I install the MSJet Engine instead of the MDAC?
You need BOTH if you're on 95/98/NT environment.
Hi there, I had a similar problem but solved it by using madc 2.5, you may
want to try that?
Chris
"Geert-Pieter Hof" <g.*******@wbmt.tudelft.nl.blablabla> wrote in message
news:bi**********@azure.qinip.net... Hello,
My VB application read and writes data from and to a MS Excel workbook,
using the Microsoft.Jet.OLEDB.4.0 provider. I have installed the MS
ActiveX Data Object 2.0 Library on my computer and everything works fine.
I have created a setup using the Package & Deployment Wizard. I thought,
let's make the setup a bit more up-to-date, so I included the
mdac_type.exe version 2.7.
However, after installing the setup on a different computer (that never
had the MS ActiveX Data Object 2.0 Library installed), the application cannot
open the MS Excel workbookbecause the provider cannot be found.
After a quick investigation on Microsoft's site, if saw that the Microsoft
Jet OLE DB Provider isn't provided in the mdac_type.exe version 2.7, so
it's clear why the application can't read the MS Excel workbook.
So, in the future, do I have to add the 'old' mdac_type.exe version 2.0 to
my setup instead of the most up-to-date version of mdac_type.exe? Of do I
have to change the way of opening Excel workbooks, instead of using the
Microsoft.Jet.OLEDB.4.0 provider?
Who can help me out?
G'day All,
Hey that's a question I can answer. :-)
Yes, don't use MDAC 2.7 Chris is right use 2.5 (version number 4.72.3110.0)
The Microsoft Data Access Components 2.5 RTM is the same version of the MDAC
components installed by Windows 2000.
Available here http://www.microsoft.com/downloads/d...178-94c9-4e7d-
b0b6-a8a94c4eb912&DisplayLang=en
Details of all the MDAC versions is here http://msdn.microsoft.com/library/de...ist/dataaccess
..asp
You'll find more details on the Inno Setup Web Site http://www.jrsoftware.org/isinfo.php
The Inno setup newsgroup is also an excellent source of info, the man with
the best VB answers is Michael Reitz.
hth
build
"Chris & Kathie" <mi*****@ihug.co.nz> wrote in message
news:bj**********@lust.ihug.co.nz... Hi there, I had a similar problem but solved it by using madc 2.5, you may
want to try that?
Chris
"Geert-Pieter Hof" <g.*******@wbmt.tudelft.nl.blablabla> wrote in message
news:bi**********@azure.qinip.net... Hello,
My VB application read and writes data from and to a MS Excel workbook,
using the Microsoft.Jet.OLEDB.4.0 provider. I have installed the MS
ActiveX Data Object 2.0 Library on my computer and everything works fine.
I have created a setup using the Package & Deployment Wizard. I thought,
let's make the setup a bit more up-to-date, so I included the
mdac_type.exe version 2.7.
However, after installing the setup on a different computer (that never
had the MS ActiveX Data Object 2.0 Library installed), the application
cannot open the MS Excel workbookbecause the provider cannot be found.
After a quick investigation on Microsoft's site, if saw that the
Microsoft Jet OLE DB Provider isn't provided in the mdac_type.exe version 2.7, so
it's clear why the application can't read the MS Excel workbook.
So, in the future, do I have to add the 'old' mdac_type.exe version 2.0
to my setup instead of the most up-to-date version of mdac_type.exe? Of do
I have to change the way of opening Excel workbooks, instead of using the
Microsoft.Jet.OLEDB.4.0 provider?
Who can help me out?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: M P |
last post by:
What does this mean? I am accessing an ASP page that queries Access Database
thru fileDSN. I'm using IIS 5.0 Win2K SP4
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
General...
|
by: TF |
last post by:
Hi,
I have to access data from a comma delimited file in .net windows
application (VB.net or C#). I am using Microsoft.Jet.OLEDB.4.0
provider for this purpose. Now the problem is when i extract...
|
by: Gianluca_Venezia |
last post by:
Hi all,
I'm approaching at .Net for make up a site but I have a problem with
web.config. I'm trying to use an *.mdb file as db, and I'd think to
use this:
<add key="ConnectionString"...
|
by: NS |
last post by:
Hi,
I am trying to execute a prepare statement using oledb provider for
DB2. The command.Prepare() statement is giving me an exception
" No error information available:...
|
by: Reza Nabi |
last post by:
Dear All:
I have been developing ASP.NET application on MS Access database using ODBC.
When I was trying to save more than 255 chars in a Memo field I got the
following error.
ERROR Invalid...
|
by: zacks |
last post by:
Can this driver return to me the names of the active WorkSheets in an
XLS file?
|
by: somersbar |
last post by:
hello all,
im trying to connect to a microsoft access database from an ASP.NET web
form.
i keep getting the following error though:
ERROR Could not use
'(unknown)'; file already in use....
|
by: flickimp |
last post by:
Trying to open a SQL Server query but am getting this message:
Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.4.0' has been denied. You must access this provider through a linked server.
...
|
by: ErikJL |
last post by:
I have a simple webservice that performs a SELECT query against a database, and then an INSERT statement on the same database/table. The problem arises at the time when we create the second OleDB...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
