using mirroring of sql2005 +adp

G

Guest

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

thnx in advance
 
S

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:

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

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

Similar Threads

Security Question 4
Using mirrored sql 2005 db with a ms access adp project 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Access2003 ADP & SQLServer2005 2
NT Integrated security VS Specific User name and password 12
Strange HDMI connection problem - please HELP! 3
SQL Server Management Objects (SMO) 4
Lookup Columns in ADP/SQL Server 2005 combination 4

Top