Difference between revisions of "Connection String Examples"
From EHS Help
(Created page with " AnyDAC?AuxDriver=MSSQL;Server=sql_server;Database=IBID;Integrated Security=SSPI AnyDAC?AuxDriver=MSSQL;Server=sql_server;Database=IBID;UserId=ibid_server_login;password=ibid...") |
m |
||
| Line 1: | Line 1: | ||
| − | + | Uses the internal SQL Server driver and domain authentication: | |
| − | AnyDAC?AuxDriver=MSSQL;Server=sql_server;Database=IBID; | + | AnyDAC?AuxDriver=MSSQL;Server=sql_server;Database=IBID;Integrated Security=SSPI |
| − | ADO?AuxDriver=SQLOLEDB.1;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 | ||
Latest revision as of 08:51, 5 August 2021
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
