ODBC Databases: Jet/Access success

[Barry Bird]

Good Afternoon.

In section 3.3.6.2 of your User Guide you ask readers to report 
successes with databases other than MS SQL.  Well here's one (I know 
Access 2000 can work with Wine, but this doesn't require Access):

How to set up Wine to enable Windows programs that read and write to Jet 
(Access)
databases using ODBC.  I write such programs in C and use the API defined in

ODBC API Reference
http://msdn.microsoft.com/en-us/library/ms714562%28VS.85%29.aspx

They work fine on Windows and only require Mingw to be installed to 
compile and link them,
both for console programs and those using Windows SDK.
You then can write interactive programs in C which use a full-featured 
SQL database which
comes bundled with Windows. No need to purchase Access.

With the set-up below they will also run on Linux (Kubuntu 9.04) and 
Wine 1.1.26.

You need to update the registry to install the Access drivers. 
Under Windows, export from the Registry to *.reg files the registry entries
- HKLM\Software\ODBC
- HKLM\Software\Microsoft\Jet
all subsidiary keys and values come with them.

You can carefully edit these files to remove drivers and DSNs you don't 
need.

Import these files using the registry editor in wine:

wine regedit.exe.

You need to bring across from Windows to Windows\System32 under wine:

clbcatq.dll
comres.dll
expsrv.dll
msjet40.dll
mswstr10.dll
msjter40.dll
msjint40.dll
msjtes40.dll
msrd3x40.dll
odbc32.dll
odbccp32.dll
odbcji32.dll
odbcjt32.dll
odbcad32.exe
odbcint.dll 
odbctrac.dll
vbajet32.dll

Register this server in wine:
wine regsvr32.exe msjtes40.dll

No need to install MDAC.

To use Windows ODBC drivers, you have to override Wine's odbccp32.dll 
and odbc32.dll with the native
versions because the Wine versions are currently wired directly to 
Linux's unixodbc.

This can be done by setting up the ODBC Data Source Administrator 
odbcad32.exe using winecfg:
- Add the program to the Applications tab
- then in the libraries tab, pick from 'New override for library' drop-down
odbc32.dll and odbccp32.dll add them and edit them to be Native for Windows.

Then if you do

wine odbcad32.exe

this brings up the ODBC Data Source Administrator window as in the 
Windows Control Panel

If needed, set up (System) DSNs using this program.

Bring across the programs and *.mdb database files from Windows.

Using winecfg, you need to set up each program you want to run with 
overrides for odbc32.dll and odbccp32.dll
(Applications and Libraries tabs) as above.

The programs should then run as they did in Windows but perhaps a bit 
slower with:

wine Odbc-prog.exe

This has been tested twice on a clean .wine install.   I cannot vouch 
for support of all API and SQL facilities however.

I hope someone finds this useful.

Barry Bird

[Juan Lang]

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:
http://wiki.winehq.org/NativeOdbc

The user guide should probably point to the wiki, but that's a
different topic.  Thanks!
--Juan

[Mike Kaplinskiy]

On Thu, Jul 23, 2009 at 10:32 PM, Juan Lang<juan.lang(a)gmail.com> wrote:
> 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:
> http://wiki.winehq.org/NativeOdbc
>
> The user guide should probably point to the wiki, but that's a
> different topic.  Thanks!
> --Juan

Dan/Austin might also add this to winetricks. Jet is already in there
so this would be a nice addition.

Mike.

[Austin English]

On Thu, Jul 23, 2009 at 11:04 PM, Mike
Kaplinskiy<mike.kaplinskiy(a)gmail.com> wrote:
> On Thu, Jul 23, 2009 at 10:32 PM, Juan Lang<juan.lang(a)gmail.com> wrote:
> > 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:
> > http://wiki.winehq.org/NativeOdbc
> >
> > The user guide should probably point to the wiki, but that's a
> > different topic.  Thanks!
> > --Juan
>
> Dan/Austin might also add this to winetricks. Jet is already in there
> so this would be a nice addition.

I don't see how. The dlls were copied from windows, not part of a
redistributable downloadable package.

-- 
-Austin

[liz lock]

I just wanted to thank Barry Bird so, so much for this very old post. I
have struggled with this issue getting some massively complicated Word
macros that interact with Access databases to work under Wine (and
Crossover Linux) and his solution just ... worked. Brilliant!

(Mrs) Elizabeth Lock
Oxford