>I need an example of a string being passed to ODBC to change the DNS via code.
To see ODBC connection string just create FILE DSN and than open it in any text editor. You don't have to use DSN after all . You can establish DSNless connection using SQLStringConnect().