ODBC does not transmit usernames and passwords in clear text (ODBC does not transmit anything) - but some ODBC drivers do. The basic SQL Server driver on Windows does "encrypt" the password and does not send it clear text but it is not that difficult to break.

It has been a while since I looked at it but I thought you could set SQL Server up to only accept encrypted connections and if that is the case there must be a Windows driver which does the encryption. May be I am imagining that.

So long as your client is on UNIX the Easysoft SQL Server ODBC Driver does all forms of SQL Server connections - simple encrypted password (and it is very simple), NTLM (a little better but not much), SSL for the connection only or SSL for everything. Unfortunately it is not available for Windows currently. BTW, I have a connection with Easysoft.

In reply to Re: Secure connection to SQL Server from Perl DBI by mje
in thread Secure connection to SQL Server from Perl 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.