Database Software

Hello ,

I would like to extract the data from Sybase DB to Oracle DB through OWB but I got a connectivity problem. Please see the below information.

When I create the Oracle warehouse Builder ODBC source (Database -> Other -> ODBC) in "New Module Wizard", there is an error message when I click "Create and Test".
Therefore ,
1) Click "New module Wizard"
2) keyin module name "tmis"
3) Click "New DB Link"
4) Keyin DB Link name "tmis5_dblnk"
5) Click "Host Name"
6) Keyin hostname "localhost"
7) Keyin sybase username & password
8) Click "Create and Test"
9) See the below error message

+++++++++++++++++++++++++++++++++++++++++++
Testing...
Failed.
SQL Exception
Repository Error:SQL Exception..
Class Name: CacheMediator.
Method Name: getDDEntryFromDB.
Repository Error Message: ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][MERANT][ODBC Sybase ASE driver]Login Failed, Check for vaild user ID, server name and password (SQL State: HY000; SQL Code: 0)
ORA-02063: preceding 2 lines from TMIS5_DBLNK
+++++++++++++++++++++++++++++++++++++++++++

I have checked the user ID , server name and password. All of them are valid. Also , I have tested the Sybase driver on ODBC Administrator. The "test connect" is OK.

(Just FYI , I am OK to setup an MS Access or MS Excel ODBC connection and can extract data from them to the Oracle DW without problems and I have read the document http://www.oracle.com/technology/products/warehouse/pdf/Cases/case3.pdf.)

Configuartion
==========
Windows 2k server
Sybase pcclient ASE version 12.5
Sybase ASE ODBC driver 3.70.00.20
Sybase database (Source) version 12.5
Oracle warehouse builder 9.2.0.2.8
Oracle database 9.2.0.1.0
System ODBC DSN name : TMIS (Windows 2k platform)

Heterogeneous Service initialization file : inittmis_sid.ora
=========================================
HS_FDS_CONNECT_INFO = TMIS
HS_AUTOREGISTER =TRUE
HS_DB_NAME = hsodbc
HS_FDS_TRACE_LEVEL = 0

listener.ora
========
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC=
(SID_NAME=tmis_sid)
(ORACLE_HOME = d:\oracle\ora92)
(PROGRAM=hsodbc)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\ora92)
(PROGRAM = extproc)
)
)

Sybase ODBC configuration
=====================
ODBC driver : Sybase ASE ODBC Driver version 3.70.00.20
Network Library Name : Winsock
Network Address : BATHK3.FE.BATGEN.COM,21001
Database Name : db_tmis
Status : "Connection established" when click "Test COnnect". ( There is no problem when I use Excel application to extract data from Sybase to MS Excel document through this ODBC configuration)

What can I do so that it can be "Created and Tested" on OWB successfully ? What version of the Sybase client does OWB support ? Please share your experience. Thanks a lot!

Dan