![]() Assign a name to the Linked Server I suggest a single word name like TD.Make Sure MSDASQL (Microsoft OLE DB Provider for ODBC Drivers) is installed on the server.Select the Data Source created in the previous sectionĤ.Select Use data source name radio button.Select the Microsoft OLE DB Provider for ODBC Drivers. ![]() Double-Click the file to display the Data Link Properties dialog box.Change the file extension to UDL (for example Foo.UDL).Right-Click and select " New" - > " Text Document".Fill in the required fields in the ODBC Driver Setup for Teradata Database dialog box.User DSN will not work because SQL Server service will not have access to the User DSNs. Start the ODBC Data Source Administrator.You can use the steps in the "Test the ODBC Data Source" section to see a list of OLE DB Providers currently installed on your server. The OLE DB Provider for ODBC 64-bit if it is not included in your OS.This blog outlines the steps to create a SQL Server 2008 (64-bit) R2 Linked Server to the Teradata Database.
0 Comments
Leave a Reply. |