Stephen - as for Breaking things. You are jumping to conclusions - and AssUMing that I am making changes directly to a Live system. In fact, I make changes and test on a Test version of the system. Then, if I feel the changes work (the automatic switching over to the DR Server upon startup) - then I make the same changes to a QA System - and a QA Person must test it. If they confirm its good - THEN I need to apply the changes to Production system.
And - again - at this point I am ONLY Concentrating on switching between servers upon Startup of the App. -K- -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Stephen Russell Sent: Friday, July 24, 2015 12:32 PM To: [email protected] Subject: Re: Connecting to SQL via VFP w/Failover... On Fri, Jul 24, 2015 at 11:21 AM, Kurt Wendt <[email protected]> wrote: > Ah yes - thanks for that reminder. I did see Help info on AERROR() - I > just forgot to try using it. > > So - per you suggestion - I tried it. It listed 2 errors - as such: > "[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open > database "Merg" requested by the login. The login failed." > "[Microsoft][ODBC SQL Server Driver]Invalid connection string > attribute" > > It's not really clear as to exactly why it failed - even upon reading > the above errors. As previously mentioned - I connected to the Server > using MSSM Studio and the same credentials that I passed to the > SQLSTRINGCONNECT command. > > As such - I think I can continue to stick with the same assumption - > that it failed to connect BECAUSE the Database I was trying to connect > to was in Mirror mode. > > --------------------- This is why DBAs hate developers who blindly attack stuff without investigating what is really happening. Here is a spot to get an ebook/pdf on what is happening. http://it-ebooks.info/search/?q=SQL+High+Avalibility&type=title You can pick the version your are going against for your download. BTW this is pretty serious and if you break it, it becomes a real bitch to reset everything and have it be working properly. Because it is a Friday you may have already screwed the pooch and the ops guys now have a lot of work getting it backup and working properly. Only know because I have had this happen to me before. -- 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 --- [excessive quoting removed by server] _______________________________________________ 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/80838f1ca795b14ea1af48659f35166f1ce...@drexch02.corp.globetax.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.
