|
|
Posted by ecnaL on 11/15/05 00:35
This reply may be a bit late, but may help others....
The pass through value should not be enclosed in double-quotes; Oracle will think this is a column name (which is why you get the error message "Invalid Column Name").
You are probably using an SQL Statement like:
SELECT *
FROM OPENQUERY(LINKED_DB, 'SELECT *
FROM SCHEMA.TABLE
WHERE VALID_COLUMN = "27387M"')
Try this:
SELECT *
FROM OPENQUERY(LINKED_DB, 'SELECT *
FROM SCHEMA.TABLE
WHERE VALID_COLUMN = '''27387M''') <--- note the use of two single quotes, not double quotes.
Good luck from Melbourne AUstralia.
Navigation:
[Reply to this message]
|