Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: HS ODBC - DBLINK

Re: HS ODBC - DBLINK

From: cjn <anne-marie.caujan_at_ago.fr>
Date: 23 Sep 2004 23:22:38 -0700
Message-ID: <716b9c94.0409232222.744630a3@posting.google.com>


Hello,

I check everything, and now I got this message :

SQL>
SQL> CREATE PUBLIC DATABASE LINK msql connect to "admin" identified by "admin"

  2     using '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)
  3      (PORT=1521))(CONNECT_DATA=(SID=msql))(HS=OK))';

Database link created.

SQL>
SQL> select * from toto_at_msql;
select * from toto_at_msql

              *
ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC][S1000] [9013]General error in nvITrans_BeginT - rc = -1. Please
refer to the log file for details.
ORA-02063: preceding 2 lines from MSQL

?????

Glen A Stromquist <glen_stromquist_at_no_spam_yahoo.com> wrote in message news:<sVf4d.73276$KU5.46996_at_edtnps89>...
> cjn wrote:
>
> > Hello Niall,
> >
> > That's what I've made, of course : I have created an initmsql.ora
> > and set HS_FDS_CONNECT_info = msql. My DSN calls msql too. It's very
> > strange...
> >
> > Have someone one idea please ?
> >
>
> Double check everything you've done and compare it to the steps here:
> http://download-west.oracle.com/docs/cd/A87860_01/doc/network.817/a76933/advcfg.htm#474076
> or on Niall's link, if either of those don't work log an iTar with Oracle.
>
> hth
Received on Fri Sep 24 2004 - 01:22:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US