mySQL connection

[Matuu]

Hello,

I have webhost and having mySQL database, but how i can connect it? In Visual Basic project. I have no idea.. So how do it?

I want make like that login form (Using mySQL database in webhost username & password) and check it.

[dunfiddlin]

Has Google closed down or something?

http://www.dreamincode.net/forums/to...nect-to-mysql/

[si_the_geek]

You connect in the same way as you would with a local MySQL database, you just put different values in the connection string for the database location etc.

As to what the values should be, your host should be able to tell you that - or more likely, tell you that they do not allow remote connections to their databases because it is a big security risk.

[Matuu]

You connect in the same way as you would with a local MySQL database, you just put different values in the connection string for the database location etc.

As to what the values should be, your host should be able to tell you that - or more likely, tell you that they do not allow remote connections to their databases because it is a big security risk.

Atleast i have webhost CPanel, just there i can create mySQL database and enable/disable remote connection.

But is that good idea for instant messenger program? If not, then what i should make it? I've heard about TCPlistener or something for instant messenger, but i dont know if that's good or not.. Just like creating email account and logging into messenger -> You can add contact and click on contact then you can talk with (selected) contact. Like the Windows Live Messenger.

dunfiddlin, sorry btw, i downloaded this and now installing that.

[Matuu]

Can someone reply about last post made by me? (About question's)

Thanks,
Matuu.

[si_the_geek]

Using network communication like TCP is valid for a messenger type application, but in order to have features like logging in and contacts (assuming you want the users to be able to log in from any computer) then a network/web based database of some kind is needed - and it is then perfectly valid to use the database for everything else too.

[Matuu]

Using network communication like TCP is valid for a messenger type application, but in order to have features like logging in and contacts (assuming you want the users to be able to log in from any computer) then a network/web based database of some kind is needed - and it is then perfectly valid to use the database for everything else too.

Can someone explain it about TCP, that how it must work? When logging into, then IP will restored into database? If port needed, but what about if someone have port, that isn't opened?

[si_the_geek]

You wouldn't usually use TCP etc and a database together for something like this, it is basically more sensible to use one or the other.

The exception to that would be if all the clients communicate with a server based program via TCP etc, and the server based program then does the work with the database as needed (and the clients don't work directly with the database). This would allow you to keep the database secure, so that people can't steal each others login id's etc.