[NTLUG:Discuss] ODBC to MySQL

[Jack Snodgrass]

On Wed, 2002-07-31 at 17:31, Bobby Wrenn wrote:
> On Wednesday 31 July 2002 04:54 pm, you wrote:
> > You have to define the DSN.  I just do it from the control panel ODBC
> > Datasources.  You can create a system dsn for use on that machine or a file
> > based one that you can move along with the driver to multiple machines. 
> > Basically just go in there click the add button and fill in the appropriate
> > blanks and you should be able to connect to it from access just like any
> > other remote db.
> >
> When creating a data source I have to tell the odbc driver where the data is 
> located. Where is the data located on the Linux box?


no you don't. the data is located on the linux box. You 
just need to know the IP Address. The ODBC driver on 
the windows box will connect to port 3306 on the linux
box and talk to the SQL Server via the TCP/IP port. 

jack