[oclug] regarding MYSQL ODBC connectivity

[Brenda J. Butler]

On Wed, Apr 07, 2004 at 12:25:29PM -0700, sharma rohit wrote:
> Dear friends
> I am confused
> I have a mysql server on one computer
> 1> Now I need to test if the ODBC is in place
> 2> I wanted to access the database on this server from
> a windows machine, hence I installed the
> MYSQLODBCdriver 3.51 and tried to access this server,
> but it did not work
> 
> Has anybody connected to a MySql server on Linux from
> a windows client? How did you do it?

This is pretty general.  I've never done this particular
task but the first things that come to mind are:

Can you access the mysql database from the machine
where mysql is installed?  If not, is it running?
Are there any log file entries?  Can you run it in
debug mode, to see what's happening to connections?

Can you access it from a second linux machine?  If not,
are the queries making it from the querying machine to
the mysql machine?  (a packet sniffer and/or firewall
logs can help here)

Are any answers making it back from the mysql machine
to the querying machine?

Last step:  try to get the MS machine to talk to
the the mysql machine - use the packet sniffer
and/or firewall logging to detect the packet
exchange again.

Good luck, send us the intermediate results and maybe
we can guide your debug session a little more
precisely.

What kind of Linux box are you running (Suse, RedHat, Debian,
???)?  What version of MySQL?  How is it configured?  When you
reconfigure MySQL, do you make it re-read its configuration
(possibly by killing it off and restarting it)?

-- 
bjb at istop dot com
Open Source Weekend       http://www.osw.ca
5F82 9855 E247 1F8A 49CD  053E FB03 E77F 2A19 D707