Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

vb6 and mySQL

rvijay17rvijay17 Member Posts: 15
Can i use VB6 to access mySql database.

Comments

  • jcarlssonjcarlsson Member Posts: 21
    : Can i use VB6 to access mySql database.

    I don't know VB but I think that it should go if you find some "module" or so for VB that handles the communication with MySQL. Have you looked at documentation pages on the internet? I searched for it on Altavista and found this:

    http://www.bitmechanic.com/mail-archives/mysql/Apr1999/0580.html

    And after what I have found I say you should use DAO to access your MySQL database.
    [red]--[/red]
    [green]jcarlsson[/green] [blue]<[/blue][purple]jcarlsson@linux.nu[/purple][blue]>[/blue]
    [red]http://www.jcarlsson.tk[/red]

  • thelabwizthelabwiz Member Posts: 1
    : Can i use VB6 to access mySql database.
    :

    Most definitely. You can find complete code that uses ODBC to connect VB6 to MySQL at http://thelabwiz.home.mindspring.com/mysql.html. This was a group project for a client-server class and has all the source, lots of documentation in Word, including screen shots of setting up ODBC DSN's, MySQL admin, and other useful stuff.

    The connection could have been done with another interface (ADO, etc) but the professor was interested in ODBC - so we used it, and included examples of extracting data from MySQL with Word, Excel, and Access.

    If you use ODBC, you will have to construct a DSN to point to your MySQL server.


  • rvijay17rvijay17 Member Posts: 15
    : : Can i use VB6 to access mySql database.
    : :
    :
    : Most definitely. You can find complete code that uses ODBC to connect VB6 to MySQL at http://thelabwiz.home.mindspring.com/mysql.html. This was a group project for a client-server class and has all the source, lots of documentation in Word, including screen shots of setting up ODBC DSN's, MySQL admin, and other useful stuff.
    :
    : The connection could have been done with another interface (ADO, etc) but the professor was interested in ODBC - so we used it, and included examples of extracting data from MySQL with Word, Excel, and Access.
    :
    : If you use ODBC, you will have to construct a DSN to point to your MySQL server.
    :
    :
    :


    The link leads nowhere. Please can you check the link again.

    vijay.

Sign In or Register to comment.