SQLNCLI11 for linked server UCCX returned message "Invalid connection string attribute" Check if instance name is correct and if SQL Server is configured to allow remote connections.
OLE DB provider SQLNCLI11 for linked server UCCX retunred a message "A network-related or instance-specific error has occured while establishing a connection to SQL Server. OLE DB provider SQLNCLI11 for linked server UCCX returned message "Login timeout expired" Named Pipes Provider: Coould not open a connection to SQL Server. OLE DB provider "Ifxoledbc" for linked server "UCCX" returned messazge "EIX000: (-23197)" Database locale information mismatch" (Microsoft SQL Server, Error: 7303)Ģ) Using Microsoft OLE DB Provider for SQL Server as explained in this blog which returns the error: Googled and read everything I could to resolve this without success.ġ) Using IBM Informix instructions with OLE DB Provider in which I get the following error (regardless if I use a DNS in provider string):Ĭannot initialize the data source object of OLE DB provider "Ifxoledbc" for linked server "UCCX".Attempted to create the linked server in two ways below.
Tested the connectivity of the DSN settings (test is good) after changing the locale settings so the client and server match, and server is correct.
#INFORMIX ODBC DRIVER#
Configured a System DSN for the IBM Informix ODBC Driver Setup.Installed the latest Informix OLE DB Driver on the SQL Server host machine.I haven't tried this with other versions (2008R2, etc) since I wanted to set up the connection in a test environment first. After about 3 days of trying, I am unable to create a linked server from SQL Server 2016 to Informix 11.5.