Hi, I have the MySQL ODBC Driver for connecting to a MySQL Database in Visual Basic. I will be having about 30 individual databases which normally would mean manually setting up 30 ODBC Connections on each of our 50-60 pc's. Is there an easier way of doing this? Since all my connection strings are coded in the programs as follows:

VB Code:
  1. cn.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;Extended Properties=DATABASE=DataBase_Name;DESCRIPTION=MySQL NCMR Database;DSN=DSN_NAME;OPTION=àà z;PORT=0;SERVER=192.168.50.4;UID=brandone"

Is it possibly to just have one ODBC DSN on each PC that could handle all 30 programs?