I am using type-2 right now (although later on, will need to use
type-4). Thanks.

On Dec 10, 11:07 pm, "Mark A" <nob...@nowhere.com> wrote:
> <hummingbir...@gmail.com> wrote in message
>
> news:85a8c00a-e09e-4e4f-95ae-fd9666fde1e5@e23g2000prf.googlegroups.com...
>
> >I have a couple questions about setting up automatic client reroute.
> > First, after setting the alternate server for a database, is there a
> > way to verify the settings later on? The next thing is I've added
> > these values for my HADR pair, but I'm not sure I'm testing the basic
> > functionality correctly. I connect to the primary, then issue a
> > switch role takeover, then attempt to continue running SQL against the
> > database (I've also tried a connect with the now deactivated
> > database). In all cases, I still get the SQL30081 error, so have
> > obviously done something wrong.
>
> > Thanks,
> > Lisa
>
> How are you submitting the SQL statements? Using type 2 driver or type 4
> driver?