Creating a linked server using ODBC

Create an ODBC by pointing to Strat>All Programs>Administrative Tools>Data Sources (ODBC)



Define the ODBC as your linked server by launching Enterprize Manager. Click on your server name>Security. Right click on Linked Servers and select New linked server
The following form will appear:
- In Linked Server field specify whatever name you want to call your new linked server.
Select Other data source.
- In Provider name choose Microsoft OLE DB Provider for ODBC Drivers.
- For Data source specify your ODBC name.
- Click on OK.