Re: Database Gateway for ODBC
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: dhandapani.shanmugam@xxxxxxx
- Date: Wed, 23 Jul 2008 10:42:05 -0700
On Wed, Jul 23, 2008 at 6:12 AM, Shanmugam, Dhandapani <
dhandapani.shanmugam@xxxxxxx> wrote:
> 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
>
>
Unless I am missing something, you seem to have ODBC confused with
database links.
The syntax you are using for the test SQL is for a database link.
Take a look at the docs under "CREATE DATABASE LINK"
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
