#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2001
    Location
    USA
    Posts
    313
    Rep Power
    18

    mySQL and VB6 or .NET


    I have had someone ask me if there is a way to connect to a mySQL database from VB6 or VB.NET with out having to go and setup something on every users system like myODBC and a DSN in the ODBC control panel. Is there a way to design a program to use a mySQl database that you can have a user install that will not invovle a user to have to setup anything other then the program and all the Database stuff is just setup and works..?
  2. #2
  3. /(bb|[^b]{2})/

    Join Date
    Nov 2001
    Location
    Somewhere in the great unknown
    Posts
    5,163
    Rep Power
    792
    No, pretty much not.
    You can check into doing the ODBC setup and myODBC install through an installation script. This would require something other than the VB package installer though.
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2001
    Location
    USA
    Posts
    313
    Rep Power
    18
    Onslaught thanks for the reply. I pretty much figured this would be my answer but I thought it did not hurt to ask. Had someone ask if that was possible. If you run a crossed any info to the contrary let me know.
  6. #4
  7. /(bb|[^b]{2})/

    Join Date
    Nov 2001
    Location
    Somewhere in the great unknown
    Posts
    5,163
    Rep Power
    792
  8. #5
  9. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    North Midlands, UK
    Posts
    1
    Rep Power
    0
    If you were prepared to accept a separate install that was only a double click on an exe and then a wizard like install with no configuration then you could try:
    http://old.sw.com.sg/products/myoledb/
  10. #6
  11. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2002
    Posts
    51
    Rep Power
    12
    The easiest what is the odbc drivers for mysql which can be downloaded here.

    http://www.mysql.com/downloads/api-myodbc-3.51.html

    there are also apis for .net technologies on the site for download somewhere as well
    Tewl

IMN logo majestic logo threadwatch logo seochat tools logo