ODBC per Mysql da Windows

I wont to connect:

Client: Windows – Microsoft Acces
Server: Linus - DB: Mysql

Is possible?

Tank you.


Francesco Moscatelli

fmoscatelli@interfree.it

Tel. 335 373675
------------------------------------------------------------ ----------------
Vuoi rendere inaccessibili agli altri i tuoi documenti riservati?
Prova Ksek! Il potente software di cifratura di Interfree.

Scopri le sue funzionalita': http://ksek.interfree.it/

Lo Staff di Interfree
------------------------------------------------------------ ----------------


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org

Re: ODBC per Mysql da Windows

--------------040503050008030004020704
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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

--------------040503050008030004020704--