| TeleFlow Forums http://teleflow.org/phpbb/ |
|
| Connecting to mirrored SQL databases http://teleflow.org/phpbb/viewtopic.php?f=10&t=957 |
Page 1 of 1 |
| Author: | rbevers [ Thu Apr 01, 2010 4:14 am ] |
| Post subject: | Connecting to mirrored SQL databases |
I have tried numerous versions of this: "Provider=SQLNCLI10;Data Source=MSTRMDB1-CORP;Failover Partner=MSTRMDB1-GULF;Initial Catalog=MeterWO;UID=myUID;PWD=myPWD" I always get this error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified |
|
| Author: | Chris [ Thu Apr 01, 2010 9:51 am ] |
| Post subject: | Re: Connecting to mirrored SQL databases |
I think some of the parameters in your connect string might be more suited to an ADO connection or the like. (I have found some connect string options that are supposed to do "something" just don't work, or are named slightly different in an ODBC connect string than examples you might find) I found what I believe might be a string you could use. I don't have a mirror, but I did come up with a string I believe at least tried to establish a failover partner, based on the nature of the errors I was receiving. (My connect string works without the failover partner, and has a pile of authentication errors with the partner in the string) I have tried to translate my connect string to use the info you provided below: DRIVER={SQL Server Native Client 10.0};SERVER=MSTRMDB1-CORP;DATABASE=MeterWO;Failover_Partner=MSTRMDB1-GULF;UID=myUID;PWD=myPWD; Hope that helps! |
|
| Page 1 of 1 | All times are UTC - 8 hours [ DST ] |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|