[NTLUG:Discuss] ODBC to MySQL

[Jack Snodgrass]

On Wed, 2002-07-31 at 15:42, Bobby Wrenn wrote:
> On Wednesday 31 July 2002 03:19 pm, you wrote:
> >
> >   Once you get the ODBC driver installed, you have to tell access to use
> > that driver.  I have not done that part before.
> 
> Got the driver installed and Access sees it. Either I don't know where the 
> datasource lives on the Linux box or I don't know how to tell Access to get 
> to it.


you go into the odbc access control pannel 
and setup a mysql DSN. You have to give it
the name/address of the linux box where 
mysql is located. The default port 3306 should
work. You will want to test the access from 
this odbc setup app. 

Once that works, then go to access link to 
a table, select odbc as the link type and 
select your mysql odbc dsn that you created. 

Then when you should be able to access your 
mysql database from access. 

You can also use php on the web server to 
link to mysql. this may help out in your 
situation too. 

Lastly... check www.freshmeat.net. I think 
that there was something about MS Access and
MySQL but it could have been for something
else. 

jack