How to form a correct MySQL connection string? [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed 11 years ago.

The community reviewed whether to reopen this question 1 year ago and left it closed:

Original close reason(s) were not resolved

Improve this question

I am using C# and I am trying to connect to the MySQL database hosted by 00webhost.

I am getting an error on the line connection.Open():

there is no MySQL host with these parameters.

I have checked and everything seems to be okay.

string MyConString = "SERVER=mysql7.000webhost.com;" +
            "DATABASE=a455555_test;" +
            "UID=a455555_me;" +
            "PASSWORD=something;";

MySqlConnection connection = new MySqlConnection(MyConString);

MySqlCommand command = connection.CreateCommand();
MySqlDataReader Reader;

command.CommandText = "INSERT Test SET lat=" + 
OSGconv.deciLat + ",long=" + OSGconv.deciLon;

connection.Open();
Reader = command.ExecuteReader();

connection.Close();

What is incorrect with this connection string?

I think you should use command.executenonquery instead of reader = command.ExecuteReader(); And about your sqlcommand ,I Think it should be 'Insert Into Test(lat,long) Values ('"+OSGconv.deciLat+"','"+OSGconv.deciLon+"')' — Hiren
– Hiren, Commented May 8, 2012 at 20:29
@Hiren can you give me an example of how to write this? thanks — user123_456
– user123_456, Commented May 8, 2012 at 20:38

Raktim Biswas · Accepted Answer · 2016-07-17 21:36:32Z

37

try creating connection string this way:

MySqlConnectionStringBuilder conn_string = new MySqlConnectionStringBuilder();
conn_string.Server = "mysql7.000webhost.com";
conn_string.UserID = "a455555_test";
conn_string.Password = "a455555_me";
conn_string.Database = "xxxxxxxx";

using (MySqlConnection conn = new MySqlConnection(conn_string.ToString()))
using (MySqlCommand cmd = conn.CreateCommand())
{    //watch out for this SQL injection vulnerability below
     cmd.CommandText = string.Format("INSERT Test (lat, long) VALUES ({0},{1})",
                                    OSGconv.deciLat, OSGconv.deciLon);
     conn.Open();
     cmd.ExecuteNonQuery();
}

edited Jul 17, 2016 at 21:36

Raktim Biswas

4,1055 gold badges30 silver badges34 bronze badges

answered May 8, 2012 at 20:29

laltin

1,14712 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user123_456 Over a year ago

I am still getting : Unable to connect to any of the specified MySQL hosts

digitalmarks · Accepted Answer · 2012-05-08 20:39:47Z

6

string MyConString = "Data Source='mysql7.000webhost.com';" +
"Port=3306;" +
"Database='a455555_test';" +
"UID='a455555_me';" +
"PWD='something';";

answered May 8, 2012 at 20:39

digitalmarks

4393 silver badges3 bronze badges

Comments

Eric Leschinski · Accepted Answer · 2013-12-27 21:02:11Z

5

Here is an example:

MySqlConnection con = new MySqlConnection(
    "Server=ServerName;Database=DataBaseName;UID=username;Password=password");

MySqlCommand cmd = new MySqlCommand(
    " INSERT Into Test (lat, long) VALUES ('"+OSGconv.deciLat+"','"+
    OSGconv.deciLon+"')", con);

con.Open();
cmd.ExecuteNonQuery();
con.Close();

edited Dec 27, 2013 at 21:02

Eric Leschinski

155k96 gold badges423 silver badges337 bronze badges

answered May 8, 2012 at 20:47

Hiren

1,4015 gold badges25 silver badges42 bronze badges

1 Comment

boctulus Over a year ago

At least for C#, it's Server and not ServerName

Collectives™ on Stack Overflow

How to form a correct MySQL connection string? [closed]

3 Answers 3

1 Comment

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Linked

Related