Data Model > Available DSCs > ADO DSC > Example .adoinfo files > SQL Server tables
 
SQL Server tables
This .adoinfo file uses the Microsoft OLE DB Provider for SQL Server to read the Orders table in the Northwind sample SQL Server database, which is installed on the local computer ("localhost"):
<ADODSC>
<ConnectionString>
Provider=SQLOLEDB.1;
Integrated Security=SSPI;
Persist Security Info=False;
Initial Catalog=Northwind;
Data Source=localhost
</ConnectionString>
<Table>
Orders
</Table>
</ADODSC>
Note You should not use the ADO DSC to connect to a UNICOM Intelligence relational database. Use the Relational MR database (RDB) CDSC instead.
See also
Example .adoinfo files