<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<blockquote cite="mid:4A6A4B5D.5030502@earthlink.net" type="cite">
<pre wrap="">Barry Bird wrote:
</pre>
<blockquote type="cite">
<pre wrap="">[Bottom post please, that's how we do things here.]
James Mckenzie wrote:
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">On Thu, Jul 23, 2009 at 11:04 PM, Mike
Kaplinskiy<a class="moz-txt-link-rfc2396E" href="mailto:mike.kaplinskiy@gmail.com"><mike.kaplinskiy@gmail.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">On Thu, Jul 23, 2009 at 10:32 PM, Juan Lang<a class="moz-txt-link-rfc2396E" href="mailto:juan.lang@gmail.com"><juan.lang@gmail.com></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Hey Barry,
this was a handy writeup. Â Perhaps you could add it to the wiki?
Here's a page that you might add it to:
<a class="moz-txt-link-freetext" href="http://wiki.winehq.org/NativeOdbc">http://wiki.winehq.org/NativeOdbc</a>
The user guide should probably point to the wiki, but that's a
different topic. Â Thanks!
--Juan
</pre>
</blockquote>
<pre wrap="">Dan/Austin might also add this to winetricks. Jet is already in there
so this would be a nice addition.
</pre>
</blockquote>
</blockquote>
<pre wrap="">Austin:
Can his list be bounced against the Jet40 and MDAC28 installations?
James McKenzie
</pre>
<blockquote type="cite">
<pre wrap="">I don't see how. The dlls were copied from windows, not part of a
redistributable downloadable package.
--
-Austin
</pre>
</blockquote>
<pre wrap="">
</pre>
</blockquote>
</blockquote>
<pre wrap=""><!---->
You'll find my list is a subset of Jet40, plus odbc files. I tried to
get Jet 4.0 SP8 from
<a class="moz-txt-link-freetext" href="http://support.microsoft.com/kb/239114">http://support.microsoft.com/kb/239114</a>
but failed. I don't think there is a Jet 4.0 SP8 as such any longer.
It's all in the form of hotfixes. I have Windows XP SP3 to which I have
some time ago updated with Jet 4.0 SP8. I downloaded
WindowsXP-KB829558-x86-ENU.exe as that article says, set wine to Windows
XP and executed
wine WindowsXP-KB829558-x86-ENU.exe
It refused to run, saying my version of XP was already ahead of where it
was trying to update to.
Later down the Microsoft page it says:
"...the ODBC Desktop Driver Pack drivers. These drivers are included
with the Windows 2000 operating system, the Windows XP operating system,
and the Windows Server 2003 operating system."
This article
<a class="moz-txt-link-freetext" href="http://support.microsoft.com/kb/271908/">http://support.microsoft.com/kb/271908/</a>
says
"MDAC version 2.6 and later do not contain Jet or Desktop ODBC drivers"
so it seems the latest MDAC's no use, so I use my list of files from my
WinXP installation. I may have missed something, but that's the way it
seems it has to be. Do you really want to go back to MDAC 2.5?
It may be that to fully support all features of JET databases and ODBC
there are some other DLLs (look at
<a class="moz-txt-link-freetext" href="http://msdn.microsoft.com/en-us/library/ms810823.aspx">http://msdn.microsoft.com/en-us/library/ms810823.aspx</a>) which should also
be added. What I gave is a minimum set to get my programs to work.
Barry:
We talk about winetricks here because Dan Kegel and Austin English put a
lot of time into it to make it work.
For Jet/Access database use, I retrieve the winetricks script, save it
as a file, make it executable (that may be because I'm using a Mac).
Since I use a Mac I have to open a terminal session and type in:
./winetricks jet40 mdac28
This retrieves the Jet Engine version 4.0 and MDAC 2.8.
I would have to check if MDAC includes the ODBC frontend, but it
probably does not. I don't think that it would be legal to copy the
ODBC front end from Windows, but then again a replacement program might
be available.
I am going to get you list and then use a clean wineprefix to see how
much of what you installed is installed with these two updates.
James McKenzie
James,
</pre>
</blockquote>
<small>Contrary to what the article (271908
) I quoted earlier says the latest MDAC does contain the ODBC <br>
files if you look in the manifest. The Jet SP contains the others apart
from these:<br>
clbcatq.dll<br>
comres.dll<br>
So, I've done as you suggest and used winetricks on a clean .wine to
download & install Jet 4.0 and MDAC 2.8.<br>
However I note that the Jet package is for old windows, not XP or 2k. <br>
This does everything except set up the registry for the Jet drivers in <br>
- HKLM\Software\ODBC<br>
So I imported the reg file for that. <br>
This works for my programs. The missing dlls don't seem to matter. It's
also a more comprehensive set of dlls. <br>
For example I didn't have the odbc drivers for cursors, which I don't
use.<br>
In a separate mail I'll lay out my revised how-to!<br>
<br>
Thanks very much,<br>
<br>
Barry</small><br>
<br>
</body>
</html>