Hi all, please help if anyone can, I am sure here are masters
i create linked server to access file in which I have localtalbes, linked tables to oracle dband linked tables to SQL DB, I can query all locals and SQL talbes from this linked server but when I try to query
"SELECT * FROM TEST1...VASO_LOAN_UPDATES"
where "VASO_LOAN_UPDATES" is linked table to oracle DB
I receive error
"Msg 7306, Level 16, State 2, Line 1 Cannot open the table "VASO_LOAN_UPDATES" from OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TEST1". The specified table or view does not exist or contains errors."
how can I fix it? Tnx advance