SQl to Oracle query part 2

[rchalker]

The query:
select * from localoracle..system.country

gets me

OLE DB provider 'MSDAORA' does not contain table '"system"."county"'.

In SQL Server Enterprise Manager Using the Linked Servers utility under Security I can 'see' the table. I linked using the 'system' id and the default password. Any suggestions?

 

[sgursahaney]

Any chance you may have spelled the table name wrong? Your query reads:

select * from localoracle..system.country

But your error message says:

OLE DB provider 'MSDAORA' does not contain table '"system"."county"'.

Note that the query is referencing the table "country" and the error message is showing the table "county" (Missing the "r&quot.

Regards,
Suresh