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