[Info-ingres] connecting to 6.4 from 2.6 in esqlc


    Sponsored Links


  • 1. employment? ingres programmer?
    hi anyone know if there is an ingres abf sql isql osq programming job available out there? email XXXX@XXXXX.COM
  • 2. Ingres / Oracle Replicator
    Does anyone know of a good (the best) replication product that can replicate date between Ingres/Oracle?
  • 3. Netutil error
    Hi all, Test connection is getting failed while testing a virtual node and following message is flashing: The connection to the name server on 'dev1' has failed. E_GC2819_NTWK_CONNECTION_FAIL Unable to establish network connection: See errlog.log for detail. In error log following msg found : E_GC2809_NTWK_C ONNECTION_FAIL Network connection failed for protocol TCP_IP, to node dev1, por t mx; status follows. rmpunx02::[ , 00000000]: Thu Sep 18 14:49:09 2003 E_CLFE0B_BS_NOH OST Host name unknown or illegal. Kindly let me know what is wrong or am I missing something. TIA Vikas
  • 4. Table count
    Good morning, Nothing terribly pressing, but I need a quick table count from db mk, where the table name ends in 110, or 000. The table name format, if it's important, is ttxxyyynnn110 or ttxxyyynnn000. Thanks in advance, Mike Ossing Rodem, Inc. 513-922-6140

Re: [Info-ingres] connecting to 6.4 from 2.6 in esqlc

Postby Karl & Betty Schendel » Fri, 11 Mar 2005 22:30:53 GMT

I seem to recall running into this back when OI 1.2 was new.  I suspect
it's sort-of a feature.  What's doing the connection, ABF or esqlc?

Our situation was that since there was no ABF session switching in 6.4,
the app called an ESQLC procedure that did the switching.  This broke
when 1.2 came along.  We changed the app to use the ABF supplied features
for session switching and that made it work, so we never bothered to
figure out what was going on.


Re: [Info-ingres] connecting to 6.4 from 2.6 in esqlc

Postby Dennis Roesler » Sat, 12 Mar 2005 01:24:40 GMT

Yes :-).  An ABF application is calling an esqlc procedure that is 
defined in a library linked with the link-options functionality.

We are doing this where possible in other places in the abf applications.

I was just curious if there was a known reason why a connect would work 
in isql/sql but not in esqlc.


Similar Threads:

1.connecting to 6.4 from 2.6 in esqlc

Version: II 2.6/0305 (hpb.us5/00)
OS: HP-UX 11.11

We have an abf application that does session switching through an esqlc 
procedure.  When it tries to connect to a vnode that has a 6.4 
installation on the other end the connection fails.  From isql or sql 
command prompt there is no problem connecting to a 6.4 installation from 
2.6 through the same vnode.  Is this a feature or a bug?

The sqlcode is -39100 (which has no meaningful description).

The E_ error message is: E_US0022 Either the flag format or one of the 
flags is incorrect, or the parameters are not in proper order.

The application logs certain data to a log file among which is the 
connect string, so I know the connect string is in the right order.  If 
we change the vnode definition to point to a 2.6 database there is no error.


d underscore roesler at agilent dot com

2.[Info-ingres] Binairy unload from hp/ux 6.4 to Linux 2.6

3.[Info-ingres] Differences between 6.4 and 2.6

4.Binairy unload from hp/ux 6.4 to Linux 2.6

I did the copy from the Linux-machine through the vnode I configured.
Total success! Very simple and effecient!

5.Differences between 6.4 and 2.6

6. Binairy unload from hp/ux 6.4 to Linux 2.6

7. [Info-ingres] ABF Ingres 6.4 home grown application

8. [Info-ingres] Strange locking in Ingres 6.4/06

Return to DATABASE


Who is online

Users browsing this forum: No registered users and 60 guest