No no... I'm using a SAP DB ODBC to connect a MaxDB database. Oracle can connect to different database via ODBC. So I want to access a MaxDB database system by an Oracle environment using a DBLINK. See the link http://download-east.oracle.com/docs/cd/A87860_01/doc/server.817/a76960.pdf (Chapter 8).
I have two servers: 1) a Solaris SPARC v.7 (name klee) - on wich Oracle runs. 2) a Linux (name ottavia) - with MaxDB server on. I use the SAP DB ODBC 7.3.00 (ftp://ftp.sap.com/pub/sapdb/bin/sun/) and a MaxDB server 7.5.01.00. The odbc.ini file is setting like following: ---------------------------------------------------------------- [ODBC Data Sources] MaxDB=SapDB 7.3.00.48 ODBC Driver [MaxDB] ServerDB=TEST ServerNode=ottavia SQLMode=INTERNAL IsolationLevel=Committed TraceFileName=/ict/app/sdb/test.log ------------------------------------------------------------------ I seem to have problem with connect MaxDB database via ODBC. The error retrieved is: ERROR at line 1: ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC][SAP AG][LIBSQLOD SO][SAP DB]Unable to connect to data source;-709 CONNECT: (unknown host (see /etc/hosts)). (SQL State: 08001; SQL Code: -709) ORA-02063: preceding 2 lines from TMAXDB It seems a ODBC problem, not Oracle. Any idea? Thanks, Matteo ----- Original Message ----- From: "D�hr, Markus ICC-H" <[EMAIL PROTECTED]> To: "'Matteo Gattoni'" <[EMAIL PROTECTED]>; "D�hr, Markus ICC-H" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, September 10, 2004 6:53 PM Subject: RE: Solaris 7 compatibility > Using a database Oracle 9.2 instead of Oracle 8.1, I've received the > following error: So.. what are you exactly trying here? Using the SAPDB ODBC driver to connect to an Oracle database? This won't work and is expected to do not... Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus D�hr SAP-CC/BC, SAPDB-DBA Tel.: +49 6503 917-152 Fax: +49 6503 917-7152 E-Mail: [EMAIL PROTECTED] Internet: http://www.siegenia-aubi.com
