SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Wizard Dylan B's Avatar
    Join Date
    Jul 2004
    Location
    NYC
    Posts
    1,150
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Can you connect to MySQL through ODBC?

    Soryr if it's an easy question, but I've neevr done it before.

  2. #2
    SitePoint Wizard HarryR's Avatar
    Join Date
    Dec 2004
    Location
    London, UK
    Posts
    1,376
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yes you can connect to MySQL through ODBC, but you need to download the MySQL ODBC drivers from http://dev.mysql.com/downloads/connector/odbc/3.51.html .

    Then all you do is setup a system/user DSN, select the MySQL driver and configure it then use it as you would with any other ODBC connection.

    Regards,
    Harry

  3. #3
    SitePoint Wizard Dylan B's Avatar
    Join Date
    Jul 2004
    Location
    NYC
    Posts
    1,150
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Would a shared host generally have the MySQL drivers installed?

  4. #4
    SitePoint Wizard HarryR's Avatar
    Join Date
    Dec 2004
    Location
    London, UK
    Posts
    1,376
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you're running your website off a Windows server and they provide a MySQL database for you - then yes they will (otherwise the MySQL database would be useless to ASP etc.).

    If you're not running your website off a Windows server then it's really hit-and-miss, as the majority of Linux/Unix web hosting providers I've seen don't give you access to iODBC or UnixODBC.

    The bottom line is - ask your hosting provider if you're unsure.

    Regards,
    Harry


Bookmarks

Posting Permissions

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