SQL2005 enforce sql logins to using Windows password Policy.

Hi,

IF I check both CHECK_POLICY and CHECK_EXPIRATION on in sql2005. It will
enable sql logins to use WINdows2003 AD password policy?
If AD configured case sensitive. Sql logins will be case sensitive as well
even sql2002 sort order is 52.
If an application is use ODBC connection to the sql2005, Do I need to change
the ODBC driver to native ODBC or something?

Thanks


.