sql server - Integrated security=false vs omitted -

sql server - Integrated security=false vs omitted -

i'm using ado connect sql server 2005 database. i'm using ole db connection. connection string looks like: provider=sqloledb;data source=lokdb;user id=secret;password=secret;app=lokeng_tests;wsid=lokspec1;network library=dbmssocn;initial catalog="edms-lok";persist security info=false;integrated security=false;

(i tried integrated security=no)

this throws error when seek open connection, if omit integrated security argument works.

i'm fine omitting argument if that's need do, wondering why works when explicitly setting argument false or no causes error?

the documentation states:

accepts value "sspi" windows authentication.

so there 1 valid value: sspi. if don't want utilize omit it.

sql-server database connection-string ado integrated-security