Re: HS ODBC - DBLINK

cjn wrote:

> 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
>
>
> ?????
>
>

I can't help you here, except to say that sometimes tables in HS linked databases do not always behave like "normal" db linked tables. IIRC in my limited experience with this I could not do a select * from a table, but if I just named all of the columns it worked. I can't rememeber if the error was the same as yours or not. You might want to try metalink forums and see if someone from Oracle can explain this better. Received on Fri Sep 24 2004 - 09:28:01 CDT