Article

"System error 126" returned when creating SQL Server Linked Server

« Go Back

Information

 
Article Number000039678
EnvironmentProduct: Connect / Connect64 XE for ODBC Salesforce driver
Version: 7.1
OS: Windows Server 2008
Database: Salesforce
Application: SQL Server 2008/2012 Linked Server, Mitel Contact Center Management
Question/Problem Description
"System error 126" thrown when creating linked server from SQL Server Management Studio or using the Salesforce driver through any Windows service.
The test connect is successful using the ODBC Administrator.
Steps to Reproduce
Clarifying Information
Error MessageCannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "SFDC", OLE DB provider "MSDASQL" for linked server "SFDC" returned message "Specified driver could not be loaded due to system error 126: The specified module could not be found (DataDirect 7.1 Salesforce, C:\Program Files\Progress\DataDirect\Connect_for_ODBC_71\Drivers\ivsfrc27.dll).". (Microsoft SQL Server, error: 7303)

Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "SALESFORCE", OLE DB provider "MSDASQL" for linked server "SALESFORCE" returned message "Specified driver could not be loaded due to system error 126: The specified module could not be found (DataDirect 7.1 Salesforce, C:\Program Files\Progress\DataDirect\Connect64_for_ODBC_71\Drivers\ddsfrc27.dll).". (Microsoft SQL Server, error: 7303)
Defect/Enhancement Number
Cause
The DataDirect installer adds the driver path installdir\Connect_for_ODBC_71\drivers to the system PATH.  The Windows service does not automatically pick up the updated system PATH after the drivers are installed and needs to be restarted to pick it up.
Resolution
Restart the Windows service to pick up the system PATH that includes the drivers directory.

For additional information about troubleshooting error 126 with the Salesforce driver, see article 000032614, Troubleshooting system error 126 with the ConnectXE for ODBC Salesforce driver.
Workaround
Notes
Attachment 
Last Modified Date2/13/2018 1:07 PM


Feedback
 
Did this article resolve your question/issue?

   

Your feedback is appreciated.

Please tell us how we can make this article more useful. Please provide us a way to contact you, should we need clarification on the feedback provided or if you need further assistance.

Characters Remaining: 1025