[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    Re: ODBC per Mysql da Windows
From:       Daniel Kasak <dkasak () nusconsulting ! com ! au>
Date:       2007-01-24 23:48:11
Message-ID: 45B7F03B.7060508 () nusconsulting ! com ! au
[Download RAW message or body]


fmoscatelli@interfree.it wrote:

> I wont to connect:
>
> Client:  Windows -- Microsoft Acces
> Server: Linus  - DB: Mysql
>
> Is possible?
>
> Tank you.
>   

Yes, but it's *very* tricky at the moment.

There used to be documentation on special things you have to do for 
Microsoft Access, but it's hard to find, and seems to be completely gone 
now :(

You should use:

- MySQL-4.0 or 4.1 ( 5.0 works but newer features are unsupported, so it 
works like 4.1 )
- MyODBC-3.51.12-2 *only* ( don't use 3.51.12 or 3.51.13 if you find 
them, and older versions such as 3.51.11 don't work with MySQL-4.1 and 
higher )
- MSDAC-2.7 or later ( preferably 2.8 )
- latest MS Jet from Microsoft
- work-arounds from: http://bugs.mysql.com/bug.php?id=9932 ( use the 
'msaccess.exe.local' method )
- all available service packs for MS Access
- all tables should have a TimeStamp(14) column
- no tables should have BigInt fields

Both the 3.51.x drivers and the 5.x drivers appear to be in limbo at the 
moment ( for example bug 9932 has been open for 2 years now with no 
official solution ). I wouldn't spend too much time developing against 
3.51.x, and I haven't been able to get any action at all out of 5.x, so 
at the moment I would be cautious. Other methods of connecting to MySQL, 
for example Perl's DBI drivers, are under active development, so I've 
headed off down this better supported path. If you're interested in 
using Perl instead of MS Access' Visual Basic, then check out: 
http://entropy.homelinux.org/axis/

-- 
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: dkasak@nusconsulting.com.au
website: http://www.nusconsulting.com.au


[prev in list] [next in list] [prev in thread] [next in thread]