dbTalk Databases Forums  

connecting to 6.4 from 2.6 in esqlc

comp.databases.ingres comp.databases.ingres


Discuss connecting to 6.4 from 2.6 in esqlc in the comp.databases.ingres forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Dennis Roesler
 
Posts: n/a

Default connecting to 6.4 from 2.6 in esqlc - 03-09-2005 , 09:36 AM






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.

Thanks

Dennis
d underscore roesler at agilent dot com

Reply With Quote
  #2  
Old   
Karl & Betty Schendel
 
Posts: n/a

Default Re: [Info-ingres] connecting to 6.4 from 2.6 in esqlc - 03-10-2005 , 07:30 AM






At 10:36 AM -0500 3/9/2005, Dennis Roesler wrote:
Quote:
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?
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.

Karl


Reply With Quote
  #3  
Old   
Dennis Roesler
 
Posts: n/a

Default Re: [Info-ingres] connecting to 6.4 from 2.6 in esqlc - 03-10-2005 , 10:24 AM



Karl & Betty Schendel wrote:
Quote:
At 10:36 AM -0500 3/9/2005, Dennis Roesler wrote:

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?


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?
Yes :-). An ABF application is calling an esqlc procedure that is
defined in a library linked with the link-options functionality.

Quote:
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.
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.

Dennis


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.