using mirroring of sql2005 +adp



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

thnx in advance

Sylvain Lafontaine

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:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question