SQL Integration with Oracle10g

35 pts.
Tags:
Database
Oracle
Oracle Application Server
SQL Server
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: ].

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following