Remote connection to MySQL Server using MS Access 2002

2002-03-22 Thread Charles McGrotty

Hi,

Can someone tell me how to configure the MySQL ODBC (v3.51) Driver so I
can connect to a remote MySQL database.

I have tried putting an IP address in that I found by lookup of the
domain name, and I entered the database name and password, but I get an
error saying connection from ~db_name~@~whatever_ISP~ was refused, what
am I doing wrong.

I do not know the actual servr name that the MySQL database lives on, so
what options do I have, this must be possible so how do I do it.

Alternativly, if anyone knows of any alternative tools (not phpMyAdmin
(ie: not browser based)) that will allow me to look at, and work with
the data, even if only in a read only enviroment at this time, though
full access is desired. I would mych appreciate it.

Thnx


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




Re: Remote connection to MySQL Server using MS Access 2002

2002-03-22 Thread Ken Anderson

There are other windows front ends to mysql, but this one is the best:
http://ems-hitech.com/mymanager/
Are you sure the server allows remote connections?
Ken


Charles McGrotty wrote:
 
 Hi,
 
 Can someone tell me how to configure the MySQL ODBC (v3.51) Driver so I
 can connect to a remote MySQL database.
 
 I have tried putting an IP address in that I found by lookup of the
 domain name, and I entered the database name and password, but I get an
 error saying connection from ~db_name~@~whatever_ISP~ was refused, what
 am I doing wrong.
 
 I do not know the actual servr name that the MySQL database lives on, so
 what options do I have, this must be possible so how do I do it.
 
 Alternativly, if anyone knows of any alternative tools (not phpMyAdmin
 (ie: not browser based)) that will allow me to look at, and work with
 the data, even if only in a read only enviroment at this time, though
 full access is desired. I would mych appreciate it.
 
 Thnx
 
 -
 Before posting, please check:
http://www.mysql.com/manual.php   (the manual)
http://lists.mysql.com/   (the list archive)
 
 To request this thread, e-mail [EMAIL PROTECTED]
 To unsubscribe, e-mail [EMAIL PROTECTED]
 Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php