%META:TOPICPARENT{name="UDASystemIntegrationConfigDocs"}%

= Configuring a Microsoft SQL Server 2000 Linked Server with the Single-Tier "Lite" Edition OLE DB Provider for ODBC Data Sources =

# Open your **Microsoft SQL Server Enterprise Manager**.
# Drill down to:%BR%
**Console Root** {{{->}}} **Microsoft SQL Servers** {{{->}}} **SQL Server Group** {{{->}}} **Your SQL Server** %BR%
# Expand the **Security** folder.
# Right click on **Linked Servers**.
# Select **New Linked Server**.
# Supply the following information on your **General** tab:
#* **Linked Server:** //Any name you like//
#* (Check **Other Data Source**)
#* **Provider Name:** OpenLink OLE DB Provider for ODBC Drivers
#* **Product Name:** OpenLinkODBC
#* **Data Source:** //Valid ODBC DSN//
# This is the minimum information which you must supply. Feel free to check any server options on the bottom of the tab.  
# Click the big **Provider Options** button.
# Check these options: 
{{{
[*] Dynamic parameter
[*] Nested Queries
[ ] Level zero only
[*] Allow inprocess
[ ] Non transacted updates
[ ] index as access path
[ ] Disallow adhoc access
[ ] Supports 'Like' operator
}}}
# Save your changes.
# Click on the **Security** tab and review your options.  
# Click **OK** to create your server.  
# Exit the **Linked Server** dialog box and the **Microsoft SQL Server Enterprise Manager**.
# Open the **Microsoft SQL Server Query Analyzer**.
# Run the following query to test your Linked Server:
{{{
select * from OPENQUERY (Your_LINKEDSERVER_Name, 'your SQL query here')
}}}