Page 3 of 3 FirstFirst 123
Results 21 to 23 of 23

Thread: Why wont this code work online.

  1. #21
    Join Date
    Sep 2004
    Posts
    281
    Rep Power
    0

    Default

    Ok. i give up trying to convince you to use ADODB. here is what i thinking.

    as you may or may not know mysql by default does not allow remote connectins to databases. by default it allows only localhost (127.0.0.1) or (any ip that is your local machine) to connect. when you create a user you must explicitly grant access to that user. So however you create your user check to ensure you have granted that user remote access.

    i normally do
    "grant all on DB to user@ip to username identified by password;"
    offcourse i has console acces to the server to do this

  2. #22
    Join Date
    May 2004
    Posts
    530
    Rep Power
    0

    Default

    thanks for your suggestions
    "...men are that they might have joy."
    Nephi

  3. #23
    Join Date
    Jan 2006
    Posts
    163
    Rep Power
    0

    Default

    hate to drag up an old thread but i think the reason this guy is getting this error on machine and not the other is because is either the names of his fields or the name of the table being queried is do not have the exact same names on both machince..........................
    you cry i' wipe away all of your tears
    you scream i fight away all of your fears

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •