RE: Database Gateway for ODBC

From: Shanmugam, Dhandapani <dhandapani.shanmugam_at_eds.com>
Date: Wed, 23 Jul 2008 18:42:13 +0530
Message-ID: <AC455BF47A745941B9FB331A436626380295809F@inpnm231.apac.corp.eds.com>

Hi,

Thanks for the update. After the installation of the ODBC driver, when i tried the connection am getting an error. It is reporting connection error. Kindly suggest me on that

SQL> select count(1) from "mails"@DHAN;
select count(1) from "mails"@DHAN
*
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve text of NETWORK/NCR message 65535 ORA-02063: preceding 2 lines from DHAN

bash[]> tnsping DHAN
TNS Ping Utility for Solaris: Version 10.2.0.3.0 - Production on 21-JUL-2008 07:11:32
Copyright (c) 1997, 2006, Oracle. All rights reserved. Used parameter files:
/var/opt/oracle/sqlnet.ora
Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
(PROTOCOL = TCP) (HOST = corpsify.corp.sify.com) (PORT = 1521)))
(CONNECT_DATA = (SID= DHAN)) (HS=OK))

OK (0 msec)

bash[]> tnsping KUMA
TNS Ping Utility for Solaris: Version 10.2.0.3.0 - Production on 21-JUL-2008 07:11:37
Copyright (c) 1997, 2006, Oracle. All rights reserved. Used parameter files:
/var/opt/oracle/sqlnet.ora
Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =
(PROTOCOL = TCP) (HOST = corpsify.corp.sify.com) (PORT = 1521)))
(CONNECT_DATA = (SID= KUMA)) (HS=OK))

OK (0 msec)

My TNS Entires are below

DHAN.CORP.SIFY.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = corpsify.corp.sify.com)
(PORT = 1521)

)
)
(CONNECT_DATA =
(SID= DHAN)

)
(HS=OK)

)

KUMA.CORP.SIFY.COM =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = corpsify.corp.sify.com)
(PORT = 1521)

)
)
(CONNECT_DATA =
(SID= KUMA)

)
(HS=OK)

)  

Regards,
DD  

---

        From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Barbour

	Sent: Monday, July 14, 2008 8:35 PM
	To: Shanmugam, Dhandapani
	Cc: oracle-l_at_freelists.org
	Subject: Re: Database Gateway for ODBC
	
	
	Suggest you start at otn.oracle.com.  Search for database

gateways. Find the one you need. Get the documentation. Try to install it. Then ask for help/guidance/information on specifics.                  

        On Mon, Jul 14, 2008 at 10:14 AM, Shanmugam, Dhandapani <dhandapani.shanmugam_at_eds.com> wrote:         

                Hi,

                How to Obtain and install the Database Gateway for ODBC for 9.2.0.8 Oracle on Solaris 5.10 server. Also please guide me on the installation steps.

		Thanks and Regards,
		DD 


	
	The information contained in this message and any attachment may
be
	proprietary, confidential, and privileged or subject to the work
	product doctrine and thus protected from disclosure.  If the
reader
	of this message is not the intended recipient, or an employee or
	agent responsible for delivering this message to the intended
	recipient, you are hereby notified that any dissemination,
	distribution or copying of this communication is strictly
prohibited.
	If you have received this communication in error, please notify
me
	immediately by replying to this message and deleting it and all
	copies and backups thereof.  Thank you.
	
	

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jul 23 2008 - 08:12:13 CDT