Are you sure Toad is using the ODBC Driver? What is the name of the dialogue which pops up from Toad?

The first time an ODBC Driver knows it cannot "login" is when SQLDriverConnect fails. There is no specific ODBC state for "login expired". However, there is the magic SQL_DRIVER_PROMPT and SQL_DRIVER_COMPLETE options to SQLDriverConnect which allow the ODBC driver to throw up a dialogue and complete the connection string. If Toad is using the SQL Server ODBC driver then I'm guessing the dialogue you are seeing is NOT a Toad thing but a SQL Server driver dialogue. You won't get this with DBD::ODBC because it does not set SQL_DRIVER_PROMPT although if you rebuild it yourself it could easily do so.

If you investigated it further by looking at the dialogue and trying to add SQL_DRIVER_PROMPT to SQLDriverConnect call in DBD::ODBC I would consider adding an attribute to DBD::ODBC to enable this functionality.

In reply to Re: How to change expired database password via DBI? by mje
in thread How to change expired database password via DBI? by Sue D. Nymme

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.