MySQL connect using dial up connection with VB.NET

[rsalumpit]

I want to connect to a MySQL database but the only connection available is a telephone line, a dial-up connection. I'm using vb.net 2005 Express for my project. All local connections are working the only problem is how can i get the server to connect, like IP to connect to establish a connection.

Thanks!

[rsalumpit]

Anyone? Thanks!

[.paul.]

i don't see the problem? have a look at this:

http://www.connectionstrings.com/mysql

[rsalumpit]

i don't see the problem? have a look at this:

http://www.connectionstrings.com/mysql

My problem is what will be the IP/server address if i will connect using a phone line using a modem? How can i get the other ends IP/server address?

[rsalumpit]

Thanks for the reply.

Yes, I'm totally new to dial-up connection. My problem is how will get the IP of the end client I'm trying to connect? So that i can use it as the "server" on MySQL connection string.

Thanks Again!

[make me rain]

you need to just mention the IP,PORT,DATABASE,USERNAME,PASSWORD of your server in the connection string.
not necessary to bother who is the network provider,type of network,speed of network etc...
application will find it's route to your said server , if it is on the network, or else application will say unable to connect.
just go ahead

[rsalumpit]

you need to just mention the IP,PORT,DATABASE,USERNAME,PASSWORD of your server in the connection string.
not necessary to bother who is the network provider,type of network,speed of network etc...
application will find it's route to your said server , if it is on the network, or else application will say unable to connect.
just go ahead

Ok the problem is now i can establish connection thru dial-up then. How will i get the IP/SERVER NAME to connect and add it to the connectionstring?

[Justa Lol]

you need to add to the connection string:

Host=localhost;

or replace localhost with whatever IP you require.

[rsalumpit]

you need to add to the connection string:

Host=localhost;

or replace localhost with whatever IP you require.

That will connect to my localhost mysql server i think.

[make me rain]

yes localhost is your own system,
if you need to connect to a remote system then you need to say to your connection objects connection string that where is the foreign host ( as against to the localhost ) that is , the IP of that system
that will never be duplicated in one network tree, but you need to know that what is that foreign system IP, on which your server is living

[make me rain]

How will i get the IP/SERVER NAME to connect

when you are posting a letter ( i mean the data ) you need to specify the consignee address, that is the IP of the other system at other part of the world,
other wise how the post man will take it ? & take it to where,

hence better he ( i mean the application ) will reject your parcel at the first it self.

[Radjesh Klauke]

You dailup has absolutely nothing to do with the connectionstring. Your app need to communicate with the server-table, not with your provider.

[rsalumpit]

You dailup has absolutely nothing to do with the connectionstring. Your app need to communicate with the server-table, not with your provider.

Imagine i have no internet connection. And i only want to connect to other machine using dialup. End to end. The only one i have is a telephone number to connect. After I'm connected to the other end, What will be my connection string? The phone number also?

[make me rain]

refer to .poul's post at #3
with telephone number you can only talk to them on phone,
but you can not connect a database application

a database application requires a computer address in which your MySQL server is running
telephone number does not have any role here, but telephone network will provide the connectivity to other computers
do one thing , open your cmd window
type ipconfig ->
this will display the Inernet protocol of your computer
you can replace the " locoalhost" in your connection string with this string

now you may get some idea i think

[rsalumpit]

refer to .poul's post at #3
with telephone number you can only talk to them on phone,
but you can not connect a database application

a database application requires a computer address in which your MySQL server is running
telephone number does not have any role here, but telephone network will provide the connectivity to other computers
do one thing , open your cmd window
type ipconfig ->
this will display the Inernet protocol of your computer
you can replace the " locoalhost" in your connection string with this string

now you may get some idea i think

Yes. I think i got some ideas now. I will update you.

Thanks!