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 --- _______________________________________________ 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/cajidmyjayfugm7e7noh_3k8dbi_9wvbehcvrvwusehaiems...@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.
