10/16/2023 0 Comments Connecting toad sql server to as400OLE DB provider "MSDASQL" for linked server "TESTAS400" returned message " Data source name not found and no default driver specified". ()Ĭannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "TESTAS400". Do you want to keep the linked server?Īn exception occurred while executing a Transact-SQL statement or batch. The linked server has been created but failed a connection test. TITLE: Microsoft SQL Server Management Studio set the product name, dtatsource location and provider string I left blank, filled in the catalog. Chose Microsoft OLE DB Provider for ODBC Drivers. I went through the Linked Server setup steps. I created a ODBC in the ODBC Data source Administrator I am still getting error when testing the connection. In need of some assistance, I am trying to connect to AS400 machine to pull data from it, as a linked server.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |