Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connect to a Mirrored Database
Message
From
28/12/2010 09:49:18
 
 
To
28/12/2010 03:40:03
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01493970
Message ID:
01493998
Views:
61
Hi.
I've already tried many of those.
But VFpro does not see the "new" main server when
the mirror switches as main server.
Any help will be appreciated.


>>Hi all.
>>I want to connect from VFpro to a Database that is mirrored (SQL Server 2008 SP2) with witness.
>>I'm having problems with the connection string. I want to take advantage of the mirroring.
>>If my VFpro application can't see the mirroring it won't get data from the mirror if the main
>>server fails and the mirror rises as the main server.
>>
>>Information:
>> Database server: TESTE\PRODUCAO
>> Mirror server: DATA\ESPELHO
>> Witness server: LABORATORIO\TESTEMUNHA
>
>Googling [mirrored database connection string] yields some useful-looking results.
***
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform