Hi<BR><BR>Im trying to place some variables in a DSN connection string like the following:<BR><BR>db_con.ActiveConnection = "DRIVER={MySQL};SERVER=www.someurl.com;DATABASE=da tabase;UID=dbuser;PWD=dbpass"<BR><BR>the proble is, i want to make the DATABASE, UID, PWD values into variables so i can set them in a central location and include the file that has the varialbes set (does this make sense)<BR><BR>anyway, if someone knows how to do this i would appreciate the answer<BR><BR>many thanks