Link a Server to Accredo ODBC Driver

To create a linked server to Accredo ODBC Driver, use Microsoft SQL Server Management Studio.

Go to Server Objects > Linked Servers > Right Click > New Linked Server...

Enter the following:

Linked Server	The name you will refer to in queries, for example, ACCREDO
Server type	Other data source
Provider	Microsoft OLE DB Provider for ODBC Drivers
Product Name	Anything
Datasource	Name of a datasource set up using the ODBC Administrator
Provider String	Blank
Location	Blank
Catalog	Blank

Example usage:

Select * From [ACCREDO].[Accredo]..[ARCUST]

- OR -

Select * From ACCREDO.Accredo..ARCUST