[Sussex] MySQL ODBC

[Mark Harrison]

Doesn't need to be on the same box at all.

I was after the definition of the ODBC source you've created. Installing the
ODBC driver is just installing a driver... you then need to create a source
that uses that driver - as Gareth says, you do this in Control Panel /
Administrative Tools / Data Sources (ODBC)

M.

----- Original Message ----- 
From: "Matthew Macdonald-Wallace" <matthew at truthisfreedom.org.uk>
To: "LUG email list for the Sussex Counties" <sussex at mailman.lug.org.uk>
Sent: Monday, January 05, 2004 11:47 AM
Subject: Re: [Sussex] MySQL ODBC


> On Mon, 2004-01-05 at 11:41, Mark Harrison wrote:
> > What are you using as the data source?
>
> Remote (on the same network) MySQL Server, does this need to be on the
> local box?
>
> > I remember that ODBC was a pig to get working, so I ended up using the
OLEDB
> > connector instead... Not sure this was ever released for MySQL4 though
:-(
> >
> > M.
> >
> >
> >
> > ----- Original Message ----- 
> > From: "Matthew Macdonald-Wallace" <matthew at truthisfreedom.org.uk>
> > To: "LUG email list for the Sussex Counties" <sussex at mailman.lug.org.uk>
> > Sent: Monday, January 05, 2004 11:31 AM
> > Subject: [Sussex] MySQL ODBC
> >
> >
> > > All,
> > >
> > > I have installed MySQL ODBC onto a windows box on which I need to mail
> > > merge from a MySQL database.
> > >
> > > For some reason, it is not letting me connect, do I need to open any
> > > ports on the database-server, such as 3066 in order to connect?
> > >
> > > TIA
> > >
> > > Matt
> > > --
> > > +----------------------------------+
> > > |Matthew Macdonald-Wallace         |
> > > |The Truth Will Set you Free       |
> > > |http://www.truthisfreedom.org.uk/ |
> > > +----------------------------------+
> > >
> > > _______________________________________________
> > > Sussex mailing list
> > > Sussex at mailman.lug.org.uk
> > > http://mailman.lug.org.uk/mailman/listinfo/sussex
> > >
> > >
> >
> >
> > _______________________________________________
> > Sussex mailing list
> > Sussex at mailman.lug.org.uk
> > http://mailman.lug.org.uk/mailman/listinfo/sussex
> --
> +----------------------------------+
> |Matthew Macdonald-Wallace                  |
> |The Truth Will Set you Free              |
> |http://www.truthisfreedom.org.uk/  |
> +----------------------------------+
> "I am a person who recognizes the fallacy of humans." George W. Bush
> September 19, 2000 Comment made on TV talk show, Oprah.
>
> _______________________________________________
> Sussex mailing list
> Sussex at mailman.lug.org.uk
> http://mailman.lug.org.uk/mailman/listinfo/sussex
>
>