Sample Header Ad - 728x90

AWS EC2 Opendatasource to the same server - OLE DB provider "SQLNCLI11" for linked server "(null)"

0 votes
1 answer
344 views
Trying to run a Opendatasource query to point to the same server as the source server in AWS EC2, I got this message intermittently (once out of about 20 times, the other 19 times do get results back). Any suggestion will be appreciated. Thanks. Error:
Cannot create an instance of OLE DB provider "SQLNCLI11" for linked server "(null)"
Query:
select top 10 *
from OPENDATASOURCE('SQLNCLI11','User ID=test;Password=test;Data Source=10.11.5.11').[test].dbo.test
Asked by James (93 rep)
Aug 2, 2021, 10:51 PM
Last activity: Apr 21, 2025, 01:08 AM