have created a link between our Oracle DB and SQL server db
it was succussfulty created and i was able to select data from oracle table using SQLServer.
then i have created a view in sqlserver using this link to read from Oracle, the view was created
create view dah_test as (
SELECT count(*) as reg, semester FROM OPENQUERY( dah,'SELECT * from si_stu_major') group by semester
but when i tried to open the content it gives me the following error:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'OraOLEDB.Oracle' reported an error.
[OLE/DB provider returned message: ]
OLE DB error trace [OLE/DB Provider 'OraOLEDB.Oracle' IRowset::GetNextRows returned 0x80004005: ].