SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast Hercules's Avatar
    Join Date
    Jul 2001
    Location
    Beirut - Lebanon
    Posts
    48
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    How to connect to MySql using ASP ?

    I have the latest MySQL server running on a windows 2000 server machine, I have IIS web server, I installed MyODBC, I still need to figure out the Asp code to connect to my DB.
    Thanks...
    Hercules...

  2. #2
    Just Blow It bronze trophy
    DaveMaxwell's Avatar
    Join Date
    Nov 1999
    Location
    Mechanicsburg, PA
    Posts
    7,294
    Mentioned
    123 Post(s)
    Tagged
    1 Thread(s)
    Try something like this:

    strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL
    set my_Conn = Server.CreateObject("ADODB.Connection")
    my_Conn.Errors.Clear
    my_Conn.Open strConnString
    Dave Maxwell - Manage Your Site Team Leader
    My favorite YouTube Video! | Star Wars, Dr Suess Style
    Learn how to be ready for The Forums' Move to Discourse

  3. #3
    SitePoint Enthusiast Hercules's Avatar
    Join Date
    Jul 2001
    Location
    Beirut - Lebanon
    Posts
    48
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    A tiny prob



    I have tried that, but it seems that my html isn't executing the script, so I can't tell if its working or not...
    Thanks


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
  •