Connetion string

[waynecod]

Hi,
I am using the following connection string to connect to my mysql server which works very well.

//Connection string for connector/ODBC 3.51
string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};"+
"SERVER=localhost;"+
"DATABASE=online_address_book;"+
"UID=root;"+
"PASSWORD=mysql;"+
"OPTION=3";

The problem I have is I need to change the UID and the PASSWORD by reading them from a TextBox control in runtime so that different users can connect to the database.
How can I change these values??? Be very gratefull for a tip here.

Kind regards

Wayne

[Falk Prüfer]

Hi Wayne,

that means first time a problem of your programming language - not of mySQL.
What do you use? C?, VB?, Delphi?

regards

Falk

P.S.: Sorry, I have to improve my english