SQL Server four-part names
Posted in 2003
I have a linked server setup in SQL Server 2000 that points to my
Informix database. I am successful in querying data from my Informix
data source when querying with a pass-through query:
SELECT MyTable.* FROM OPENQUERY(<linked server name>, 'SELECT * FROM
customers') MyTable
I have not been successful in querying data with a four-part name
using this syntax:
SELECT * FROM <linked server name>.<data source name>.<owner>.<tablename>
I receive the following error when I attempt to query using this SQL
statement:
OLE DB provider 'MSDASQL' reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: [Informix][Informix ODBC
Driver][Informix]Database not found or no system permission.]
OLE DB error trace [OLE/DB Provider 'MSDASQL'
IDBSchemaRowset::GetRowset returned 0x80004005: ].
I am certain that the user account I am using to access the data
source is sufficient and I am certain that the table name is correct.
Perhaps my database owner is wrong? How do I obtain this information?
Any other suggestions?
Thanks in advance.
Scott Adams
I <> "The Dilbert Guy" AND I <> "Writer of the Adventure Series"