Now you need to input the Linked Server name, e.g. Make sure to select Microsoft OLE DB Provider for ODBC Drivers: In the appeared Provider Options window, enable the Allow inprocess checkbox: ![]() For this, find the MSDASQL provider in the list of Linked Servers and double-click on it Retrieving Data From Amazon RedshiftĮnsure the Allow inprocess option of MSDASQL OLE DB Provider for ODBC Drivers is enabled. You can now issue distributed queries and access Amazon Redshift databases through SQL Server. The linked server will appear under the Linked Servers in the Object Explorer Pane. Alternatively, you can input the ODBC Driver connection string in the Provider field.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |