Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Linked Server SQL2005 Select

Status
Not open for further replies.

buddafish

Programmer
Apr 26, 2002
478
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top