[NTLUG:Discuss] ODBC to MySQL

[Alton R. Pouncey, II]

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?
> 
> _______________________________________________
> http://www.ntlug.org/mailman/listinfo/discuss
> 

The databases created in MySQL are physically located on the disk in the
var directory beneath where mysql was installed.  

So, for example, if MySQL was installed in /usr/local/mysql, then the
databases created in MySQL would be in /usr/local/mysql/var.

-- 
Alton R. Pouncey, II
SCSA, SCNA, CCNA, CIW Professional
Director of Information Services
http://www.trainers-r-us.com