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
keysoft
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_FDS_CONNECT_INFO = odbc2xl
HS_AUTOREGISTER = TRUE
HS_DB_NAME = hsodbc

3) I created listener in D:\Oracle\product\10.1.0\OracleDb10g\NETWORK\ADMIN
such as
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(PROGRAM = hsodbc)
(SID_NAME = Excel_SID)
(ORACLE_HOME = D:\oracle\product\10.1.0\OracleDb10g)
)
(SID_DESC =
(PROGRAM = extproc)
(SID_NAME = PLSExtProc)
(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 ....
Failed.
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

Regards,
Rajkumar
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
gowthamsen
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
bathinishiva
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,
shiva
Previous Topic: VLD-1141 Error message
Next Topic: ORACLE DISCOVERER & OWB
Goto Forum:
  


Current Time: Sat Sep 20 03:17:29 CDT 2014

Total time taken to generate the page: 0.09224 seconds