SQL Integration with Oracle10g
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: ].
Software/Hardware used:
Software/Hardware used:
ASKED:
August 23, 2008 7:17 AM
UPDATED:
August 24, 2008 12:41 AM
Answer Wiki:
Referring back to your old post (sorry, but for some reason I don't get the alerts from the ITKE system).
In order for SQL to read from Oracle you do not need a link from Oracle to SQL.
Based on the error you provided it sounds like you've got the Schema name incorrect. Don't forget that Oracle is case sensitive, so if you put the schema in lower case when it should be upper case it will give you an error message.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
