i have deleted my post becuase i realized that the managers generate overloads that allow me to pass in an adapter which is what i need, so i can use a custom connection string this way.
Glad it's solved, Jeff!