| how to connect OWB 10g Release 1 (10.1) to Microsoft files [message #177947] |
Sun, 18 June 2006 07:00  |
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. 
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
|
|
|
|
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
