I have added a linked server to access an ODBC database.
This ODBC database points to an oracle 8i table.
Within the linked serve, I can see the tables.
But, when trying to select or insert from this table, I cant seem to get the syntax right... :(
eg SELECT * from [LINKEDTABLE]...[TABLENAME] fails
eg SELECT * from [LINKEDTABLE].[DATABASENAME]..[TABLENAME] fails
any help
guido