Microsoft Linked Servers
Posted on 2008-11-07
Hi, I'm select from a view in an oracle database using SQL Server 2005's openquery method.
select * from openquery(mylink,'select * from myview where reference = ''12124''')
mylink being a link to an Oracle 9i database. But using an 11i driver (as i'm doing this on a 64bit server)
The above returns 11 records. Which while the data appears correct, is out of date!
Using the same login details as the mylink, with sqlplus from the command line and the same sql (without the openquery) I get 5 records which is correct.
Any idea's at all?
I've restarted sql server already just incase it was caching result sets but now I'm at a loss. I'm awaiting an admin to restart Oracle, but would like any other ideas too.