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@hsodbc;
select * from cond@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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
