Connecting to MySQL without DSN

[dirkfirst]

Is there a way to connect to MySQL without a DSN in the system?

[brackett]

Depends on what provider your using. OleDb would be something like:

"Provider=MySQLProv;Data Source=mydb;User Id=UserName;Password=asdasd"

Check ConnectionStrings.com for other variations.

[dirkfirst]

I found a free library that allowed me to connect o mysql without DNS entries.

[Saint]

I found this which is in C# but you port it to managed C++


You need to download and install this:
http://dev.mysql.com/downloads/connector/net/1.0.html

			string MyConString = "SERVER=localhost;" +
				"DATABASE=mydatabase;" +
				"UID=testuser;" +
				"PASSWORD=testpassword;";
			MySqlConnection connection = new MySqlConnection(MyConString);
			MySqlCommand command = connection.CreateCommand();
			MySqlDataReader Reader;
			command.CommandText = "select * from mycustomers";
			connection.Open();
			Reader = command.ExecuteReader();
			while (Reader.Read())
			{
				string thisrow = "";
				for (int i= 0;i<Reader.FieldCount;i++)
						thisrow+=Reader.GetValue(i).ToString() + ",";
				listBox1.Items.Add(thisrow);
			}
			connection.Close();

Taken from http://bitdaddys.com/MySQL-ConnectorNet.html

[Void]

Saint said it. I've used that driver before and it preforms very well.

[Ronin]

Is this a secure way to connect though? I mean, can't anyone that uses your client to connect be able to retrieve your username and password? You had better think on that before releasing this software to the public. You may end up with an empty DB.

[dirkfirst]

I'm not sure if it is very secure or not. It doesn't seem very secure.....

[brackett]

It's as secure as the client. In other words, if you've set up DB access correctly so that the login provided only has permissions to do certain things - then anyone with that login only has permissions to do the same things your app does.

In other words - no it's not secure. But it's not really supposed to be either. Security is enforced at the database in this situation.

[Jordan]

In other words dirkfirst, you should set grant permissions very limiting from the app connecting to your DB.