Linked server: Specify the name for the SQL Server to link.In this dialog box, set the following fields: In object explorer find your SQL Server instance ( up and running )Ĭlick Server Objects -> Linked Servers, right click and "New Linked Server "
SETTING UP MICROSOFT SQL SERVER MANAGEMENT STUDIO EXPRESS CODE
The provider supports the interface, but returns a failure code when it is used.įrom the Microsoft SQL Server Management Studio
OLE DB provider "ifxoledbc" for linked server "demo_on" returned message "EIX000: (-111) ISAM error: no record found.".Ĭannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "ifxoledbc" for linked server "demo_on". If the above script is not run against the IBM Infomrix Instance then the following error can be seen when attempting to select via a linked server. Note - This should be run on the Server with the Informix Instance ( not the Microsoft® SQL Server ) The coledbp.sql script can be found in the $INFORMIXDIR\etc directory of the Windows client machine where IBM Informix Client SDK or IBM Informix Connect is installed. Make sure that the coledbp.sql script has been run against the sysmaster database for the Informix Instance.įrom a command prompt run the appropriate regsvr32 application to register the Ifxoldbc provider. Make sure the Informix OLE DB provider has been registered.Make sure you have the correct Informix Client SDK (32 or 64 bit) for the SQL Server (32 or 64 bit) you are using.In order to set up a linked server from SQL Server the following checks need to be made.