Re: Database Gateway for ODBC
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: dhandapani.shanmugam@xxxxxxx
- Date: Wed, 23 Jul 2008 15:11:15 -0700
Well I was missing something.
I didn't realize 'ODBC gateway' is an distinct bit of technology that
looks like a dblink from the sqlplus command line.
Oh well, I know now. :)
On Wed, Jul 23, 2008 at 10:42 AM, Jared Still <jkstill@xxxxxxxxx> wrote:
> 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
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
