Kbase P136210: Can SqlServer failoverPartner option be used in EasyAsk?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
20/10/2008 |
|
Status: Unverified
GOAL:
Can SqlServer failoverPartner option be used in EasyAsk?
GOAL:
Can an EasyAsk dictionary connection parameter be set up to use the failover partner option?
FACT(s) (Environment):
EasyAsk
FIX:
If an EasyAsk dictionary is connecting to a SqlServer database and you want to have mirror databases so that the dictionary is independent of which database is available, simply specify the SQL Server failoverPartner option when defining your connection parameters in the dictionary.
jdbc:sqlserver://<host>:<port>;failoverPartner=<host>:<port>;databasename=<database name>
jdbc:sqlserver://localhost:1433;failoverPartner=<host>:<port>;databasename=EcomDemo