Hello, looking in the log, I've found some information. Connecting via ODBC (in Oracle environment), I found the same 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) ORA-02063: preceding 2 lines from TMAXDB Under [indep_data]/wrk/ora92, there's a file called appldiag. It contains the following error messages 2004-09-14 10:08:41 29113 ERR 11377 CONNECT TCP/IP host name 'MAXDB' not found 2004-09-14 10:08:41 29113 ERR 11377 CONNECT TCP/IP host name 'MAXDB' not found It seems that MaxDB ODBC doesn't look into ODBC.ini to traslate DNS name MAXDB into specified properties, but try to use it as host name. Obviously this is incorrect. ODBC.ini ---------------------------------------- [ODBC Data Sources] MAXDB=MaxDB v. xx [MAXDB] Driver=/ict/app/sdb/indep_prog/lib/libsqlod.so Description=MaxDbODBCDriver ServerDB=TEST ServerNode=ottavia SQLMode=INTERNAL IsolationLevel=Committed TraceFileName=/ict/app/sdb/test.log ------------------------------------- What Have I missed? As MaxDB documentation said, I could use MaxDB ODBC with or without ODBC Driver Manager (like unixODBC, iODBC). I didn't use any ODBC Driver Manager. Could it be usefull using it? How could I manage it? ----- Original Message ----- From: "Matteo Gattoni" <[EMAIL PROTECTED]> To: "Markus ICC-H" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, September 13, 2004 9:31 AM Subject: Re: Solaris 7 compatibility > Hello, > I've yet done it... but it doesn't work (both putting IP/host combination > in etc/host and putting IP in odbc.ini nstead of host). > > Best regards, > Matteo > > ----- Original Message ----- > From: "D�hr, Markus ICC-H" <[EMAIL PROTECTED]> > To: "'Matteo Gattoni'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Friday, September 10, 2004 7:14 PM > Subject: RE: Solaris 7 compatibility > > > > 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. > > You seem to connect via name, not via IP. Enter the IP/host combination in > /etc/hosts and try again. > > > 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 > > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
