Thanks Brandon!
It worked but with name resolution. With IP it didn't work. Very strange!!!!!
I'm trying to figure why.
Many thanks again and a Happy New Year!
>I had intermittent issues using name resolution, changing connection string to IP addresses fixed that.
>
>
>driver={SQL Server Native Client 10.0};server=tcp:10.0.0.1,1433;Failover_Partner=tcp:10.0.0.2,1433;database=yourdbname;uid=yourusername;pwd=yourpassword;
>
***
TONY Nascimento
*****************
"Your mind is like a parachute. It only works if it is open" - Anthony J. D'Angelo
"The desire to know is natural to good men" - Leonardo da Vinci