Login System - is it possible?

[cwade12c]

Is it possible to connect to a my remote website's MySQL Database which holds a list of usernames and passwords, and if txtUsername.Text and txtPassword.Text matches the stored information, msgbox"Logged In" occurs?

Of course I will be doing something other than the msgbox, I've seen some stuff here at vbForums with MySQL, but it's all been local side. How can I do this remotely?

[techgnome]

same as you would locally, but you would need to supply the IP or dns name of the server where the database is located. Also the database would need to be accessable from the outside world (some ISPs don't allow outside access to the databases - it's a security issue).

-tg

[cwade12c]

Well the code I've seen here AND on pscode (I've been searching for a bit), connects to the Database from so you can run queries. I don't need to connect, I rather really just need to quickly use a SELECT function so I can get information out of two tables - Username and Password, but I don't understand how to integrate Queries with VB6.

[dee-u]

You need to connect in order to execute queries against it.

[cwade12c]

Right... but I don't know how to post the queries..

[si_the_geek]

Thread moved to Database Development forum (the "VB6" forum is meant for questions which don't fit in more specific forums)

You do it in exactly the same way as you would for a local database - the only thing that needs to change is the connection string, which needs to use the IP or dns name of the server (rather than something like "local"). There are examples of connection strings via the link in my signature.

There are several examples of working with databases (including running queries, etc) in the "Classic VB - ADO" section of our Database Development FAQs/Tutorials (at the top of this forum), I'd recommend starting with Beacons ADO Tutorial.