using mirroring of sql2005 +adp

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is it possible to use the mirroring function of sqlserver2005 with an adp? if
so how?

thnx in advance
 
And with automatic reconnection in case of a failover? I don't think that
you can do so because the standard connection will use the classic oledb
sql-server provider, not the new Native SQL-Server Provider; so you will
have to reconnect manually in case of a failover.

Maybe you can to close the connection and reopen it in VBA code using the
CurrentProject.CloseConnection and CurrentProject.OpenConnection functions
and the new native provider; however, I don't know (and I can't test) if
this will work or not; see:

http://groups.google.ca/group/micro...seconnection+openconnection&start=0&scoring=d
 
Back
Top