Connecting the program to an internet MySQL server

[telmessos]

Hi all,

I am a beginner in Visual Basic and I am writing a program which helps the users search subtitles. On start I need the program connect to an internet MySQL server and get the updated site list.

What shall I do to make this connection? What file shall I add to my setup file to make it work?

Any idea?

Thanks

[si_the_geek]

Welcome to VBForums!

Which version of VB are you using? (the methods you would use are dramatically different)

One thing we can say for certain is that you will need to install the client drivers (possibly ODBC) for MySQL.

[telmessos]

Hi,

I use VB6. I know how to install the ODBC for MySQL manually, but I don't have any idea how I can arrange it with the setup automatically
Any idea?

Thanks

[si_the_geek]

I don't know I'm afraid, perhaps there is something on the MySQL web site which explains it.

In order to use MySQL from VB6, you can use our ADO Tutorial (link in my signature).. you just need to change the connection string - and there is another link for that in my signature, which has examples for MySQL.