RE: Database Gateway for ODBC
- From: "Shanmugam, Dhandapani" <dhandapani.shanmugam@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Jul 2008 18:42:13 +0530
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Barbour
Sent: Monday, July 14, 2008 8:35 PM
To: Shanmugam, Dhandapani
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxx> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
