Re: HS ODBC - DBLINK

Hello,

Finally, I succeed to get this message bu it doesn't work :

drop public database link msql;

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

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

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

The log files doesn't tell more.

Thanks for help.

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 Thu Sep 23 2004 - 12:04:10 CDT