Paul,
With the XP firewall, it's not a case of turning it off, it's a case of
changing a few of the settings, removing the block that the firewall
puts on certain ports, I can't remember the MS knowledge base articles,
but I know when I had some similar problems, actually to do with SQL
Server and Access, and was looking I came across several articles, I
think I used search phrases like "ODBC not working", How useful the KB
articles will be I don't know as we ended up turning off the firewall
and the owners of the system got a third party firewall that was a lot
more user friendly and didn't break things.
cheers
mike
Paul Weatherdon wrote:
>Mike / Christian
>
>Thanks for the replies ... but ...
>
>I have tried to use both IP addresses shown in the Server and Client
>Information boxes in MySQL Administrator | Server Information form, to
>no avail.
>
>Both PCs are using XP Professional Service Pack 2.
>
>XP Firewall is running on both machines - I'm loathe to turn it off as
>at least one of my family is on the Internet at any one time (or so it
>seems!).
>
>Couldn't manage Access to Access - it wouldn't allow me to use the ODBC
>DSN that I had setup when trying to link. However I don't think this
>would help as I am only connecting to another Access database via a
>shared drive on the other PC. The connection to the MySQL database needs
>to "know" that a MySQL Instance is running across the network and not
>specifically on a shared drive (?)
>
>On another note - is there a planned release date for MySQL 5.0 Alpha? I
>have tried to use the Beta but was unable to get it installed properly.
>
>Finally, I have worked my way through the Manual's Tutorial and am
>looking for a more detailed reference book. Is there any that you would
>(unofficially) recommend? I have the SAMS 21 Days but it's out of date
>and has no sections on your latest GUI tools.
>
>Regards
>Paul Weatherdon
>
>
>
>
>
>
>----- Original Message -----
>From: Mike <mailto:mikeh [at] kiwiplan.co.nz> Harknett
>To: Christian Surya <mailto:csuryas [at] gmail.com>
>Cc: Paul Weatherdon <mailto:p.weatherdon [at] virgin.net> ;
>myodbc [at] lists.mysql.com <mailto:myodbc [at] lists.mysql.com>
>Sent: Thursday, February 24, 2005 3:00 AM
>Subject: Re: Can't access "other" PC
>
>
>A couple of questions that may or may not help....
>
>Are the XP boxes patched with service packs?
>Is the XP firewall running?
>can you connect via odbc to anything else, Access to Access using a
>DSN?
>Check the MS knowledge base ...could be that the ports that ODBC needs
>are blocked
>
>cheers
>
>mike
>
>
>
>Christian Surya wrote:
>
>Hi Paul,
>
>Try the PC's IP address where your MySQL is installed. For example
>
>your PC Database ip address is 192.168.0.1 then when you configure
>
>ODBC Connection at the Server field you write 192.168.0.1
>
>Hope this can help you
>
>
>
>Best Regards,
>
>Christian
>
>
>
>On Wed, 23 Feb 2005 15:50:08 -0000, Paul Weatherdon
>
> <mailto:p.weatherdon [at] virgin.net> <p.weatherdon [at] virgin.net> wrote:
>
>
>
>Hi
>
>
>
>I have sucessfully setup a MySQL 4.1 database on one XP PC and can
>
>
>
>connect to it, via ODBC, from an Access Database.
>
>
>
>My problem is I can't setup an ODBC connection from my "other" PC -
>
>
>
>they are connected via a UBS cable using the Windows XP LAN or
>
>High-Speed Internet style connection.
>
>
>
>When I test the connection I get "Can't connect to MySQL server on
>
>
>
>'localhost'. All the ODBC fields are filled out with the same values as
>
>the PC on which the ODBC connection does work (i.e. the MySQL PC). I
>
>have tried entering the PC's Name, its IP adress etc etc to no avail.
>
>
>
>What should I be entering as the Server name?
>
>
>
>Regards
>
>Paul Weatherdon
>
>
>
>
>
>
>
>
>
>.
>
>
>
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
