Informix Connect w/ODBC on Remote-Host with SAS
Posted in 2004
Topics: Installation, Setup & Upgrades, Connectivity: ODBC / JDBC / .NET, Server Administration, Networking & sqlhosts Configuration, Platform-Specific Issues
Hello,
I'm a newbie to the field of informix and I've a question concerning
the connection between several Informix Database-Servers. I'm not
quiet sure if my problem is an informix issue. So let me tell about
our configuration.
We are running the statistic software SAS on a Solaris 5.8 box. We
have installed the SAS Release 8.2 and now (new) the Version 9.1.3
with the so called "access to informix" modul povided by sas to get
connections to several informix severs (soaris and Reliant unix).
Under 8.2 this works realy great!
We have informix database severs running informix 9.21 under solaris
(on the same machine as sas and on other similar solaris-servers) and
an older informix 7.31 running on Siemens Reliant Unix. The databases
on the Reliant box are unfortunately very important for our work. On
the the solaris maschine we had installed the IBM/Informix-Client SDK
Version 2.80.UC2, on the Reliant Maschine we are Running
INFORMIX-Client SDK Version 2.30.UC1. The SAS 8.2 "Access to Informix"
Software needs the sdk on the solaris box to connect to the database
servers.
Since we have installed the SAS Version 9.1.3 we have problem with the
connection to the databases on the reliant maschine. SAS 9 requires
the new 64bit(?)-SDK informixDS_cli2.81FC1 (This works not with the
old SAS 8.2). And the new SAS 9.1 "Access to Informix" software uses a
different way to connect to the databases. So we had to configure
datasources in the odbc.ini -file. We did that and we get a
connection to the databases on the same and other solaris boxes, but
we are unable to get a connection to the Reliant box with the Informix
7.31 Release running on it. When I try to connect to the reliant box
from my solaris account using dbaccess it is possible but when I use
SAS to make a connection I get an ODBC error:
CLI error trying to establish connection: [Informix][Informix ODBC
Driver][Informix]Server *servername* is not listed as a dbserver name
in sqlhosts.
I'm a little bit confused about that because *servername* is lisetd in
the sqlhost-file! One idea I had was, that the 64bit SDK on the
solaris box is not able to make a connection to the 32bit Reliant
System, but as I mentioned above, when I use dbacces it works. Another
Idea was, that something maybe wrong with the sqlhost file, so I've
overlooked it. There is a slight difference between the lines for the
databases serveres on the solarris boxes an the the lines for the
reliant system.
The line for the solaris based database serveres looks like
pp900_XXX ontlitcp Rechnername pp900_XXX g=dbserver17_grp
The line for the reliant based database serveres looks like
e100_amst ontlitcp Rechnername dbserver100 g=dbserver100_grp
I can find "pp900_XXX" and "dbserver100" in the etc/services but I
can't find
e100_amst in this file. There was a suggestion from the sas support
that there may be a problems with this in respect to the use of the
odbc driver but it looks like they are not sure.
Are there other possible reasons for our problem?
Hope my questions are not to confusing, I'm an statistician not an
IT-Expert.
Any help would be appreciated. Thanks in advance.
Peter