Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
deepnight
Starting Member
2 Posts |
 Posted - 2004-12-16 : 05:43:08
|
| I setup a linkedserver to access some views in a Oracle.Most of the views work well, except one.When i log in SQL Plus and 'select * from thisview', i can get all the records, while i use linkedserver to query[ select * from openquery( myLink, 'select * from thisview') ], it returns none records. I can't believe my eye.myLink use the same user/password as which i use to log in SQL Plus.What's wrong with it? Would you help me to solve this problem?Thanks a great lot! |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-12-16 : 08:06:55
|
| Try the following1>qualify the table name with the owner 'select * from owner.thisview'2>use proper case------------------------I think, therefore I am |
 |
|
|
deepnight
Starting Member
2 Posts |
Posted - 2004-12-17 : 05:04:57
|
| I have tried, but also failed. Unbelievable! |
|
|
|
|
|
|
No records return while query from linkedserver