Koozali.org: home of the SME Server

MySQL & ODBC

Hazen Valliant-Saunders

MySQL & ODBC
« on: March 22, 2001, 06:47:22 PM »
OK,
      Could anyone direct me to good documentation on how to connect to MySQL via ODBC (Excell or Access clients) with E-smith?  

      I get an authentication error, however I'm wondering exactly how E-Smith is configured with regards to internal network connections to MySQL and weather or not I could do such things.
   
      I've done them before but that was modifying MySQL, Well If any of you have a minute I'd apreciate it.


Again Thanks as Always.
Hazen

Charlie Brady

Re: MySQL & ODBC
« Reply #1 on: March 23, 2001, 04:11:45 AM »
Hazen Valliant-Saunders wrote:

>       Could anyone direct me to good documentation on how to
> connect to MySQL via ODBC (Excell or Access clients) with
> E-smith?

Your problem has nothing whatsoever to do with e-smith, you just need the MySQL documentation. You need to configure the access control lists in MySQL to allow connections from the LAN, and you need to set up the tables that you need in MySQL.

Regards

Charlie