On Fri, Jul 24, 2015 at 10:57 AM, Kurt Wendt <[email protected]> wrote:
> Alright - a final follow-up. > > OK - as previously mentioned - my systems guy said I should only connect > to a Database if it's in Principal mode and Not in Mirror mode. > > So, to test this out - I connected into the Albany server using MSSM > Studio. And, when I went to look at one of the Databases in particular - I > saw that it had the status of Mirror. Where as, in another session of MSSM > Studio - I logged into our NYC Server - and the same Database had the mode > of Pricipal. Sure, that's all well and good - and what I expected. > > Then I tried connecting to the Albany Server - and to that particular > Database - using the same login credentials I used in MSSM Studio. Upon > running that SQLSTRINGCONNECT statement - it returned a value of "-1" as > the statement handle. > > ----------------------------- There is only ONE database in this situation. The API will direct all feeds to the proper Server for you. You NEVER just switch stuff like this and think YOU HAVE TO change. Hence why I said this is tricky. Before you accidently screw things up you need to research WTF is going on on the API side and stop thinking about the server(s). What version of SQL are you running, 2008 or more recent? This is a MAJOR issue and not an easy little fix BTW. > So - my assumption is that - even though the SQLSTRINGCONNECT could > connect to the Server, and could "See" the Database in question - it "knew" > to return back a value of "-1" since the Database was in Mirror mode - and > should thus NOT be used. > > Am I right? I suspect in this case - my assumption is correct. But, > figured I should just get verification from those folks more knowledgeable > in this area than myself (a kind of newbie for some of this SQL stuff)... > > Thanks again, > -K- > ----------------- > > -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMYL1fSH+mUfBd94qODk8M-0wqtQZGa1eA+C1yr6KgA8=3...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
