Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
daunce
Starting Member
11 Posts |
 Posted - 2008-08-28 : 19:00:16
|
| Hi all.Is there a way for a web application to call the DB with one host name, and still use that name for when the DB fails over to the mirror?Or does failing over connections to the DB have to be done in the client application?Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
daunce
Starting Member
11 Posts |
Posted - 2008-08-29 : 14:31:13
|
| Thanks Tara.i've just been looking but unable to find any definitive answer, does php's mssql_connect() function support client redirect? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-29 : 14:39:00
|
| Not sure about PHP connection:But look at this good article:http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/implappfailover.mspx |
|
|
|
daunce
Starting Member
11 Posts |
Posted - 2008-08-29 : 15:21:31
|
| wow, you guys just moinitor these forums all the time.. ;-)i found this:http://msdn.microsoft.com/en-us/library/cc296161(SQL.90).aspxit says the Microsoft sql driver (released last month) for php supports Failover_Partner option.Thanks for your helpful information. Much appreciated. |
|
|
|
|
|
|
Single name space