Data Environment dynamic run-time connection

Hi Folks
I have an app that needs to set its Data Environment connection dynamically. I do this in the DE initialize event. Problem is the command objects i hte DE dont work when I cange the connection objects connection string. Im trying to change each command objects activeconnection property to the new connectionstring or just the new connection but I cant get it to work. Im getiing a
"Syntax error or Access violation" error when my command objects try to execute.

Any ideas?