Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Connecting to MySQL from ODBC

  • 27-09-2009 08:12PM
    #1
    Registered Users, Registered Users 2 Posts: 1,512 ✭✭✭


    I've been connecting to mySQL server on my webhosting package to insert data into crystal reports. Used it pretty regularly, but in the last couple of months haven't touched it.

    Then today I wanted to fire off an up to date report but keep getting an access denied error. I went into the mySQL Connector/ODBC and checked it. The data hasn't changed however in the diagnostics of that tool I keep getting the following error when testing the connection:
    [MySQL][ODBC 3.51 Driver]Access denied for user 'myuser'@'xxx-xxx-xxx.ntlworld.ie' (using password: YES)
    

    Anyone know why its using the address "xxx-xxx-xxx.ntlworld.ie" instead of the webhosting address? (the x's are numbers)


Comments

  • Registered Users, Registered Users 2 Posts: 1,512 ✭✭✭stevire


    Got it sorted... My IP address changed since I last used it so I had to add my new IP to the mySQL remote hosts access list!


Advertisement
Advertisement