Using a database Oracle 9.2 instead of Oracle 8.1, I've received the following error:
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) So the ODBC found by Oracle can't connect to the db. But the parameters passed to initialized the connection are right, as you see in the OBCD.ini reported in the previous email. Could it be due to the location of the file odbc.ini (/opt/odbc)? Or other? Thanks, Matteo ----- Original Message ----- From: "Matteo Gattoni" <[EMAIL PROTECTED]> To: "Markus ICC-H" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, September 10, 2004 4:58 PM Subject: Re: Solaris 7 compatibility > Hello, > I've installed the SAP DB 7.3.00 and created an odbc.ini like following: > > ---------------------------------------------------------------- > [ODBC Data Sources] > MaxDB=SapDB 7.3.00.48 ODBC Driver > > [MaxDB] > ServerDB=TEST > ServerNode=10.0.0.195 > SQLMode=INTERNAL > IsolationLevel=Committed > TraceFileName=/ict/app/sdb/test.log > ------------------------------------------------------------------ > > I use it to create a db link in Oracle database using Generic Connectivity > via ODBC. > As I use this connection, I receive the following Oracle error: > > ORA-02068: following severe error from TMAXDB > ORA-28511: lost RPC connection to heterogeneous remote agent using > SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=klee)(PORT=1522))(CONNECT_DATA > =(SI > D=TESTMAXDB))) > > where TESTMAXDB is SID identifying the MaxDB ODBC. > > I can't find nothing wrong in Oracle set up. > Could the different version between MaxDB ODBC and the MaxDB server be the > clou? > Is the odbc.ini definition right? > > Thanks. > Matteo > > > ----- Original Message ----- > From: "Koetter, Thomas Theodor" <[EMAIL PROTECTED]> > To: "'Matteo Gattoni'" <[EMAIL PROTECTED]>; "Markus ICC-H" > <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Wednesday, September 08, 2004 6:00 PM > Subject: RE: Solaris 7 compatibility > > > Hi, > > FYI, you can try the ODBC driver of SAP DB 7.3.00: > ftp://ftp.sap.com/pub/sapdb/bin/sun/ > > It works with MaxDB, too. > The ODBC driver is part of the webtools-package. > > > Regards Thomas > > > ---------------------------------------------- > Dr. Thomas K�tter > SAP AG, SAP Labs Berlin > > > Do you know SAP^H^H^H MaxDB ? www.sapdb.org > > > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
