Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HS ODBC - DBLINK
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