![]() ![]() OLE DB provider "MSDASQL" for linked server "WMB" returned message "Specified driver could not be loaded due to system error 126: The specified module could not be found. ()Ĭannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "WMB". TITLE: Microsoft SQL Server Management StudioĪn exception occurred while executing a Transact-SQL statement or batch. The interesting thing is that the driver is there even though the error says that it can't be found. However, when I try to link the server using the same connection, I receive the error below. The connection test works and I can execute queries from SQL Assistant on my server. Microsoft SQL Server Management Studio will not recognize my driver. MSDN: SQL Server Distributed Queries - OLE DB Provider for ODBC.Select * from TD.NorthwindEF.Customers References: The Teradata Database does not support Catalog leave it blank.The Linked Server Name crated in step 3 above.Execute a SELECT statement using a 4 part name ( LinkedServerName.Set the With password field to the Teradata Database Password.Set the Remote login field to the Teradata Database User Id.Select Be made using this security context.Set the Data Source to the ODBC DSN Name created in section 2 above.Set the Product Name to Teradata Database.Select Microsoft OLE DB Provider for ODBC Drivers.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.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |