Gibson Jonathan
2006-05-25 16:49:57 UTC
Hi everyone,
I hope someone can help with one as we've just spent a whole day trying
to figure out the problem to no avail.
We're trying to connect from a linux box running Red Hat Enterprise
linux 3 update 7 to an Ingres 2.0 database on an AIX platform. When we
configure the vnode and test it, everything comes back fine. When we
setup the odbc connection and test it, everything again works fine.
However, when we try to access the database from the command line on the
linux box by running isql <DSN_NAME> -v (that's the isql native to the
unixodbc and not ingres isql) it falls over with the error
[08004][unixODBC]ERget: Bad language found.ERget: Bad language found.
[ISQL]ERROR: Could not SQLConnect
and in the errlog.log on the linux box we get
svr554 ::[33064 IIGCN, 00000000]: Thu May 25 16:36:04 2006
E_GC0136_GCN_SVRCLASS_UNKNOWN User provided a server class as part of
the database name (dbname/class), but that server class is not known to
the Name Server.
svr554 ::[33064 IIGCN, 00000001]: Thu May 25 16:36:04 2006
E_CLFE07_BS_READ_ERR Read from peer process failed; it may have
exited.
We have this running fine from a UAT server. We've checked to make sure
that II_SYSTEM is set correctly, the PATH has the ingres bin and utility
directories set and II_TIMEZONE_NAME, II_INSTALLATION,
II_CHARSETII,II_TEMPORARY, IIGCNII_PORT and II_SHADOW_PDW are all set to
sensible variables.
The libc routines we have running are
bc-common-2.3.2-95.39
libcap-devel-1.10-15.1
glibc-utils-2.3.2-95.39
glibc-kernheaders-2.4-8.34.2
glibc-devel-2.3.2-95.39
glibc-2.3.2-95.39
libcap-1.10-15.1
glibc-profile-2.3.2-95.39
glibc-headers-2.3.2-95.39
The glibc versions on live are at .39 whereas the UAT are at .37 and
this is about the only difference we can see between the two systems.
Any thoughts would be greatly appreciated.
Cheers
Jon Gibson
Senior Database Administrator
Directline: 020 7448 6820
www.hiscox.com
-----Original Message-----
From: McInnes Iain
Sent: 25 May 2006 17:04
To: Gibson Jonathan
Subject: ISQL error
svr554 ::[33064 IIGCN, 00000000]: Thu May 25 16:36:04 2006
E_GC0136_GCN_SVRCLASS_UNKNOWN User provided a server class as part of
the database name (dbname/class), but that server class is not known to
the Name Server.
svr554 ::[33064 IIGCN, 00000001]: Thu May 25 16:36:04 2006
E_CLFE07_BS_READ_ERR Read from peer process failed; it may have
exited.
[08004][unixODBC]ERget: Bad language found.ERget: Bad language found.
[ISQL]ERROR: Could not SQLConnect
bc-common-2.3.2-95.39
libcap-devel-1.10-15.1
glibc-utils-2.3.2-95.39
glibc-kernheaders-2.4-8.34.2
glibc-devel-2.3.2-95.39
glibc-2.3.2-95.39
libcap-1.10-15.1
glibc-profile-2.3.2-95.39
glibc-headers-2.3.2-95.39
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. No one else is authorised to distribute, forward,
print, copy or act upon any information contained in this email.
If you have received this email in error, please notify the sender.
Hiscox Syndicates Limited, Hiscox Insurance Company Limited, Hiscox Underwriting Limited and Hiscox Investment Management Limited are authorised and regulated by the Financial
Services Authority. Hiscox plc is a company registered in England
and Wales under company registration number 2837811 and registered
office at 1 Great St Helen's, London EC3A 6HX
**********************************************************************
_____________________________________________________________________
This message has been checked for all known viruses by blue-source. For further information visit www.blue-source.com
powered by Messagelabs
I hope someone can help with one as we've just spent a whole day trying
to figure out the problem to no avail.
We're trying to connect from a linux box running Red Hat Enterprise
linux 3 update 7 to an Ingres 2.0 database on an AIX platform. When we
configure the vnode and test it, everything comes back fine. When we
setup the odbc connection and test it, everything again works fine.
However, when we try to access the database from the command line on the
linux box by running isql <DSN_NAME> -v (that's the isql native to the
unixodbc and not ingres isql) it falls over with the error
[08004][unixODBC]ERget: Bad language found.ERget: Bad language found.
[ISQL]ERROR: Could not SQLConnect
and in the errlog.log on the linux box we get
svr554 ::[33064 IIGCN, 00000000]: Thu May 25 16:36:04 2006
E_GC0136_GCN_SVRCLASS_UNKNOWN User provided a server class as part of
the database name (dbname/class), but that server class is not known to
the Name Server.
svr554 ::[33064 IIGCN, 00000001]: Thu May 25 16:36:04 2006
E_CLFE07_BS_READ_ERR Read from peer process failed; it may have
exited.
We have this running fine from a UAT server. We've checked to make sure
that II_SYSTEM is set correctly, the PATH has the ingres bin and utility
directories set and II_TIMEZONE_NAME, II_INSTALLATION,
II_CHARSETII,II_TEMPORARY, IIGCNII_PORT and II_SHADOW_PDW are all set to
sensible variables.
The libc routines we have running are
bc-common-2.3.2-95.39
libcap-devel-1.10-15.1
glibc-utils-2.3.2-95.39
glibc-kernheaders-2.4-8.34.2
glibc-devel-2.3.2-95.39
glibc-2.3.2-95.39
libcap-1.10-15.1
glibc-profile-2.3.2-95.39
glibc-headers-2.3.2-95.39
The glibc versions on live are at .39 whereas the UAT are at .37 and
this is about the only difference we can see between the two systems.
Any thoughts would be greatly appreciated.
Cheers
Jon Gibson
Senior Database Administrator
Directline: 020 7448 6820
www.hiscox.com
-----Original Message-----
From: McInnes Iain
Sent: 25 May 2006 17:04
To: Gibson Jonathan
Subject: ISQL error
svr554 ::[33064 IIGCN, 00000000]: Thu May 25 16:36:04 2006
E_GC0136_GCN_SVRCLASS_UNKNOWN User provided a server class as part of
the database name (dbname/class), but that server class is not known to
the Name Server.
svr554 ::[33064 IIGCN, 00000001]: Thu May 25 16:36:04 2006
E_CLFE07_BS_READ_ERR Read from peer process failed; it may have
exited.
[08004][unixODBC]ERget: Bad language found.ERget: Bad language found.
[ISQL]ERROR: Could not SQLConnect
bc-common-2.3.2-95.39
libcap-devel-1.10-15.1
glibc-utils-2.3.2-95.39
glibc-kernheaders-2.4-8.34.2
glibc-devel-2.3.2-95.39
glibc-2.3.2-95.39
libcap-1.10-15.1
glibc-profile-2.3.2-95.39
glibc-headers-2.3.2-95.39
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. No one else is authorised to distribute, forward,
print, copy or act upon any information contained in this email.
If you have received this email in error, please notify the sender.
Hiscox Syndicates Limited, Hiscox Insurance Company Limited, Hiscox Underwriting Limited and Hiscox Investment Management Limited are authorised and regulated by the Financial
Services Authority. Hiscox plc is a company registered in England
and Wales under company registration number 2837811 and registered
office at 1 Great St Helen's, London EC3A 6HX
**********************************************************************
_____________________________________________________________________
This message has been checked for all known viruses by blue-source. For further information visit www.blue-source.com
powered by Messagelabs