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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Connecting INGRES using database link

RE: Connecting INGRES using database link

From: Jenner Mike <M.Jenner_at_southampton.gov.uk>
Date: Thu, 24 Jan 2002 07:10:56 -0800
Message-ID: <F001.003F9CAC.20020124062524@fatcity.com>

Holly,

        I subscribe to the info-ingres_at_ams.org ingres dba list. I can't find out how you can subscribe though, sorry! (no, It's not in any trailer or signature) Maybe a search engine will find something.

        It's fairly low traffic compared to this list but there are some peeps who know their ingres stuff (unlike me).

-----Original Message-----
Sent: 24 January 2002 03:55
To: Multiple recipients of list ORACLE-L

Dear Bambi,
Unfortunatly, 10 years ago I still a kid.. ^_^ Did you know any web site/mailing list/or other resources relate with this problem (INGRES), so I can solve this problem?

Thanks in advance

Holly

-----Original Message-----
Sent: Thursday, January 24, 2002 1:02 AM To: Multiple recipients of list ORACLE-L

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 -------------------------------------------------------------------- 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: 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 -------------------------------------------------------------------- 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: 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: Jenner Mike INET: M.Jenner_at_southampton.gov.uk 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).
Received on Thu Jan 24 2002 - 09:10:56 CST

Original text of this message

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