 | | | ODBC per Mysql da Windows | ODBC per Mysql da Windows 2007-01-24 - By Daniel Kasak
Back
fmoscatelli@(protected) 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 (See http://SQL-4.ora-code.com).0 or 4.1 ( 5.0 works but newer features are unsupported, so it
works like 4.1 )
- MyODBC-3 (See http://DBC-3.ora-code.com).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 (See http://SQL-4.ora-code.com).1 and
higher )
- MSDAC-2 (See http://DAC-2.ora-code.com).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@(protected)
website: http://www.nusconsulting.com.au
|
|
|