Thread: MySql

    #1
  1. echo $usertitle['computer'];
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jan 2003
    Location
    UK
    Posts
    6,705
    Rep Power
    420

    MySql


    How would I connect and query a MySql database
    (and also do UPDATE and INSERT) from a VB 6.0 program, also how do I get it to check to see if I'm connected (to the internet) before it connects to the database?
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2003
    Posts
    23
    Rep Power
    0
    Try,
    http://www.mysql.com/downloads/api-myodbc-3.51.html

    http://www.mysql.com/products/myodbc...MyODBC_With_VB

    I have never done it so please post your results.

    As an additonal note, if you get the activestate perl dev kit ($200, free 1m eval) you can write a dll that VB can use. I have written a perl dll and accessed it with VB. It took about 8-12 hrs (I am not particularly experienced with VB in genral, dll's in particular) for me to get the hang of modifiying perl to run in VB, get the Package&Delployment Wizard to work, ect. For $200 this might be the path of least resistance.
    Last edited by GeorgeF; March 20th, 2003 at 04:45 PM.
  4. #3
  5. /(bb|[^b]{2})/

    Join Date
    Nov 2001
    Location
    Somewhere in the great unknown
    Posts
    5,163
    Rep Power
    792
    you can also talk to tewl about this. he just created a vb app that interacts with mysql.

    <shakes finger at you sternly > should know better about your title.
  6. #4
  7. echo $usertitle['computer'];
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jan 2003
    Location
    UK
    Posts
    6,705
    Rep Power
    420
    sorry
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2001
    Location
    USA
    Posts
    313
    Rep Power
    18
    These are not the best examples but here are a few I did in VB6

    mySQL Examples

IMN logo majestic logo threadwatch logo seochat tools logo