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 |
|
nagatinno
Starting Member
5 Posts |
 Posted - 2008-12-15 : 11:48:05
|
| Hi,I have a view which is create in Oracle, when i try to access the view from SQLSERVER i am unable to access the data but i am able to see the view structure. Am i missing something here?Thanks for your helpRegards,Nagesh Manda. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-15 : 11:51:00
|
| How are trying to access? using OPENROWSET or adding oracle db as a linked server? |
 |
|
|
nagatinno
Starting Member
5 Posts |
Posted - 2008-12-15 : 12:29:00
|
quote:
Originally posted by visakh16
How are trying to access? using OPENROWSET or adding oracle db as a linked server?
|
|
|
|
nagatinno
Starting Member
5 Posts |
Posted - 2008-12-15 : 12:30:33
|
quote:
Originally posted by nagatinno
[quote]Originally posted by visakh16
How are trying to access? using OPENROWSET or adding oracle db as a linked server?
Hi i am using linked server. I am able to view the view when i try to query the view i am unable to see the data. but when the acess the same view from oracle i am able to see the data. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-15 : 13:26:16
|
| are you getting any error or is it that query runs but you get no data from view? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-15 : 14:30:58
|
| Is the login used in Linked server has permission on oracle? |
|
|
|
nagatinno
Starting Member
5 Posts |
Posted - 2008-12-16 : 04:36:00
|
quote:
Originally posted by visakh16
are you getting any error or is it that query runs but you get no data from view?
Hi,I am not getting any error,but the query runs and i am unable to see any data.Regards,Nagesh Manda. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-16 : 04:52:41
|
| what happens when you try to query base tables directly? |
|
|
|
nagatinno
Starting Member
5 Posts |
Posted - 2008-12-16 : 09:42:38
|
quote:
Originally posted by visakh16
what happens when you try to query base tables directly?
Hi Visakh,I am able to see the data when i connect through TOAD using the same login details, but with the same login details i am unable to view the data from SQL Server2005. |
|
|
|
|
|
|
Unable to Acess View Created in Oracle from SQLSER