Loading

Question on Myconnection

aadebayo

Hello I am trying to write an application that will potentially be deployed on many hosts. As a result, I want to write a mySQlConnection profile that is generic, that is does not contain literals. Can some one tell me how to it. Here is how it currently looks like MySqlConnection mySqlConnection = new CoreLab.MySql.MySqlConnection("Host=host;User=user;password=password;database=database");

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

ytram521y ago
Are you saying that Host=host will change wherever your application is deployed? If so, there are several ways you could implement it. A common way is using an xml configuration file. Using this, there will be a file associated with the executable that will contain the necessary host information to make a connection. If host is all that is changing, you could also just have the host be an argument that is passed to the application upon startup.