Home » Developer & Programmer » Warehouse Builder » how to connect OWB 10g Release 1 (10.1) to Microsoft files  () 1 Vote
how to connect OWB 10g Release 1 (10.1) to Microsoft files [message #177947] Sun, 18 June 2006 07:00 Go to next message
Messages: 2
Registered: June 2006
Junior Member
Hi all,

I am trying to connect the OWB to Microsoft Excel file, I got the error:- SQL Exception. Embarassed

The steps I followed was
1) I created DSN for my Excel File as ODBC2XL ( I configure the Excel file which is available in my Desktop.)

2) I created initExcel_SID.ora file in the D:\Oracle\product\10.1.0\OracleDb10g\hs\admin
such as
HS_DB_NAME = hsodbc

3) I created listener in D:\Oracle\product\10.1.0\OracleDb10g\NETWORK\ADMIN
such as
(PROGRAM = hsodbc)
(SID_NAME = Excel_SID)
(ORACLE_HOME = D:\oracle\product\10.1.0\OracleDb10g)
(PROGRAM = extproc)
(ORACLE_HOME = D:\oracle\product\10.1.0\OracleDb10g)

4) Then I created an ODBC Source Module and a Database Link
Such as
DB Link Name : EX2OWB_LINK1
Host Name : RAJKUMAR
Port Number : 1521
Oracle Service Name : Excel_SID

Enable the Use for Heterogeneous Services

User Name : scott
Password : tiger

If I test this, i got following error.

Testing ....
SQL Exception
Repository Error. SQL Exception.
Class Name : Cache Mediator.
Method Name : getDDEntryFromDB.
Repository Error Message : ORA-28545: error diagnosed by Net8 when connecting to an agent
NCRO: Failed to make RSLV connection
ORA-02063: preceding 2 lines from EXL2OWB_LINK1

Can any one help me for the above problem and
Kindly send the steps for the above process. & How to access SQL Server 2000?

my email id is rajkumarms_mca@yahoo.com

Re: how to connect OWB 10g Release 1 (10.1) to Microsoft files [message #186986 is a reply to message #177947] Thu, 10 August 2006 07:59 Go to previous messageGo to next message
Messages: 14
Registered: August 2006
Junior Member
Hai Rajkumar,

I also got the same problem as you mentioned. Could you pelase explain me how can we resolve it?...its very urgent please...

Thanks and regards
Gowtham Sen
Re: how to connect OWB 10g Release 1 (10.1) to Microsoft files [message #193584 is a reply to message #177947] Mon, 18 September 2006 06:24 Go to previous message
Messages: 1
Registered: September 2006
Junior Member
hi rajkumar,
this is shiva. even I am facing the same problem when trying to connect to a sybase database with OWB. If you were able to solve this problem, could you please let me know what have you done to solve this.

thanks and warm regards,
Previous Topic: VLD-1141 Error message
Goto Forum:

Current Time: Thu Oct 08 22:58:11 CDT 2015

Total time taken to generate the page: 0.12004 seconds