Connect to system database with .INI file

Connecting Visual Basic 6.0 to MySql Database.
Here is how. Install MySql Datasbe on you local machine, configure it well and by using localhost, root, root,
Here is the VB6 Connecting to MySql Databse:

Public Function connectionString()
    connectionString = "DRIVER={" & ReadIniValue(App.path & "\Config.ini", "DEFAULT", "DRIVER") & "};" _
                      & "SERVER=" & ReadIniValue(App.path & "\Config.ini", "DEFAULT", "HOST") & ";" _
                      & "DATABASE=" & ReadIniValue(App.path & "\Config.ini", "DEFAULT", "DBNAME") & ";" _
                      & "UID=" & ReadIniValue(App.path & "\Config.ini", "DEFAULT", "UID") & ";" _
                      & "PWD=" & ReadIniValue(App.path & "\Config.ini", "DEFAULT", "PWD") & ";" _
                      & "OPTION=3"
End Function

-as you notice, here in this code I used a config file. If you have any questions on my config file, you can proceed or click here for sample code on creating config.ini.
-If you don't want to use any preconfigured file. you can use the traditional way in connecting to mysql, but I highly suggest you to use preconfigured file, just in case if you are connecting to a remote server, where unexpected connection settings will be change. This is just to avoid the redundant changes on your code.

So...... lets proceed....

Visit http://www.jackjones2010.blogspot.com for more info.