Connection String Examples
From EHS Help
Uses the internal SQL Server driver and domain authentication:
AnyDAC?AuxDriver=MSSQL;Server=sql_server;Database=IBID;Integrated Security=SSPI
Uses the internal SQL Server driver and SQL authentication:
AnyDAC?AuxDriver=MSSQL;Server=sql_server;Database=IBID;UserId=ibid_server_login;password=ibid_server_login_password
Uses ADO SQLOLEDB driver and domain authentication:
ADO?AuxDriver=SQLOLEDB.1;Server=sql_server;Database=IBID;Integrated Security=SSPI;
Uses ADO SQL Native Client and SQL Server authentication:
ADO?AuxDriver=SQLNCLI10.1;Server=sql_server;Database=IBID;UserId=ibid_server_login;password=ibid_server_login_password
