There is an issue with sp2 and loopback, you can argue all you like, but many have had this problem, and many have resolved it. Mysql will not connect through udp, it will use tcp. If you supply a hostname in your connect function, it will use tcpip to connect over a port, if oyu dont supply a hostname, or i beleive put a '.' in its place, it will attempt to connect through a named pipe which doesnt use the network. In the time you spend writing this email, you could have attemped a suggested solution.
A little more acceptance to help would gain a lot more respect from me, not that you probably care about others respect. And for further note, for the sake of discussion, as you have mentioned to me on a certain forum. A firewall can absolutely interfere with a connection to mysql even if you are using localhost, if, and only if, that connection is being done over tcpip, which in unix, is rarely, but in windows, is not all that rare. Jason "Sam Hobbs" <[EMAIL PROTECTED]> wrote: > > "John Nichel" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > Jason Davidson wrote: > >> The webpage of coarse, is not local, regardless of where its hosted, so > >> a firewall will come into play when trying to connect. You dont have > >> disable it, i should have been specifc i suppose, you must > >> allow for the mysql port to be open. :) > >> Whats for others to confirm, try it yourself and see if it works. > >> > >> Jason > > > > You understanding of how this works is a bit off Jason. If you make a > > call to one of my web sites from your machine via a browser, the _only_ > > port I need to have open to the outside is 80 (or whatever port I have my > > web server running on), even if I make 1000 calls to a local db, but this > > has nothing to do with how the web server talks to MySQL. What is meant > > by local here, is that the MySQL db and web server are on the same > > machine. A firewall comes into play when your web browser requests a page > > from my web server, but does not come into play when that page has to > > connect to a local db before sending content to you. Your remote machine > > never talks to my local MySQL db. > > > Thank you. As I said previously, I did think that the firewall would not be > relevant. > > I don't know a lot about the TCP/IP stuff but I do know enough to write a > couple of simple programs. They are actually UDP programs. An example is my > "UDP Send and Receive Using CAsyncSocket" at: > > http://simplesamples.info/MFC/UDPSendReceive.php > > Using it, I can send and receive UDP packets within my system using > 127.0.0.1 without any problem from my firewall. > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
