RE: Connecting INGRES using database link

From: Bellows, Bambi <BBellows_at_usg.com>
Date: Wed, 23 Jan 2002 10:41:49 -0800
Message-ID: <F001.003F8D8A.20020123100209@fatcity.com>

Golly, that looks an awful lot like VMS. I think what it's trying to tell you is that the node you specified is not reachable, or that the SID you've specified is not on the node listed. There's some kind of connection problem there. Try doing a select from the Ingres side over the connection. If it works, I don't know what to tell you. If it fails, drop and recreate the connection string.

The important thing is that this error is NOT an Oracle error... it is a wrapper around what it's getting from the Ingres side... and it looks for all the world like it's not purely an Ingres error either. That "E_" is a VMS level error (W would be "warning", F would be "fatal"). Unfortunately, I've been largely off of VMS since 93, so I'm not going to be able to help a lot there either.

Wish you would have asked this question about 10 years ago... ;) Bambi.

-----Original Message-----
Sent: Tuesday, January 22, 2002 9:05 PM
To: Multiple recipients of list ORACLE-L

thank you Bambi.

I already tried to create database link using HSODBC, but failed. It returned this messages :

SQL> select * from cond_at_hsodbc;
select * from cond_at_hsodbc

ERROR at line 1:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Generic Connectivity Using ODBC]DRV_InitTdp: [INTERSOLV][ODBC INGRES driver][INGRES]E_LQ0001 Failed to connect to DBMS session. E_LC0001 GCA protocol service (GCA_REQUEST) failure. Internal service status E_GC0132 -- User provided a vnode as part of the database name (vnode::dbname), but connection information for that vnode i (SQL State: S1000; SQL Code: -38100)
ORA-02063: preceding 6 lines from HSODBC

Is someone familiar with this kind of error...

TIA, Holly

-----Original Message-----
Sent: Wednesday, January 23, 2002 4:20 AM To: Multiple recipients of list ORACLE-L

Holly --

It has been a long time since I have done Oracle and Ingres at the same time
(about 12 years (Oracle v6/Ingres v5)). Back then, while there was "kinda-sorta" ODBC to and from both Oracle and Ingres, they weren't able to
access each other directly. Generally, data transfers were to and from flat
files, and queries between objects in the two databases utilized a third party tool (Passport).

HTH,
Bambi.

-----Original Message-----
Sent: Monday, January 21, 2002 9:40 PM
To: Multiple recipients of list ORACLE-L

Dear all,
Can I create database link using generic connectivity (ODBC)? Was there someony already try this?
I'm using oracle 8.1.6 on WIN2K box with INGRES NET, and INGRES 6.4 on VAX/VMS. TIA, Holly
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ahmadsyah Alghozi Nugroho
INET: Ahmadsyah.Nugroho_at_vico.co.id

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Bellows, Bambi
INET: BBellows_at_usg.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------