Introduction

Some data providers require database connectivity components installed, For this purpose we install Microsoft Data Access Components (MDAC). Also a common requirement is the installation of the Microsoft Jet database engine. Below are some links for general information and various download locations. These components can be installed into Wine or CrossOver.

The easiest way of managing ODBC entries after installing database connectivity components is to run programs:

For CrossOver:

~/cxoffice/bin/wine odbcad32.exe
~/cxoffice/bin/wine cliconfg.exe

For wine:

wine odbcad32.exe
wine cliconfg.exe

Install Sequence

1) Install MSJet

2) Install MDAC

3) Install MDAC again to register drivers

Important Jet information

http://en.wikipedia.org/wiki/Microsoft_Jet_Database_Engine
Note: Microsoft Access and Visual Basic use or have used Jet as their underlying database engine.

http://support.microsoft.com/kb/829558
Note: To correctly register the ODBC drivers on your computer, you also have to install Microsoft Data Access Components (MDAC) 2.6 or later. MDAC does not include these driver files, but MDAC does include the core ODBC DLLs that are required to install the drivers and to use the drivers. You must install MDAC after Jet 4.0 Service Pack 8 so that the files are correctly registered.

Help from Codeweavers/Wine
(Some information may be outdated)

General info
http://www.codeweavers.com/support/docs/unsupported/

Configure ODBC info
http://www.codeweavers.com/support/docs/wine-user/config-odbc

Native ODBC
http://wiki.winehq.org/NativeOdbc

Download MDAC & Jet (Microsoft)

MDAC V2.8 (SP1) (Requires Validation)
http://www.microsoft.com/downloads/details.aspx?FamilyID=78cac895-efc2-4f8e-a9e0-3a1afbd5922e&DisplayLang=en

MDAC V2.7 (SP1)
http://www.microsoft.com/downloads/details.aspx?familyid=9ad000f2-cae7-493d-b0f3-ae36c570ade8&displaylang=en

MDAC V2.6
http://www.microsoft.com/downloads/details.aspx?FamilyID=6a7d785f-c2e0-471d-a33b-82ad1d514737&DisplayLang=en

JET V4 (SP8) Win9x
http://www.microsoft.com/downloads/details.aspx?FamilyID=4335216c-8cdd-4168-a030-46f815d3f5cd&DisplayLang=en

Download MDAC & Jet (Alternate Location)

http://www.amibroker.org/3rdparty/Amibroker_on_Linux/WindowsSystem/DataAccessComponents/