Hello All -
I have a working linked server SQL2005 <--> Informix 10.0 and can use an OpenQuery statement to retrieve data. What I would prefer to do is a "Select * from ServerName.Database.Owner.Table" but this keeps throwing errors. I know almost nothing about Informix and am assuming that the Owner in this case is "Informix" (unlike dbo or root). Anyway - this does not work either. Can anybody offer a pointer in the correct direction?
Thanks in advance - Scott
I have a working linked server SQL2005 <--> Informix 10.0 and can use an OpenQuery statement to retrieve data. What I would prefer to do is a "Select * from ServerName.Database.Owner.Table" but this keeps throwing errors. I know almost nothing about Informix and am assuming that the Owner in this case is "Informix" (unlike dbo or root). Anyway - this does not work either. Can anybody offer a pointer in the correct direction?
Thanks in advance - Scott