[BNM] odbc on xp & mysql

[Karim Ahmed]

It's very straight-forward but you need to be careful to set up a MySQL user
that ONLY has the permissions required for the task in hand (for security).
e.g. specify the host name of the client as the only allowed host and
read-only access if that's all you need.

Get the ODBC driver from mysql web site and it's very straightforward to set
up.

K
On 7/6/07, andrew holway <andrew at moonet.co.uk> wrote:
>
> Well, The first step is installing the mysql odbc driver
> http://dev.mysql.com/downloads/connector/odbc/3.51.html
>
> :-)
>
> On 06/07/07, Tom Coady <tom.coady at gmail.com> wrote:
> > On 7/5/07, andrew holway <andrew at moonet.co.uk> wrote:
> > >
> > > Has anyone set up odbc to remote mysql before? Can you describe the
> > > steps?. We have the mysql odbc driver installed on the client XP
> > > machine, mysql is running on linux.
> >
> >
> > No, but I'd like to. I've inherited such a base that I'd love to backup
> &
> > access this way so if you succeed I'd be very interested to know how it
> > goes.
> > --
> >
> > BNM Subscribe/Unsubscribe:
> > http://www.brightonnewmedia.org/options/bnmlist
> >
> > BNM info/archives:
> > http://www.brightonnewmedia.org/
> >
> > BNM powered by Wessex Networks:
> > http://www.wessexnetworks.com
> >
> --
>
> BNM Subscribe/Unsubscribe:
> http://www.brightonnewmedia.org/options/bnmlist
>
> BNM info/archives:
> http://www.brightonnewmedia.org/
>
> BNM powered by Wessex Networks:
> http://www.wessexnetworks.com
>



-- 
Karim Ahmed
Sweet Code Ltd
http://www.sweetcode.co.uk
Phone: +44 1273 383584
Skype: karim.ahmed
SIP:     3808296

Member of the Federation of Small Businesses

IS YOUR EMAIL PRIVATE? Ensure you have at least basic security:
o For web mail such as GMail and Hotmail, the address bar must say https://
instead of http://
o For desktop clients like Outlook, check that POP and SMTP servers require
an encrypted connection in the email account settings.
If you can't do the above, consider switching your mail provider.