Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Other SQL Server 2008 Topics  Linked server to Informix problem (Msg 7313)

Author  Topic  PerBuus Starting Member 1 Post Posted - 2009-12-22 : 09:51:50 Hi, I have the following databases (Informix = DNS 10.00FC8 on Linux RedHat , MS SQL server= Version 2008 EXPRESS running on Windows 2003R2 SP2, I am using IBM Client version 3.5 TC4 to connect from Windows server to Linux). I setup the Informix database as a linked server on MSSQL using “Microsoft OLE DB provider for ODBC”. It works….but performance is bad, unless I use OPENQYERY from MSSQL like “select * from openquery(select * from mytable)". Is that normale that OPENQUERY works much better than a simple select? So I tried setting up the linked server using “Informix OLE DB Provider”. My connection is OK and OPENQUERY still works perfect. I believe, I should refer to tables in this format Linkedserver..tableowner.table . However I get this error message, when trying something like: select * from TEST3..informix.mytable; Msg 7313, Level 16, State 1, Line 1 An invalid schema or catalog was specified for the provider "Ifxoledbc" for linked server "TEST3". The really funny thing is that I actually manage to do a select from one table in Informix using format "select * from linkedserver..table", but it works only for one table!!! And the Informix DBA claims that this table is just like anyone else??? My only option is to use OPENQUERY, which would cause a lot of extra work for me. So any advice is greatly appriciated! Thanks! Per